DBA Data[Home] [Help]

APPS.PAY_IP_ELE_INFO_CAT_UPG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 78: pay_element_classifications pec

74:
75: CURSOR csr_ele_class_qualified IS
76: SELECT 'Y'
77: FROM pay_element_types_f pet,
78: pay_element_classifications pec
79: WHERE pet.element_type_id = p_object_id
80: AND pec.classification_id = pet.classification_id
81: AND pec.classification_name IN ('Earnings',
82: 'Supplemental Earnings',

Line 154: pay_element_classifications pec,

150: CURSOR csr_legislation_code IS
151: SELECT upper(pbg.legislation_code),
152: upper(pec.classification_name)
153: FROM pay_element_types_f pet,
154: pay_element_classifications pec,
155: per_business_groups pbg
156: WHERE pet.element_type_id = p_object_id
157: AND pbg.business_group_id = pet.business_group_id
158: AND pec.classification_id = pet.classification_id