APPS.IGR_AD_VAL_ES dependencies on IGS_LOOKUPS_VIEW

Line 15: FROM IGS_LOOKUPS_VIEW ses

11: DECLARE
12: v_closed_ind VARCHAR2(1);
13: CURSOR c_ses IS
14: SELECT ses.closed_ind
15: FROM IGS_LOOKUPS_VIEW ses
16: WHERE ses.lookup_type = 'IGR_ENQUIRY_STATUS' AND
17: ses.lookup_code = p_s_enquiry_status AND
18: ses.closed_ind = 'Y';
19: BEGIN