APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_ASSIGNMENTS_F

Line 290: ,per_assignments_f paa

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

Line 305: FROM per_assignments_f a

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