557: p_adm_offer_resp_status IN VARCHAR2 )
558: RETURN VARCHAR2 AS
559: CURSOR c_aos IS
560: SELECT s_adm_outcome_status
561: FROM IGS_AD_OU_STAT aos
562: WHERE adm_outcome_status = p_adm_outcome_status;
563:
564: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
565:
560: SELECT s_adm_outcome_status
561: FROM IGS_AD_OU_STAT aos
562: WHERE adm_outcome_status = p_adm_outcome_status;
563:
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