DBA Data[Home] [Help]

APPS.PON_EMD_VALIDATION_PKG dependencies on ARPT_SQL_FUNC_UTIL

Line 236: SELECT acr.receipt_number, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('RECEIPT_CREATION_STATUS',

232: RETURN;
233: END;
234: IF (x_cash_receipt_id IS NOT NULL) THEN
235: BEGIN
236: SELECT acr.receipt_number, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('RECEIPT_CREATION_STATUS',
237: acrh.STATUS),acrh.STATUS
238: INTO x_receipt_num, x_receipt_status,x_receipt_status_code
239: FROM ar_cash_Receipt_history_all acrh, ar_cash_receipts_all acr
240: WHERE acrh.cash_receipt_id = acr.cash_receipt_id