APPS.PER_ASG_AGGR dependencies on PAY_ELEMENT_TYPES_F

Line 111: pay_element_links_f lnk, pay_element_types_f elt,

107: from
108: pay_element_entries_f ele,
109: pay_element_entry_values_f eev,
110: pay_input_values_f inv,
111: pay_element_links_f lnk, pay_element_types_f elt,
112: per_all_assignments_f paa,
113: pay_all_payrolls_f ppf,
114: hr_soft_coding_keyflex scl
115: where ele.element_entry_id = eev.element_entry_id

Line 183: pay_element_types_f elt,

179: CURSOR cur_paye_element_link IS
180: select count(*)
181: from pay_element_entries_f ele,
182: pay_element_links_f lnk,
183: pay_element_types_f elt,
184: per_all_assignments_f paa
185: where elt.element_name = 'PAYE Details'
186: and p_effective_date between elt.effective_start_date and elt.effective_end_date
187: and elt.element_type_id = lnk.element_type_id

Line 1026: pay_element_types_f elt,

1022: FROM pay_element_entries_f ele,
1023: pay_element_entry_values_f eev,
1024: pay_input_values_f inv,
1025: pay_element_links_f lnk,
1026: pay_element_types_f elt,
1027: pay_all_payrolls_f papf,
1028: per_all_assignments_f paaf,
1029: hr_soft_coding_keyflex hsck
1030: WHERE paaf.person_id = c_person_id

Line 1080: pay_element_types_f elt,

1076: FROM pay_element_entries_f ele,
1077: pay_element_entry_values_f eev,
1078: pay_input_values_f inv,
1079: pay_element_links_f lnk,
1080: pay_element_types_f elt,
1081: per_all_assignments_f paaf
1082: WHERE ele.element_entry_id = eev.element_entry_id
1083: AND c_effective_date between ele.effective_start_date and ele.effective_end_date
1084: AND eev.input_value_id + 0 = inv.input_value_id