DBA Data[Home] [Help]

APPS.IGS_AD_GEN_007 dependencies on IGS_AD_APPL_STAT

Line 618: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;

614: RETURN VARCHAR2 IS
615: BEGIN --admp_get_saas
616: --Get the s_adm_appl_status for a specified adm_appl_status
617: DECLARE
618: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;
619: CURSOR c_aas IS
620: SELECT s_adm_appl_status
621: FROM IGS_AD_APPL_STAT
622: WHERE adm_appl_status = p_adm_appl_status;

Line 621: FROM IGS_AD_APPL_STAT

617: DECLARE
618: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE;
619: CURSOR c_aas IS
620: SELECT s_adm_appl_status
621: FROM IGS_AD_APPL_STAT
622: WHERE adm_appl_status = p_adm_appl_status;
623: BEGIN
624: --initialise v_adm_appl_status
625: v_adm_appl_status := NULL;