APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 640: csr_v_business_group_id per_all_people_f.business_group_id%TYPE

636: l_union_dues NUMBER;
637: l_local_unit_id_fetched NUMBER;
638:
639: CURSOR csr_person_details (
640: csr_v_business_group_id per_all_people_f.business_group_id%TYPE
641: )
642: IS
643: SELECT Distinct(pap.full_name) NAME,
644: PAA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER,

Line 647: FROM per_all_people_f pap,

643: SELECT Distinct(pap.full_name) NAME,
644: PAA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER,
645: -- pap.national_identifier national_identifier,
646: paa.assignment_id assignment_id
647: FROM per_all_people_f pap,
648: per_all_assignments_f paa,
649: pay_assignment_actions pasa
650: WHERE paa.person_id = pap.person_id
651: AND pasa.assignment_id = paa.assignment_id