APPS.IGS_AD_VAL_AORS dependencies on IGS_LOOKUP_VALUES

Line 15: FROM IGS_LOOKUP_VALUES saors

11: DECLARE
12: v_closed_ind VARCHAR(1);
13: CURSOR c_saors IS
14: SELECT saors.closed_ind
15: FROM IGS_LOOKUP_VALUES saors
16: WHERE saors.lookup_type = 'ADM_OFFER_RESP_STATUS' AND
17: saors.lookup_code = p_s_adm_offer_resp_status;
18: BEGIN
19: --- Set the default message number