APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 4691: FROM per_all_people_f per2

4687: -- changed the person_id check to NI Number check.
4688: --AND rdtl.person_id = p_person_id
4689: AND rdtl.val_04 IN
4690: ( SELECT national_identifier
4691: FROM per_all_people_f per2
4692: WHERE per2.person_id = p_person_id
4693: )
4694: -- match the header element
4695: AND EXISTS

Line 10839: l_person_id per_all_people_f.person_id%TYPE;

10835:
10836: l_multiper_found BOOLEAN := FALSE;
10837: l_present_in_masterbg BOOLEAN := FALSE;
10838: l_ext_emp_cat_cd VARCHAR2(1);
10839: l_person_id per_all_people_f.person_id%TYPE;
10840:
10841: l_per_details csr_asg_details_up%ROWTYPE;
10842: l_multiper c_multiper%ROWTYPE;
10843: l_person_count NUMBER :=0 ;

Line 11172: ,per_all_people_f per

11168: CURSOR csr_per_details IS
11169: SELECT per.person_id person_id
11170: ,per.national_identifier national_identifier
11171: FROM per_all_assignments_f asg
11172: ,per_all_people_f per
11173: WHERE asg.assignment_id = p_assignment_id
11174: AND per.person_id = asg.person_id;
11175:
11176:

Line 11871: l_person_id per_all_people_f.person_id%TYPE;

11867: l_leaver_date DATE;
11868: l_already_reported VARCHAR2(1) := 'N';
11869: l_restarter VARCHAR2(1) := 'N';
11870: l_restarter_date DATE := NULL;
11871: l_person_id per_all_people_f.person_id%TYPE;
11872: l_asg_count NUMBER;
11873: l_error NUMBER;
11874:
11875: -- Rowtype Variable Declaration