APPS.PER_IE_ASG_EXT_INFO dependencies on PER_ALL_PEOPLE_F

Line 18: FROM per_all_assignments_f paaf, per_all_people_f papf

14: IS
15:
16: CURSOR cur_ppsn_number IS
17: SELECT DISTINCT NATIONAL_IDENTIFIER
18: FROM per_all_assignments_f paaf, per_all_people_f papf
19: WHERE paaf.assignment_id = P_ASSIGNMENT_ID
20: AND paaf.person_id = papf.person_id;
21:
22: l_ppsn_number per_all_people_f.national_identifier%type;

Line 22: l_ppsn_number per_all_people_f.national_identifier%type;

18: FROM per_all_assignments_f paaf, per_all_people_f papf
19: WHERE paaf.assignment_id = P_ASSIGNMENT_ID
20: AND paaf.person_id = papf.person_id;
21:
22: l_ppsn_number per_all_people_f.national_identifier%type;
23:
24: CURSOR cur_check_ppsn is
25: SELECT NVL(instr(substr(P_AEI_INFORMATION1,1,length(l_ppsn_number)),l_ppsn_number),0) check_ppsn
26: FROM dual;

Line 61: FROM per_all_assignments_f paaf, per_all_people_f papf, per_assignment_extra_info paei

57: IS
58:
59: CURSOR cur_ppsn_number IS
60: SELECT DISTINCT NATIONAL_IDENTIFIER
61: FROM per_all_assignments_f paaf, per_all_people_f papf, per_assignment_extra_info paei
62: WHERE paei.assignment_extra_info_id = p_assignment_extra_info_id
63: and paei.aei_information_category = p_aei_information_category
64: AND paaf.assignment_id = paei.assignment_id
65: AND paaf.person_id = papf.person_id;

Line 67: l_ppsn_number per_all_people_f.national_identifier%type;

63: and paei.aei_information_category = p_aei_information_category
64: AND paaf.assignment_id = paei.assignment_id
65: AND paaf.person_id = papf.person_id;
66:
67: l_ppsn_number per_all_people_f.national_identifier%type;
68:
69: CURSOR cur_check_ppsn is
70: SELECT NVL(instr(substr(P_AEI_INFORMATION1,1,length(l_ppsn_number)),l_ppsn_number),0) check_ppsn
71: FROM dual;