DBA Data[Home] [Help]

APPS.PA_PAXARPPR_XMLP_PKG dependencies on PA_PURGE_BATCHES

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;