APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_PERSON

Line 90: CURSOR cur_uc_person_dtls(cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

86: chk_dcsn_maker_setup_rec cur_chk_dcsn_maker_setup%ROWTYPE ;
87:
88:
89: -- Fetch the OSS Person Details for an UCAS Applicant
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

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 1862: CURSOR cur_pers_type_unique ( cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS

1858: AND person_id_type = cp_pers_id_type
1859: ORDER BY START_DT DESC;
1860: cur_alt_pers_dtls_rec cur_alt_pers_dtls%ROWTYPE;
1861:
1862: CURSOR cur_pers_type_unique ( cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
1863: SELECT 'X'
1864: FROM IGS_PE_PERSON_ID_TYP
1865: WHERE person_id_type = cp_person_id_type
1866: AND unique_ind = 'Y'

Line 1864: FROM IGS_PE_PERSON_ID_TYP

1860: cur_alt_pers_dtls_rec cur_alt_pers_dtls%ROWTYPE;
1861:
1862: CURSOR cur_pers_type_unique ( cp_person_id_type IGS_PE_PERSON_ID_TYP.person_id_type%TYPE) IS
1863: SELECT 'X'
1864: FROM IGS_PE_PERSON_ID_TYP
1865: WHERE person_id_type = cp_person_id_type
1866: AND unique_ind = 'Y'
1867: AND closed_ind = 'N';
1868:

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