APPS.IGS_AD_GEN_007 dependencies on IGS_AD_PRCS_CAT

Line 404: v_offer_resp_offset IGS_AD_PRCS_CAT.offer_response_offset%TYPE;

400: RETURN DATE IS
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;

Line 416: FROM IGS_AD_PRCS_CAT

412: v_high_component_ctr NUMBER := 0;
413:
414: CURSOR c_apc IS
415: SELECT offer_response_offset
416: FROM IGS_AD_PRCS_CAT
417: WHERE admission_cat = p_admission_cat AND
418: s_admission_process_type = p_admission_process_type;
419:
420: CURSOR c_sacc IS