APPS.IGS_AD_VAL_ADS dependencies on IGS_AD_DOC_STAT

Line 51: v_sys_def_ind IGS_AD_DOC_STAT.system_default_ind%TYPE;

47: -- Check if another adm_doc_status record exists with the system
48: -- default indicator set to 'Y'
49: DECLARE
50: v_count_rec NUMBER;
51: v_sys_def_ind IGS_AD_DOC_STAT.system_default_ind%TYPE;
52: CURSOR c_count IS
53: SELECT count(*),
54: system_default_ind
55: FROM IGS_AD_DOC_STAT ads

Line 55: FROM IGS_AD_DOC_STAT ads

51: v_sys_def_ind IGS_AD_DOC_STAT.system_default_ind%TYPE;
52: CURSOR c_count IS
53: SELECT count(*),
54: system_default_ind
55: FROM IGS_AD_DOC_STAT ads
56: WHERE ads.adm_doc_status <> p_adm_doc_status AND
57: ads.s_adm_doc_status = p_s_adm_doc_status AND
58: ads.system_default_ind = 'Y'
59: GROUP BY system_default_ind;