APPS.IGS_EN_GEN_002 dependencies on IGS_AD_OFR_RESP_STAT

Line 568: FROM IGS_AD_OFR_RESP_STAT aors

564: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
565:
566: CURSOR c_aors IS
567: SELECT s_adm_offer_resp_status
568: FROM IGS_AD_OFR_RESP_STAT aors
569: WHERE adm_offer_resp_status = p_adm_offer_resp_status;
570:
571: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
572: gv_other_detail varchar2(255);

Line 571: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

567: SELECT s_adm_offer_resp_status
568: FROM IGS_AD_OFR_RESP_STAT aors
569: WHERE adm_offer_resp_status = p_adm_offer_resp_status;
570:
571: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
572: gv_other_detail varchar2(255);
573: BEGIN
574: OPEN c_aos;
575: FETCH c_aos INTO v_s_adm_outcome_status;