DBA Data[Home] [Help]

APPS.IGS_AD_GEN_007 dependencies on IGS_AD_DOC_STAT

Line 667: v_s_adm_doc_status IGS_AD_DOC_STAT.s_adm_doc_status%TYPE;

663: RETURN VARCHAR2 IS
664: BEGIN --admp_get_sads
665: --Get the s_adm_doc_status for a specified adm_doc_status
666: DECLARE
667: v_s_adm_doc_status IGS_AD_DOC_STAT.s_adm_doc_status%TYPE;
668: CURSOR c_ads IS
669: SELECT s_adm_doc_status
670: FROM IGS_AD_DOC_STAT
671: WHERE adm_doc_status = p_adm_doc_status;

Line 670: FROM IGS_AD_DOC_STAT

666: DECLARE
667: v_s_adm_doc_status IGS_AD_DOC_STAT.s_adm_doc_status%TYPE;
668: CURSOR c_ads IS
669: SELECT s_adm_doc_status
670: FROM IGS_AD_DOC_STAT
671: WHERE adm_doc_status = p_adm_doc_status;
672: BEGIN
673: --initialise v_s_adm_doc_status
674: v_s_adm_doc_status := NULL;