APPS.IGS_CA_VAL_QLITY dependencies on IGS_AD_PECRS_OFOP_DT

Line 929: FROM IGS_AD_PECRS_OFOP_DT apcood

925: daiv.DT_ALIAS = sacc.adm_appl_due_dt_alias AND
926: sacc.s_control_num = 1 AND
927: NOT EXISTS (
928: SELECT 'x'
929: FROM IGS_AD_PECRS_OFOP_DT apcood
930: WHERE apcood.adm_cal_type = cp_cal_type AND
931: apcood.adm_ci_sequence_number = cp_ci_sequence_number AND
932: apcood.DT_ALIAS = daiv.CAL_TYPE AND
933: apcood.dai_sequence_number = daiv.sequence_number);

Line 946: FROM IGS_AD_PECRS_OFOP_DT apcood

942: daiv.DT_ALIAS = sacc.adm_appl_final_dt_alias AND
943: sacc.s_control_num = 1 AND
944: NOT EXISTS (
945: SELECT 'x'
946: FROM IGS_AD_PECRS_OFOP_DT apcood
947: WHERE apcood.adm_cal_type = cp_cal_type AND
948: apcood.adm_ci_sequence_number = cp_ci_sequence_number AND
949: apcood.DT_ALIAS = daiv.CAL_TYPE AND
950: apcood.dai_sequence_number = daiv.sequence_number);

Line 963: FROM IGS_AD_PECRS_OFOP_DT apcood

959: daiv.DT_ALIAS = sacc.adm_appl_offer_resp_dt_alias AND
960: sacc.s_control_num = 1 AND
961: NOT EXISTS (
962: SELECT 'x'
963: FROM IGS_AD_PECRS_OFOP_DT apcood
964: WHERE apcood.adm_cal_type = cp_cal_type AND
965: apcood.adm_ci_sequence_number = cp_ci_sequence_number AND
966: apcood.DT_ALIAS = daiv.CAL_TYPE AND
967: apcood.dai_sequence_number = daiv.sequence_number);

Line 1227: -- not be linked to IGS_AD_PECRS_OFOP_DT

1223: END IF;
1224: -- Check that for date aliases that can be attached to admission period
1225: -- IGS_PS_COURSE
1226: -- offering option override, only one date value in the admission must
1227: -- not be linked to IGS_AD_PECRS_OFOP_DT
1228: OPEN c_daiv_4(
1229: v_cal_type,
1230: v_sequence_number);
1231: FETCH c_daiv_4 INTO v_count;