DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 103: FROM pay_element_classifications_tl pect

99: ,cp_classification_name VARCHAR2 ) IS
100: SELECT pec.classification_id
101: ,pec.classification_name
102: ,pect.language
103: FROM pay_element_classifications_tl pect
104: ,pay_element_classifications pec
105: WHERE pect.classification_name = cp_classification_name
106: AND pec.classification_id = pect.classification_id
107: AND ( pec.legislation_code = cp_legislation_code OR

Line 104: ,pay_element_classifications pec

100: SELECT pec.classification_id
101: ,pec.classification_name
102: ,pect.language
103: FROM pay_element_classifications_tl pect
104: ,pay_element_classifications pec
105: WHERE pect.classification_name = cp_classification_name
106: AND pec.classification_id = pect.classification_id
107: AND ( pec.legislation_code = cp_legislation_code OR
108: pec.business_group_id = cp_business_group_id )

Line 167: FROM pay_element_classifications

163: ,cp_classification_name VARCHAR2 ) IS
164: SELECT default_priority
165: ,default_high_priority
166: ,default_low_priority
167: FROM pay_element_classifications
168: WHERE legislation_code = cp_legislation_code
169: AND classification_name = cp_classification_name;
170:
171: CURSOR get_rule_mode ( cp_legislation_code VARCHAR2 ) IS