DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 1505: FROM pay_element_type_rules ETR

1501: AND pet1.classification_id = ECR.classification_id
1502: AND NOT EXISTS
1503: (
1504: SELECT NULL
1505: FROM pay_element_type_rules ETR
1506: WHERE ETR.element_set_id = p_ele_set_id
1507: AND ETR.element_type_id = pet1.element_type_id
1508: AND ETR.include_or_exclude = 'E'
1509: )

Line 1512: FROM pay_element_type_rules ETR

1508: AND ETR.include_or_exclude = 'E'
1509: )
1510: UNION
1511: SELECT NULL
1512: FROM pay_element_type_rules ETR
1513: WHERE ETR.element_set_id = p_ele_set_id
1514: AND ETR.element_type_id = pet1.element_type_id
1515: AND ETR.include_or_exclude = 'I'
1516: )