UDQ-1
NVL(EXTN_ATTRIBUTE_NUMBER015/100,0) HZ_REF_ENTITIES ATTRIBUTE_CATEGORY = 'OrderBasedAdjustmentOBA_c'
AND CREATION_DATE = (
SELECT MAX(e1.CREATION_DATE)
FROM HZ_REF_ENTITIES e1
WHERE e1. ATTRIBUTE_CATEGORY = 'OrderBasedAdjustmentOBA_c'
AND (
(:2/*Number*/ IS NULL AND
e1. EXTN_ATTRIBUTE_CHAR011 =:1/*VARCHAR2*/ AND
e1. EXTN_ATTRIBUTE_NUMBER007 IS NULL AND
e1. EXTN_ATTRIBUTE_NUMBER008 = (
SELECT TO_NUMBER(a.HR_PRIMARY_WORKER_NUMBER)
FROM CN_SRP_PARTICIPANTS_ALL a
WHERE a.PARTICIPANT_ID =:3/*Number*/
AND a. ORG_ID =:4/*Number*/
)
)
OR
(:2/*Number*/ IS NOT NULL AND
e1. EXTN_ATTRIBUTE_CHAR011 =:1/*VARCHAR2*/ AND
e1. EXTN_ATTRIBUTE_NUMBER007 =:2/*Number*/ AND
e1. EXTN_ATTRIBUTE_NUMBER008 = (
SELECT TO_NUMBER(a.HR_PRIMARY_WORKER_NUMBER)
FROM CN_SRP_PARTICIPANTS_ALL a
WHERE a.PARTICIPANT_ID =:3/*Number*/
AND a. ORG_ID =:4/*Number*/
)
) ) )
Comments
Post a Comment