APPS.IGS_AD_VAL_APCOOD dependencies on IGS_AD_PRD_AD_PRC_CA

Line 30: FROM IGS_AD_PRD_AD_PRC_CA

26: v_valid_optn BOOLEAN DEFAULT NULL;
27: v_apapc_found BOOLEAN DEFAULT FALSE;
28: CURSOR c_apapc IS
29: SELECT s_admission_process_type
30: FROM IGS_AD_PRD_AD_PRC_CA
31: WHERE adm_cal_type = p_adm_cal_type AND
32: adm_ci_sequence_number = p_adm_ci_sequence_number AND
33: admission_cat = p_admission_cat;
34: ----------------------------------------- SUBFUNCTION -------------------------

Line 199: FROM IGS_AD_PRD_AD_PRC_CA apapc

195: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
196: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
197: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE) IS
198: SELECT apapc.s_admission_process_type
199: FROM IGS_AD_PRD_AD_PRC_CA apapc
200: WHERE apapc.adm_cal_type = cp_adm_cal_type AND
201: apapc.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
202: apapc.admission_cat = cp_admission_cat AND
203: apapc.closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)

Line 771: FROM IGS_AD_PRD_AD_PRC_CA

767: v_apcood_exists VARCHAR2(1);
768: v_adm_perd_dt_exists BOOLEAN DEFAULT FALSE;
769: CURSOR c_apapc IS
770: SELECT 'X'
771: FROM IGS_AD_PRD_AD_PRC_CA
772: WHERE adm_cal_type = p_adm_cal_type AND
773: adm_ci_sequence_number = p_adm_ci_sequence_number AND
774: admission_cat = p_admission_cat AND
775: closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)

Line 795: --cannot be inserted if no IGS_AD_PRD_AD_PRC_CA exists

791: BEGIN
792: --Set the default message number
793: p_message_name := Null;
794: --Admission period course offering option date overrides
795: --cannot be inserted if no IGS_AD_PRD_AD_PRC_CA exists
796: OPEN c_apapc;
797: FETCH c_apapc INTO v_apapc_exists;
798: IF (c_apapc%NOTFOUND) THEN
799: CLOSE c_apapc;