APPS.IGS_AD_GEN_002 dependencies on IGS_CA_INST_REL

Line 1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

1445: SELECT cat.arts_teaching_cal_type_cd
1446: FROM IGS_CA_TYPE cat
1447: WHERE cat.cal_type = cp_cal_type;
1448: CURSOR c_cir_cat (
1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1450: cp_teach_ci_sequence_number
1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number

Line 1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

1447: WHERE cat.cal_type = cp_cal_type;
1448: CURSOR c_cir_cat (
1449: cp_teach_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1450: cp_teach_ci_sequence_number
1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,

Line 1454: FROM IGS_CA_INST_REL cir1,

1450: cp_teach_ci_sequence_number
1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,
1456: IGS_CA_TYPE cat1,
1457: IGS_CA_TYPE cat2
1458: WHERE cir1.sup_cal_type = cat1.cal_type AND

Line 1455: IGS_CA_INST_REL cir2,

1451: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
1452: SELECT cir2.sub_cal_type,
1453: cir2.sub_ci_sequence_number
1454: FROM IGS_CA_INST_REL cir1,
1455: IGS_CA_INST_REL cir2,
1456: IGS_CA_TYPE cat1,
1457: IGS_CA_TYPE cat2
1458: WHERE cir1.sup_cal_type = cat1.cal_type AND
1459: cat1.s_cal_cat = cst_academic AND

Line 2841: FROM IGS_CA_INST_REL cir,

2837: cp_adm_cal_type IN IGS_AD_PS_APPL_INST.adm_cal_type%TYPE,
2838: cp_adm_ci_sequence_number IN
2839: IGS_AD_PS_APPL_INST.adm_ci_sequence_number%TYPE) IS
2840: SELECT ci.alternate_code, ci.start_dt
2841: FROM IGS_CA_INST_REL cir,
2842: IGS_CA_INST ci
2843: WHERE cir.sup_cal_type = cp_acad_cal_type AND
2844: cir.sub_cal_type = cp_adm_cal_type AND
2845: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND