DBA Data[Home] [Help]

APPS.PON_EMD_VALIDATION_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 239: FROM ar_cash_Receipt_history_all acrh, ar_cash_receipts_all acr

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
241: AND acrh.current_record_flag = 'Y'
242: AND acr.cash_receipt_id = x_cash_receipt_id;
243: EXCEPTION