APPS.PER_ASG_AGGR dependencies on PAY_ELEMENT_LINKS_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 182: pay_element_links_f lnk,

178:
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

Line 1025: pay_element_links_f lnk,

1021: min(ele.entry_information2) P6_msg_date
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

Line 1079: pay_element_links_f lnk,

1075: min(ele.entry_information2) P6_msg_date
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