APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELE_CLASSIFICATION_RULES

Line 594: from pay_ele_classification_rules

590: select pet1.element_type_id
591: from pay_element_types_f pet1
592: where pet1.classification_id in
593: (select classification_id
594: from pay_ele_classification_rules
595: where element_set_id = cp_element_set_id)
596: and pet1.element_name not like '%Special Features'
597: and pet1.element_name not like '%Special Inputs'
598: and pet1.element_name not like '%Withholding'

Line 793: from pay_ele_classification_rules

789: select pet1.element_type_id
790: from pay_element_types_f pet1
791: where pet1.classification_id in
792: (select classification_id
793: from pay_ele_classification_rules
794: where element_set_id = cp_element_set_id)
795: minus
796: select petr.element_type_id
797: from pay_element_type_rules petr

Line 839: from pay_ele_classification_rules

835: select pet1.element_type_id
836: from pay_element_types_f pet1
837: where pet1.classification_id in
838: (select classification_id
839: from pay_ele_classification_rules
840: where element_set_id = cp_element_set_id)
841: minus
842: select petr.element_type_id
843: from pay_element_type_rules petr

Line 949: from pay_ele_classification_rules

945: pay_element_types_f_tl pettl1
946: where cp_business_group_id = nvl(pet1.business_group_id, cp_business_group_id)
947: and pet1.classification_id in
948: (select classification_id
949: from pay_ele_classification_rules
950: where element_set_id = cp_ele_set_id)
951: and pet1.element_name not like '%Special Features'
952: and pet1.element_name not like '%Special Inputs'
953: and pet1.element_name not like '%Withholding'