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