APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_ASSIGNMENTS_F

Line 294: ,per_assignments_f paa

290: ,'SATO=P' /*bug7270073*/
291: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')
292: FROM
293: hr_soft_coding_keyflex hsc
294: ,per_assignments_f paa
295: ,per_people_f pap
296: ,per_addresses pad
297: ,pay_payroll_actions ppa
298: ,pay_assignment_actions pac

Line 309: FROM per_assignments_f a

305: AND pap.person_id = paa.person_id
306: AND pap.person_id = pad.person_id(+)
307: AND pad.primary_flag(+) = 'Y' /*Added for bug 2751147*/
308: AND paa.effective_start_date = ( SELECT max(effective_Start_date)
309: FROM per_assignments_f a
310: WHERE a.assignment_id = paa.assignment_id
311: and a.effective_start_date < =
312: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /*5474358 */
313: group by a.assignment_id /*Bug4247686 */