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
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
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