DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE_FLAGS dependencies on PAY_ELEMENT_TYPES_F

Line 96: , pay_element_types_f pet

92: , per_all_assignments_f paa,/*Bug 3012794*/
93: hr_soft_coding_keyflex hsc,
94: per_periods_of_service pps
95: , pay_element_entries_f pee
96: , pay_element_types_f pet
97: , pay_input_values_f piv0
98: , pay_element_entry_values_f eev0
99: , pay_input_values_f piv1
100: , pay_element_entry_values_f eev1

Line 145: FROM pay_element_types_f pet1

141: from per_people_f p
142: where p.person_id=pap.person_id) --Bug 4925794
143: AND pee.effective_start_date =
144: (SELECT max(pee1.effective_start_date)
145: FROM pay_element_types_f pet1
146: ,pay_element_links_f pel1
147: ,pay_element_entries_f pee1
148: WHERE pet1.element_name = 'Tax Information'
149: AND pet1.element_type_id = pel1.element_type_id

Line 247: pay_element_types_f pet,

243: FROM per_assignments_f paa,
244: hr_soft_coding_keyflex hsc,
245: pay_element_entry_values_f pev,
246: pay_input_values_f piv,
247: pay_element_types_f pet,
248: pay_element_entries_f pee,
249: hr_lookups hrl0
250: WHERE pet.element_name = 'Superannuation Guarantee Information'
251: AND pet.element_type_id = piv.element_type_id