APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELE_CLASSIFICATION_RULES

Line 585: from pay_ele_classification_rules

581: select pet1.element_type_id
582: from pay_element_types_f pet1
583: where pet1.classification_id in
584: (select classification_id
585: from pay_ele_classification_rules
586: where element_set_id = cp_element_set_id)
587: and pet1.element_name not like '%Special Features'
588: and pet1.element_name not like '%Special Inputs'
589: and pet1.element_name not like '%Withholding'

Line 784: from pay_ele_classification_rules

780: select pet1.element_type_id
781: from pay_element_types_f pet1
782: where pet1.classification_id in
783: (select classification_id
784: from pay_ele_classification_rules
785: where element_set_id = cp_element_set_id)
786: minus
787: select petr.element_type_id
788: from pay_element_type_rules petr

Line 830: from pay_ele_classification_rules

826: select pet1.element_type_id
827: from pay_element_types_f pet1
828: where pet1.classification_id in
829: (select classification_id
830: from pay_ele_classification_rules
831: where element_set_id = cp_element_set_id)
832: minus
833: select petr.element_type_id
834: from pay_element_type_rules petr

Line 940: from pay_ele_classification_rules

936: pay_element_types_f_tl pettl1
937: where cp_business_group_id = nvl(pet1.business_group_id, cp_business_group_id)
938: and pet1.classification_id in
939: (select classification_id
940: from pay_ele_classification_rules
941: where element_set_id = cp_ele_set_id)
942: and pet1.element_name not like '%Special Features'
943: and pet1.element_name not like '%Special Inputs'
944: and pet1.element_name not like '%Withholding'