APPS.PAY_ZA_IRP5_IT3A_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 419: per_all_assignments_f ass,

415: from pay_action_information pai,
416: pay_action_information pai2,
417: pay_assignment_actions paa,
418: hr_all_organization_units org,
419: per_all_assignments_f ass,
420: pay_payroll_actions ppa
421: where pai.action_context_id = paa.assignment_action_id
422: and paa.payroll_action_id = :1
423: and pai.action_context_type = ''AAP''

Line 440: from per_all_assignments_f paaf

436: and pai.Action_Information2 = :2
437: and paa.ASSIGNMENT_ID = ass.ASSIGNMENT_ID
438: and paa.PAYROLL_ACTION_ID = ppa.PAYROLL_ACTION_ID
439: and (select least(ppa.EFFECTIVE_DATE, (select max(effective_end_date)
440: from per_all_assignments_f paaf
441: where paaf.assignment_id = ass.assignment_id))
442: from dual)
443: between ass.EFFECTIVE_START_DATE and ass.EFFECTIVE_END_DATE
444: and ass.organization_id = org.organization_id (+)

Line 543: from per_all_assignments_f

539:
540: -- Get Payroll IRP5 Number for this assignment
541: select least(g_effective_date,max(effective_end_date))
542: into l_effective_date
543: from per_all_assignments_f
544: where assignment_id = l_asg_id;
545:
546: select payroll_id
547: into l_payroll_id

Line 548: from per_all_assignments_f

544: where assignment_id = l_asg_id;
545:
546: select payroll_id
547: into l_payroll_id
548: from per_all_assignments_f
549: where assignment_id = l_asg_id
550: and l_effective_date between effective_start_date and effective_end_date ;
551:
552: l_payroll_ref := get_payroll_ref(l_payroll_id);