DBA Data[Home] [Help]

APPS.IGS_EN_GEN_002 dependencies on IGS_AD_OU_STAT

Line 561: FROM IGS_AD_OU_STAT aos

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:

Line 564: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

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