DBA Data[Home] [Help]

APPS.IGS_AD_GEN_007 dependencies on IGS_AD_ENT_QF_STAT

Line 688: v_qual_status IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE;

684: RETURN VARCHAR2 IS
685: BEGIN --admp_get_saeqs
686: --Get the s_adm_entry_qual_status for a specified adm_entry_qual_status.
687: DECLARE
688: v_qual_status IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE;
689: CURSOR c_aeqs IS
690: SELECT s_adm_entry_qual_status
691: FROM IGS_AD_ENT_QF_STAT
692: WHERE adm_entry_qual_status = p_adm_entry_qual_status;

Line 691: FROM IGS_AD_ENT_QF_STAT

687: DECLARE
688: v_qual_status IGS_AD_ENT_QF_STAT.s_adm_entry_qual_status%TYPE;
689: CURSOR c_aeqs IS
690: SELECT s_adm_entry_qual_status
691: FROM IGS_AD_ENT_QF_STAT
692: WHERE adm_entry_qual_status = p_adm_entry_qual_status;
693: BEGIN
694: --initialise v_s_adm_doc_status
695: v_qual_status := NULL;