APPS.PON_EMD_VALIDATION_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 196: ar_cash_receipts_all acr

192: INTO x_cash_receipt_id, x_receivable_app_id
193: from ar_receivable_applications_all arp,
194: ra_customer_trx_all rct,
195: ra_cust_trx_types_all ctyp,
196: ar_cash_receipts_all acr
197: where arp.applied_customer_trx_id = p_trx_id
198: AND arp.org_id = p_org_id
199: AND arp.status = 'APP'
200: AND arp.applied_customer_trx_id = rct.customer_trx_id

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