APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_UC_DEFAULTS

Line 66: FROM IGS_UC_DEFAULTS

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
66: FROM IGS_UC_DEFAULTS
67: WHERE system_code = 'N';
68:
69: cur_ninumber_alt_type_rec cur_ninumber_alt_type%ROWTYPE;
70:

Line 81: CURSOR cur_chk_dcsn_maker_setup(cp_system_code igs_uc_defaults.system_code%TYPE) IS

77: AND NVL(ucap.sent_to_oss,'N') = 'N';
78:
79: -- Cursor to check whether decision make id is set for the sytem
80: -- Added for bug# bug# 3553352
81: CURSOR cur_chk_dcsn_maker_setup(cp_system_code igs_uc_defaults.system_code%TYPE) IS
82: SELECT name, decision_make_id
83: FROM igs_uc_defaults
84: WHERE system_code = cp_system_code;
85:

Line 83: FROM igs_uc_defaults

79: -- Cursor to check whether decision make id is set for the sytem
80: -- Added for bug# bug# 3553352
81: CURSOR cur_chk_dcsn_maker_setup(cp_system_code igs_uc_defaults.system_code%TYPE) IS
82: SELECT name, decision_make_id
83: FROM igs_uc_defaults
84: WHERE system_code = cp_system_code;
85:
86: chk_dcsn_maker_setup_rec cur_chk_dcsn_maker_setup%ROWTYPE ;
87:

Line 189: FROM IGS_UC_DEFAULTS;

185:
186: -- anwest UCFD040 Bug# 4015492 New cursor to store maximum current cycle
187: CURSOR cur_get_current_cycle IS
188: SELECT max(current_cycle)
189: FROM IGS_UC_DEFAULTS;
190: l_max_curr_cycle IGS_UC_DEFAULTS.current_cycle%TYPE;
191:
192: -- anwest UCFD040 Bug# 4015492 New cursor to store load calender instances for UCAS
193: -- system codes and cycles

Line 190: l_max_curr_cycle IGS_UC_DEFAULTS.current_cycle%TYPE;

186: -- anwest UCFD040 Bug# 4015492 New cursor to store maximum current cycle
187: CURSOR cur_get_current_cycle IS
188: SELECT max(current_cycle)
189: FROM IGS_UC_DEFAULTS;
190: l_max_curr_cycle IGS_UC_DEFAULTS.current_cycle%TYPE;
191:
192: -- anwest UCFD040 Bug# 4015492 New cursor to store load calender instances for UCAS
193: -- system codes and cycles
194: CURSOR cur_get_term(cp_entry_year igs_uc_sys_calndrs.entry_year%type) IS

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;