APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_PS_OFR_PAT_OFERPAT_V

Line 810: FROM IGS_PS_OFR_PAT_OFERPAT_V acopv,

806:
807: -- Cursor to validate Program Offering Options
808: CURSOR c_off_pattern(p_admission_cat VARCHAR2, p_s_adm_process_type VARCHAR2,p_location_cd VARCHAR2, p_attendance_type VARCHAR2,p_attendance_mode VARCHAR2) IS
809: SELECT acopv.ACAD_CAL_TYPE
810: FROM IGS_PS_OFR_PAT_OFERPAT_V acopv,
811: IGS_AD_LOCATION loc,
812: IGS_EN_ATD_MODE atd_mode,
813: IGS_EN_ATD_TYPE atd_type
814: WHERE

Line 862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;

858: l_sch_apl_to_rec IGS_AD_SCHL_APLY_TO.sch_apl_to_id%TYPE := NULL;
859: l_location_rec IGS_AD_LOCATION.location_cd%TYPE := NULL;
860: l_att_type_rec IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE := NULL;
861: l_att_mode_rec IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE := NULL;
862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;
863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;
865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;