APPS.IGS_AD_GEN_009 dependencies on IGS_AD_DOC_STAT

Line 50: FROM IGS_AD_DOC_STAT ads

46: -- status for given the system admission documentation status
47: DECLARE
48: CURSOR c_ads IS
49: SELECT ads.adm_doc_status
50: FROM IGS_AD_DOC_STAT ads
51: WHERE ads.s_adm_doc_status = p_s_adm_doc_status AND
52: ads.system_default_ind = 'Y' AND
53: ads.closed_ind = 'N';
54: v_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE;

Line 54: v_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE;

50: FROM IGS_AD_DOC_STAT ads
51: WHERE ads.s_adm_doc_status = p_s_adm_doc_status AND
52: ads.system_default_ind = 'Y' AND
53: ads.closed_ind = 'N';
54: v_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE;
55: BEGIN
56: FOR v_ads_rec IN c_ads LOOP
57: IF c_ads%ROWCOUNT > 1 THEN
58: v_adm_doc_status := NULL;