APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 372: , per_all_assignments_f asg

368: asg.person_id
369: , asg.assignment_id
370: FROM
371: per_assignment_extra_info paei
372: , per_all_assignments_f asg
373: , per_person_type_usages_f pptu
374: , per_person_types ppt
375: WHERE
376: asg.payroll_id = l_payroll_id

Line 766: from per_all_assignments_f asg

762: l_payroll_exists :=0;
763:
764: select count(1)
765: into l_payroll_exists
766: from per_all_assignments_f asg
767: where asg.assignment_id = p_asg_id
768: and asg.effective_start_date <= l_end_date
769: and asg.effective_end_date >= l_start_date
770: and asg.payroll_id = p_payroll_id; -- Bug#11938675

Line 794: per_all_assignments_f asg

790:
791: select max(past.per_system_status)
792: into l_per_system_status
793: from per_assignment_status_types past,
794: per_all_assignments_f asg
795: where past.assignment_status_type_id = asg.assignment_status_type_id
796: and asg.assignment_id = p_asg_id
797: and past.per_system_status = 'ACTIVE_ASSIGN'
798: and asg.effective_start_date <= p_date

Line 808: per_all_assignments_f asg

804:
805: select past.per_system_status
806: into l_per_system_status
807: from per_assignment_status_types past,
808: per_all_assignments_f asg
809: where past.assignment_status_type_id = asg.assignment_status_type_id
810: and asg.assignment_id = p_asg_id
811: and p_date between asg.effective_start_date and asg.effective_end_date;
812:

Line 1040: , per_all_assignments_f asg

1036: , nvl(paei.aei_information4,'01') nature
1037: , nvl(paei.aei_information15,'N') foreign_national
1038: , nvl(paei.aei_information16,'N') exclude_coida -- 12534150
1039: from per_all_people_f per
1040: , per_all_assignments_f asg
1041: , pay_assignment_actions paa
1042: , per_assignment_extra_info paei
1043: , per_person_type_usages_f pptu
1044: , per_person_types ppt