APPS.IGS_EN_GEN_008 dependencies on IGS_CA_INST_REL

Line 842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,

838: Who When What
839: vkarthik 21-Jan-2004 Removed recursive search from the function for checking if
840: the passed calendars are related anywhere in the hierarchy */
841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,

Line 843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,

839: vkarthik 21-Jan-2004 Removed recursive search from the function for checking if
840: the passed calendars are related anywhere in the hierarchy */
841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number

Line 844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,

840: the passed calendars are related anywhere in the hierarchy */
841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number
848: FROM igs_ca_inst_rel

Line 845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS

841: CURSOR c_cir (
842: cp_sup_cal_ty igs_ca_inst_rel.sup_cal_type%TYPE,
843: cp_sup_ci_seq_num igs_ca_inst_rel.sup_ci_sequence_number%TYPE,
844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number
848: FROM igs_ca_inst_rel
849: WHERE

Line 848: FROM igs_ca_inst_rel

844: cp_sub_cal_ty igs_ca_inst_rel.sub_cal_type%TYPE,
845: cp_sub_ci_seq_num igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
846: SELECT sup_cal_type,
847: sup_ci_sequence_number
848: FROM igs_ca_inst_rel
849: WHERE
850: sup_cal_type = cp_sup_cal_ty AND
851: sup_ci_sequence_number = cp_sup_ci_seq_num AND
852: sub_cal_type = cp_sub_cal_ty AND

Line 1255: IGS_CA_INST_REL cr

1251: version_number = sca.version_number) AND
1252: NOT EXISTS (
1253: SELECT person_id
1254: FROM IGS_EN_SU_ATTEMPT sua,
1255: IGS_CA_INST_REL cr
1256: WHERE sua.person_id = sca.person_id AND
1257: sua.course_cd = sca.course_cd AND
1258: sua.cal_type = cr.sub_cal_type AND
1259: sua.ci_sequence_number = cr.sub_ci_sequence_number AND

Line 1372: IGS_CA_INST_REL cr

1368: version_number = acai.crv_version_number ) AND
1369: NOT EXISTS (
1370: SELECT person_id
1371: FROM IGS_EN_SU_ATTEMPT sua,
1372: IGS_CA_INST_REL cr
1373: WHERE sua.person_id = acai.person_id AND
1374: sua.course_cd = acai.course_cd AND
1375: sua.cal_type = cr.sub_cal_type AND
1376: sua.ci_sequence_number = cr.sub_ci_sequence_number AND

Line 1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,

1403: AND susa.end_dt IS NULL;
1404: r_yop_us_st c_yop_us_st%ROWTYPE;
1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
1408: igs_ca_inst ci,
1409: igs_ca_type cal
1410: WHERE rel.sup_cal_type = p_acad_cal_type
1411: AND rel.sup_ci_sequence_number = p_acad_seq_num