APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_PERSON_BASE_V

Line 94: FROM IGS_PE_PERSON_BASE_V

90: CURSOR cur_uc_person_dtls(cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
91: SELECT person_id, person_number,title,
92: last_name surname, first_name given_names, gender sex,
93: birth_date, pre_name_adjunct
94: FROM IGS_PE_PERSON_BASE_V
95: WHERE person_id = cp_person_id;
96: cur_uc_person_dtls_rec cur_uc_person_dtls%ROWTYPE;
97:
98: -- Fetch the OSS Person ID of an UCAS Applicant

Line 2083: FROM igs_pe_person_base_v pv, igs_uc_defaults ucd

2079:
2080: -- Cursor to fetch the person number based on person id. Bug No. 2980137.
2081: CURSOR cur_person_number IS
2082: SELECT pv.person_number
2083: FROM igs_pe_person_base_v pv, igs_uc_defaults ucd
2084: WHERE pv.person_id = ucd.decision_make_id
2085: AND ucd.system_code = p_system_code;
2086:
2087: l_person_number igs_pe_person_base_v.person_number%TYPE;

Line 2087: l_person_number igs_pe_person_base_v.person_number%TYPE;

2083: FROM igs_pe_person_base_v pv, igs_uc_defaults ucd
2084: WHERE pv.person_id = ucd.decision_make_id
2085: AND ucd.system_code = p_system_code;
2086:
2087: l_person_number igs_pe_person_base_v.person_number%TYPE;
2088:
2089: BEGIN
2090:
2091: -- Importing the Residency Details for p_rescat