eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_AA dependencies on IGS_CA_INST

Line 250: IGS_CA_INST ci

246: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
247: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
248: SELECT cs.s_cal_status
249: FROM IGS_CA_STAT cs,
250: IGS_CA_INST ci
251: WHERE ci.cal_type = cp_acad_cal_type AND
252: ci.sequence_number = cp_acad_ci_sequence_number AND
253: ci.cal_status = cs.cal_status;
254:

Line 325: cp_cal_type IGS_CA_INST.cal_type%TYPE,

321: WHERE cat.cal_type = cp_cal_type;
322: --Modified the following cursor to fetch end_dt in addition with s_cal_status. Bug: 2772337
323: --Modified the following cursor not to fetch end_dt in addition with s_cal_status. Bug: 2974150
324: CURSOR c_cal_instance (
325: cp_cal_type IGS_CA_INST.cal_type%TYPE,
326: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
327: SELECT cs.s_cal_status
328: FROM IGS_CA_INST ci,
329: IGS_CA_STAT cs

Line 326: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

322: --Modified the following cursor to fetch end_dt in addition with s_cal_status. Bug: 2772337
323: --Modified the following cursor not to fetch end_dt in addition with s_cal_status. Bug: 2974150
324: CURSOR c_cal_instance (
325: cp_cal_type IGS_CA_INST.cal_type%TYPE,
326: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
327: SELECT cs.s_cal_status
328: FROM IGS_CA_INST ci,
329: IGS_CA_STAT cs
330: WHERE ci.cal_status = cs.cal_status AND

Line 328: FROM IGS_CA_INST ci,

324: CURSOR c_cal_instance (
325: cp_cal_type IGS_CA_INST.cal_type%TYPE,
326: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
327: SELECT cs.s_cal_status
328: FROM IGS_CA_INST ci,
329: IGS_CA_STAT cs
330: WHERE ci.cal_status = cs.cal_status AND
331: ci.cal_type = cp_cal_type AND
332: ci.sequence_number = cp_sequence_number;

Line 334: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

330: WHERE ci.cal_status = cs.cal_status AND
331: ci.cal_type = cp_cal_type AND
332: ci.sequence_number = cp_sequence_number;
333: CURSOR c_cal_ins_rel (
334: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
335: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
336: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
337: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
338: SELECT 'x'

Line 335: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

331: ci.cal_type = cp_cal_type AND
332: ci.sequence_number = cp_sequence_number;
333: CURSOR c_cal_ins_rel (
334: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
335: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
336: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
337: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
338: SELECT 'x'
339: FROM IGS_CA_INST_REL cir

Line 336: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,

332: ci.sequence_number = cp_sequence_number;
333: CURSOR c_cal_ins_rel (
334: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
335: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
336: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
337: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
338: SELECT 'x'
339: FROM IGS_CA_INST_REL cir
340: WHERE cir.sup_cal_type =cp_acad_cal_type AND

Line 337: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

333: CURSOR c_cal_ins_rel (
334: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
335: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
336: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
337: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
338: SELECT 'x'
339: FROM IGS_CA_INST_REL cir
340: WHERE cir.sup_cal_type =cp_acad_cal_type AND
341: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND

Line 339: FROM IGS_CA_INST_REL cir

335: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
336: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
337: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
338: SELECT 'x'
339: FROM IGS_CA_INST_REL cir
340: WHERE cir.sup_cal_type =cp_acad_cal_type AND
341: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
342: cir.sub_cal_type = cp_adm_cal_type AND
343: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;

Line 345: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,

341: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
342: cir.sub_cal_type = cp_adm_cal_type AND
343: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;
344: CURSOR c_adm_perd_adm_proc_cat (
345: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
346: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
347: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
348: cp_s_admission_process_type
349: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS

Line 346: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

342: cir.sub_cal_type = cp_adm_cal_type AND
343: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;
344: CURSOR c_adm_perd_adm_proc_cat (
345: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
346: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
347: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
348: cp_s_admission_process_type
349: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
350: SELECT 'x'