APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_CA_INST_ALL

Line 200: FROM IGS_CA_INST_ALL cainstall,

196: ucsyscal.entry_year,
197: cainstall.cal_type,
198: cainstall.sequence_number,
199: cainstall.start_dt
200: FROM IGS_CA_INST_ALL cainstall,
201: IGS_CA_INST_REL cainstrel,
202: IGS_CA_TYPE catype,
203: IGS_CA_STAT castat,
204: IGS_UC_SYS_CALNDRS ucsyscal

Line 220: cal_type igs_ca_inst_all.cal_type%TYPE,

216:
217: -- anwest UCFD040 Bug# 4015492 New type to hold attributes of a cursor above
218: TYPE res_term_type IS RECORD (system_code igs_uc_sys_calndrs.system_code%TYPE,
219: entry_year igs_uc_sys_calndrs.entry_year%TYPE,
220: cal_type igs_ca_inst_all.cal_type%TYPE,
221: sequence_number igs_ca_inst_all.sequence_number%TYPE);
222:
223: -- anwest UCFD040 Bug# 4015492 New type to store multiple record types
224: TYPE res_term_table_type IS TABLE OF res_term_type INDEX BY BINARY_INTEGER;

Line 221: sequence_number igs_ca_inst_all.sequence_number%TYPE);

217: -- anwest UCFD040 Bug# 4015492 New type to hold attributes of a cursor above
218: TYPE res_term_type IS RECORD (system_code igs_uc_sys_calndrs.system_code%TYPE,
219: entry_year igs_uc_sys_calndrs.entry_year%TYPE,
220: cal_type igs_ca_inst_all.cal_type%TYPE,
221: sequence_number igs_ca_inst_all.sequence_number%TYPE);
222:
223: -- anwest UCFD040 Bug# 4015492 New type to store multiple record types
224: TYPE res_term_table_type IS TABLE OF res_term_type INDEX BY BINARY_INTEGER;
225:

Line 288: l_term_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

284:
285: -- anwest UCFD040 Bug# 4015492 New local variables required
286: l_res_term_det res_term_table_type;
287: l_res_term_loc NUMBER;
288: l_term_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
289: l_term_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
290: l_prev_system_code IGS_UC_SYS_CALNDRS.system_code%TYPE;
291: l_prev_entry_year IGS_UC_SYS_CALNDRS.entry_year%TYPE;
292:

Line 289: l_term_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;

285: -- anwest UCFD040 Bug# 4015492 New local variables required
286: l_res_term_det res_term_table_type;
287: l_res_term_loc NUMBER;
288: l_term_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
289: l_term_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
290: l_prev_system_code IGS_UC_SYS_CALNDRS.system_code%TYPE;
291: l_prev_entry_year IGS_UC_SYS_CALNDRS.entry_year%TYPE;
292:
293: PROCEDURE get_term_dtls(p_app_no IN NUMBER,