APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 4663: FROM per_all_people_f per2

4659: -- changed the person_id check to NI Number check.
4660: --AND rdtl.person_id = p_person_id
4661: AND rdtl.val_04 IN
4662: ( SELECT national_identifier
4663: FROM per_all_people_f per2
4664: WHERE per2.person_id = p_person_id
4665: )
4666: -- match the header element
4667: AND EXISTS

Line 10642: l_person_id per_all_people_f.person_id%TYPE;

10638:
10639: l_multiper_found BOOLEAN := FALSE;
10640: l_present_in_masterbg BOOLEAN := FALSE;
10641: l_ext_emp_cat_cd VARCHAR2(1);
10642: l_person_id per_all_people_f.person_id%TYPE;
10643:
10644: l_per_details csr_asg_details_up%ROWTYPE;
10645: l_multiper c_multiper%ROWTYPE;
10646: l_person_count NUMBER :=0 ;

Line 10975: ,per_all_people_f per

10971: CURSOR csr_per_details IS
10972: SELECT per.person_id person_id
10973: ,per.national_identifier national_identifier
10974: FROM per_all_assignments_f asg
10975: ,per_all_people_f per
10976: WHERE asg.assignment_id = p_assignment_id
10977: AND per.person_id = asg.person_id;
10978:
10979:

Line 11673: l_person_id per_all_people_f.person_id%TYPE;

11669: l_leaver_date DATE;
11670: l_already_reported VARCHAR2(1) := 'N';
11671: l_restarter VARCHAR2(1) := 'N';
11672: l_restarter_date DATE := NULL;
11673: l_person_id per_all_people_f.person_id%TYPE;
11674: l_asg_count NUMBER;
11675: l_error NUMBER;
11676:
11677: -- Rowtype Variable Declaration