APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_SRC_TYPES_ALL

Line 57: FROM IGS_PE_SRC_TYPES_ALL

53:
54: -- Fetch the Source Type ID for UCAS Person from Person Source Types Table
55: CURSOR cur_pe_src_types IS
56: SELECT source_type_id
57: FROM IGS_PE_SRC_TYPES_ALL
58: WHERE source_type = 'UCAS PER'
59: AND NVL(closed_ind,'N') = 'N';
60:
61: l_src_type_id IGS_PE_SRC_TYPES_ALL.source_type_id%TYPE;

Line 61: l_src_type_id IGS_PE_SRC_TYPES_ALL.source_type_id%TYPE;

57: FROM IGS_PE_SRC_TYPES_ALL
58: WHERE source_type = 'UCAS PER'
59: AND NVL(closed_ind,'N') = 'N';
60:
61: l_src_type_id IGS_PE_SRC_TYPES_ALL.source_type_id%TYPE;
62:
63: -- Fetch the NI Number Alternate Type from UCAS Setup for NMAS System
64: CURSOR cur_ninumber_alt_type IS
65: SELECT name,ni_number_alt_pers_type