DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ELEMENT_TYPES_F

Line 151: ,pay_element_types_f pet

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
155: AND pap.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 192: FROM pay_element_types_f pet1

188: AND peev.input_value_id = piv.input_value_id
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