APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 746: per_all_assignments_f asg

742: choose the N7 (payroll_id) index due to it being a bind */
743: asg.person_id person_id
744: , asg.assignment_id assignment_id
745: FROM
746: per_all_assignments_f asg
747: , pay_payroll_actions ppa_arch
748: , per_assignment_extra_info aei
749: WHERE
750: ppa_arch.payroll_action_id = pactid

Line 764: FROM per_all_assignments_f asg2

760: OR
761: ( asg.effective_end_date <= ppa_arch.effective_date
762: AND asg.effective_end_date =
763: ( SELECT MAX(asg2.effective_end_date)
764: FROM per_all_assignments_f asg2
765: WHERE asg2.assignment_id = asg.assignment_id
766: )
767: )
768: )

Line 1241: from per_all_assignments_f paaf

1237: and ppa.payroll_action_id = paa.payroll_action_id;
1238:
1239: select max(paaf.person_id)
1240: into l_person_id
1241: from per_all_assignments_f paaf
1242: where paaf.assignment_id = l_assignment_id;
1243:
1244: l_combine_cert := get_parameter('P_COMBINE_CERT', l_leg_param);
1245: hr_utility.set_location('P_COMBINE_CERT:'||l_combine_cert,1);

Line 1271: ,per_all_assignments_f paaf

1267: --Check if the assignment is terminated or ended
1268: SELECT max (paaf.effective_start_date)
1269: INTO l_asg_end_date
1270: FROM per_assignment_status_types past
1271: ,per_all_assignments_f paaf
1272: WHERE paaf.assignment_id = l_assignment_id
1273: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1274: AND past.per_system_status IN ('TERM_ASSIGN','END');
1275:

Line 2633: , per_all_assignments_f a

2629: , ppf.email_address
2630: --, a.location_id
2631: , nvl(a.location_id, nvl(pap.location_id, haou.location_id)) location_id
2632: from per_all_people_f ppf
2633: , per_all_assignments_f a
2634: , per_all_positions pap
2635: , hr_all_organization_units haou
2636: where a.assignment_id = p_assignment_id
2637: and ppf.person_id = a.person_id

Line 2791: from per_all_assignments_f

2787:
2788: -- get l_effective_date to fetch person/phones/bank etc data
2789: select least(p_effective_date,max(effective_end_date))
2790: into l_effective_date
2791: from per_all_assignments_f
2792: where assignment_id = l_assignment_id;
2793:
2794: hr_utility.set_location(l_proc,20);
2795:

Line 2870: per_all_assignments_f paaf

2866: , nvl(max(paaf.effective_end_date), fnd_date.canonical_to_date('4712/12/31 00:00:00'))
2867: into l_asg_hire_date
2868: , l_asg_term_date
2869: from per_assignment_status_types past,
2870: per_all_assignments_f paaf
2871: where paaf.assignment_id = l_assignment_id
2872: and paaf.effective_start_date <= l_tax_year_end_date
2873: and paaf.assignment_status_type_id = past.assignment_status_type_id
2874: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');