APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_CA_TYPE

Line 4721: FROM igs_ca_inst_rel cr, igs_ca_type ct

4717:
4718: CURSOR c_get_teach_period (p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
4719: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE) IS
4720: SELECT cr.sub_cal_type, cr.sub_ci_sequence_number
4721: FROM igs_ca_inst_rel cr, igs_ca_type ct
4722: WHERE ct.s_cal_cat ='TEACHING'
4723: AND cr.sub_cal_type = ct.cal_type
4724: AND cr.sup_cal_type = p_acad_cal_type
4725: AND cr.sup_ci_sequence_number = p_acad_ci_sequence_number;