APPS.IGS_EN_GEN_005 dependencies on IGS_CA_INST_REL

Line 153: IGS_CA_INST_REL cir,

149: ci.cal_type parent_cal_type,
150: ci.sequence_number parent_sequence_number
151: FROM IGS_CA_INST aci,
152: IGS_EN_SU_ATTEMPT sua,
153: IGS_CA_INST_REL cir,
154: IGS_CA_INST ci
155: WHERE
156: aci.cal_type = p_acad_cal_type AND
157: aci.sequence_number = p_acad_sequence_number AND

Line 253: FROM IGS_CA_INST_REL cir,

249: CURSOR c_cir_tci (cp_teach_cal_type IGS_PS_PAT_STUDY_PRD.teach_cal_type%TYPE)
250: IS
251: SELECT tci.cal_type,
252: tci.sequence_number
253: FROM IGS_CA_INST_REL cir,
254: IGS_CA_INST tci,
255: IGS_CA_TYPE cat,
256: IGS_CA_STAT cs
257: WHERE cir.sup_cal_type = p_acad_cal_type AND