DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ELEMENT_LINKS_F

Line 152: ,pay_element_links_f pel

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

Line 195: ,pay_element_links_f pel1

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