DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ELEMENT_LINKS_F

Line 150: ,pay_element_links_f pel

146: ,per_assignments_f paa
147: ,hr_soft_coding_keyflex hsc
148: ,per_periods_of_service pps
149: ,pay_element_entries_f pee
150: ,pay_element_links_f pel
151: ,pay_element_types_f pet
152: ,pay_input_values_f piv
153: ,pay_element_entry_values_f peev
154: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 193: ,pay_element_links_f pel1

189: AND peev.element_entry_id = pee.element_entry_id
190: AND pee.effective_start_date =
191: (SELECT max(pee1.effective_start_date)
192: FROM pay_element_types_f pet1
193: ,pay_element_links_f pel1
194: ,pay_element_entries_f pee1
195: WHERE pet1.element_name = 'Tax Information'
196: AND pet1.element_type_id = pel1.element_type_id
197: AND pel1.element_link_id = pee1.element_link_id