DBA Data[Home] [Help]

APPS.IGS_AD_VAL_APCOO dependencies on IGS_PS_OFR_PAT_APCOO_V

Line 279: FROM IGS_PS_OFR_PAT_APCOO_V acov

275: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS
276: SELECT DISTINCT acov.course_cd,
277: acov.version_number,
278: acov.acad_cal_type
279: FROM IGS_PS_OFR_PAT_APCOO_V acov
280: WHERE acov.adm_cal_type = cp_adm_cal_type AND
281: acov.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
282: acov.admission_cat = p_admission_cat AND
283: acov.s_admission_process_type = p_s_admission_process_type AND

Line 671: FROM IGS_PS_OFR_PAT_APCOO_V

667: CURSOR c_acov IS
668: SELECT location_cd,
669: attendance_mode,
670: attendance_type
671: FROM IGS_PS_OFR_PAT_APCOO_V
672: WHERE course_cd = p_course_cd AND
673: version_number = p_version_number AND
674: acad_cal_type = p_acad_cal_type AND
675: adm_cal_type = p_adm_cal_type AND