DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 1536: FROM pay_element_type_rules ETR

1532: AND pet1.classification_id = ECR.classification_id
1533: AND NOT EXISTS
1534: (
1535: SELECT NULL
1536: FROM pay_element_type_rules ETR
1537: WHERE ETR.element_set_id = p_ele_set_id
1538: AND ETR.element_type_id = pet1.element_type_id
1539: AND ETR.include_or_exclude = 'E'
1540: )

Line 1543: FROM pay_element_type_rules ETR

1539: AND ETR.include_or_exclude = 'E'
1540: )
1541: UNION
1542: SELECT NULL
1543: FROM pay_element_type_rules ETR
1544: WHERE ETR.element_set_id = p_ele_set_id
1545: AND ETR.element_type_id = pet1.element_type_id
1546: AND ETR.include_or_exclude = 'I'
1547: )