APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 117: FROM pay_element_classifications_tl pect

113: ,cp_classification_name VARCHAR2 ) IS
114: SELECT pec.classification_id
115: ,pec.classification_name
116: ,pect.language
117: FROM pay_element_classifications_tl pect
118: ,pay_element_classifications pec
119: WHERE pect.classification_name = cp_classification_name
120: AND pec.classification_id = pect.classification_id
121: AND ( pec.legislation_code = cp_legislation_code OR

Line 118: ,pay_element_classifications pec

114: SELECT pec.classification_id
115: ,pec.classification_name
116: ,pect.language
117: FROM pay_element_classifications_tl pect
118: ,pay_element_classifications pec
119: WHERE pect.classification_name = cp_classification_name
120: AND pec.classification_id = pect.classification_id
121: AND ( pec.legislation_code = cp_legislation_code OR
122: pec.business_group_id = cp_business_group_id )

Line 181: FROM pay_element_classifications

177: ,cp_classification_name VARCHAR2 ) IS
178: SELECT default_priority
179: ,default_high_priority
180: ,default_low_priority
181: FROM pay_element_classifications
182: WHERE legislation_code = cp_legislation_code
183: AND classification_name = cp_classification_name;
184:
185: CURSOR get_rule_mode ( cp_legislation_code VARCHAR2 ) IS

Line 237: pay_element_classifications pec

233: cp_business_grp_id NUMBER) IS
234: SELECT pet.element_type_id,
235: upper(pec.classification_name)
236: FROM pay_element_types_f pet,
237: pay_element_classifications pec
238: WHERE pet.element_name = cp_element_name
239: AND pet.business_group_id = cp_business_grp_id
240: AND pec.classification_id = pet.classification_id;
241: