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 146: FROM pay_element_types_f pet1

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

Line 249: pay_element_types_f pet,

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