APPS.IGS_EN_PRC_LOAD dependencies on IGS_CA_INST_REL

Line 115: FROM IGS_CA_INST_REL acir,

111: cp_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
112: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.no_assessment_ind%TYPE) IS
113: SELECT lci.cal_type,
114: lci.sequence_number
115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,

Line 119: IGS_CA_INST_REL lcir,

115: FROM IGS_CA_INST_REL acir,
116: IGS_CA_INST aci,
117: IGS_CA_TYPE acat,
118: IGS_CA_STAT acs,
119: IGS_CA_INST_REL lcir,
120: IGS_CA_INST lci,
121: IGS_CA_TYPE lcat,
122: IGS_CA_STAT lcs
123: WHERE acir.sub_cal_type = p_teach_cal_type AND

Line 283: IGS_CA_INST_REL cir,

279: sua.discontinued_dt,
280: sua.uoo_id,
281: sua.no_assessment_ind
282: FROM IGS_EN_SU_ATTEMPT sua,
283: IGS_CA_INST_REL cir,
284: IGS_PS_UNIT_VER uv
285: WHERE sua.person_id = p_person_id AND
286: sua.course_cd = p_course_cd AND
287: sua.unit_attempt_status IN (cst_enrolled,

Line 1074: FROM IGS_CA_INST_REL CIR,

1070: CURSOR c_cal_type_instance( cp_cal_type IGS_CA_INST.cal_type%TYPE,
1071: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1072: SELECT CI.cal_type,
1073: CI.sequence_number
1074: FROM IGS_CA_INST_REL CIR,
1075: IGS_CA_INST CI,
1076: IGS_CA_TYPE CT,
1077: IGS_CA_STAT CS
1078: WHERE CT.closed_ind = 'N' AND

Line 1621: FROM IGS_CA_INST_REL cir1,

1617: cp_load_sequence_number IGS_CA_INST.sequence_number%TYPE,
1618: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,
1623: IGS_CA_INST_REL cir2
1624: WHERE cir1.sub_cal_type = cp_load_cal_type AND
1625: cir1.sub_ci_sequence_number = cp_load_sequence_number AND

Line 1623: IGS_CA_INST_REL cir2

1619: cp_teach_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1620: SELECT 'X'
1621: FROM IGS_CA_INST_REL cir1,
1622: IGS_CA_TYPE ct,
1623: IGS_CA_INST_REL cir2
1624: WHERE cir1.sub_cal_type = cp_load_cal_type AND
1625: cir1.sub_ci_sequence_number = cp_load_sequence_number AND
1626: ct.cal_type = cir1.sup_cal_type AND
1627: ct.s_cal_cat = 'ACADEMIC' AND

Line 2380: FROM igs_ca_inst_rel rel,

2376: Fetches the latest load under the given given academic calendar
2377: ***********************************************************************************************************************/
2378: CURSOR c_latest_load IS
2379: SELECT rel.SUB_CAL_TYPE , rel.SUB_CI_SEQUENCE_NUMBER , NVL(dai.absolute_val, cai.start_dt) load_effective_dt
2380: FROM igs_ca_inst_rel rel,
2381: igs_ca_da_inst dai,
2382: igs_en_cal_conf conf,
2383: igs_ca_inst cai
2384: WHERE