DBA Data[Home] [Help]

APPS.PER_ASG_AGGR dependencies on PAY_ELEMENT_TYPES_F

Line 104: pay_element_links_f lnk, pay_element_types_f elt,

100: from
101: pay_element_entries_f ele,
102: pay_element_entry_values_f eev,
103: pay_input_values_f inv,
104: pay_element_links_f lnk, pay_element_types_f elt,
105: per_all_assignments_f paa,
106: pay_all_payrolls_f ppf,
107: hr_soft_coding_keyflex scl
108: where ele.element_entry_id = eev.element_entry_id

Line 176: pay_element_types_f elt,

172: CURSOR cur_paye_element_link IS
173: select count(*)
174: from pay_element_entries_f ele,
175: pay_element_links_f lnk,
176: pay_element_types_f elt,
177: per_all_assignments_f paa
178: where elt.element_name = 'PAYE Details'
179: and p_effective_date between elt.effective_start_date and elt.effective_end_date
180: and elt.element_type_id = lnk.element_type_id