APPS.IGS_PR_GEN_002 dependencies on IGS_CA_INST_REL

Line 476: FROM IGS_CA_INST_REL cir

472: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
473: v_dummy VARCHAR2(1);
474: CURSOR c_cir IS
475: SELECT 'X'
476: FROM IGS_CA_INST_REL cir
477: WHERE cir.sub_cal_type = p_cal_type AND
478: cir.sub_ci_sequence_number = p_ci_sequence_number AND
479: cir.sup_cal_type = p_prg_cal_type AND
480: cir.sup_ci_sequence_number = p_prg_ci_sequence_number;

Line 502: IGS_CA_INST_REL cir,

498: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
499: SELECT cir.sup_cal_type,
500: cir.sup_ci_sequence_number
501: FROM IGS_CA_INST ci1,
502: IGS_CA_INST_REL cir,
503: IGS_CA_TYPE ct,
504: IGS_CA_STAT cs
505: WHERE cir.sub_cal_type = p_cal_type AND
506: cir.sub_ci_sequence_number = p_ci_sequence_number AND

Line 528: IGS_CA_INST_REL cir,

524: CURSOR c_ci_cir_ct_cs2 (
525: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
526: SELECT 'X'
527: FROM IGS_CA_INST ci1,
528: IGS_CA_INST_REL cir,
529: IGS_CA_TYPE ct,
530: IGS_CA_STAT cs
531: WHERE cir.sub_cal_type = p_cal_type AND
532: cir.sub_ci_sequence_number = p_ci_sequence_number AND