APPS.IGS_AD_VAL_ACAIU dependencies on IGS_CA_STAT

Line 507: IGS_CA_STAT cs,

503: CURSOR c_teach_perd IS
504: SELECT cs.s_cal_status,
505: cat.s_cal_cat
506: FROM IGS_CA_INST ci,
507: IGS_CA_STAT cs,
508: IGS_CA_TYPE cat
509: WHERE ci.cal_status = cs.cal_status AND
510: ci.cal_type = cat.cal_type AND
511: ci.cal_type = p_teach_cal_type AND

Line 789: IGS_CA_STAT cs

785: cs.s_cal_status
786: FROM IGS_CA_INST_REL cir,
787: IGS_CA_INST ci,
788: IGS_CA_TYPE cat,
789: IGS_CA_STAT cs
790: WHERE cir.sup_cal_type = p_acad_cal_type AND
791: cir.sup_ci_sequence_number = p_acad_ci_sequence_number AND
792: ci.sequence_number = cir.sub_ci_sequence_number AND
793: ci.cal_type = cir.sub_cal_type AND