APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_LOOKUPS_VIEW

Line 2216: v_s_adm_offer_dfrmnt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE;

2212: cst_no_quota CONSTANT VARCHAR2(10) := 'NO-QUOTA';
2213: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
2214: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
2215: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
2216: v_s_adm_offer_dfrmnt_status IGS_LOOKUPS_VIEW.lookup_code%TYPE;
2217: v_ret_val BOOLEAN;
2218: v_check CHAR := NULL;
2219: v_counter NUMBER := 0;
2220: CURSOR c_recent_his IS