APPS.PA_PAXARPPR_XMLP_PKG dependencies on PA_LOOKUPS

Line 56: select meaning into ndf from pa_lookups where

52:
53: IF (get_company_name <> TRUE) THEN RAISE init_failure;
54: END IF;
55:
56: select meaning into ndf from pa_lookups where
57: lookup_code = 'NO_DATA_FOUND' and
58: lookup_type = 'MESSAGE';
59: c_no_data_found := ndf;
60:

Line 113: FROM pa_purge_batches bat, pa_lookups lk

109: SELECT bat.batch_name, bat.description, bat.batch_status_code, bat.txn_to_date,
110: bat.active_closed_flag, lk.meaning, bat.purged_date
111: INTO c_batch_name, c_batch_description, c_batch_status, c_through_date,
112: c_batch_active_closed, c_batch_status_meaning, c_batch_purged_date
113: FROM pa_purge_batches bat, pa_lookups lk
114: WHERE purge_batch_id = p_purge_batch_id
115: AND lk.lookup_type = 'PURGE_BATCH_STATUS'
116: AND lk.lookup_code = bat.batch_status_code;
117: /*srw.message(0,'after select into');*/null;

Line 125: select meaning into ndf from pa_lookups where

121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: /*srw.message(0,'in when no data found');*/null;
124:
125: select meaning into ndf from pa_lookups where
126: lookup_code = 'NO_DATA_FOUND' and
127: lookup_type = 'MESSAGE';
128: c_no_data_found := ndf;
129: c_dummy_data := 1;