DBA Data[Home] [Help]

APPS.IGS_AD_GEN_007 dependencies on IGS_AD_CAL_CONF

Line 405: v_appl_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;

401: -- admp_get_resp_dt
402: -- Calculate the offer response date. If the date cannot be derived return
403: -- NULL, otherwise return the derived date.
404: v_offer_resp_offset IGS_AD_PRCS_CAT.offer_response_offset%TYPE;
405: v_appl_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
406: v_offer_resp_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
407: v_offer_resp_dt DATE;
408: v_apc_found BOOLEAN;
409: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE ;

Line 424: FROM IGS_AD_CAL_CONF

420: CURSOR c_sacc IS
421: SELECT adm_appl_offer_resp_dt_alias ,
422: adm_appl_due_dt_alias,
423: adm_appl_final_dt_alias
424: FROM IGS_AD_CAL_CONF
425: WHERE s_control_num = 1;
426:
427: CURSOR c_apcood(cp_appl_offer_resp_dt_alias
428: IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE) IS

Line 428: IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE) IS

424: FROM IGS_AD_CAL_CONF
425: WHERE s_control_num = 1;
426:
427: CURSOR c_apcood(cp_appl_offer_resp_dt_alias
428: IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE) IS
429: SELECT apcood.s_admission_process_type,
430: apcood.course_cd,
431: apcood.version_number,
432: apcood.acad_cal_type,