APPS.IGS_AD_VAL_ADS dependencies on IGS_LOOKUP_VALUES

Line 14: FROM IGS_LOOKUP_VALUES sads

10: DECLARE
11: v_closed_ind VARCHAR(1);
12: CURSOR c_sads IS
13: SELECT sads.closed_ind
14: FROM IGS_LOOKUP_VALUES sads
15: WHERE sads.lookup_type = 'ADM_DOC_STATUS' AND
16: sads.lookup_code = p_s_adm_doc_status;
17: BEGIN
18: --- Set the default message number