DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ELEMENT_TYPES_F

Line 153: ,pay_element_types_f pet

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

Line 194: FROM pay_element_types_f pet1

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