APPS.AR_AUTOREC_API dependencies on AR_RECEIVABLE_APPLICATIONS

Line 884: update ar_receivable_applications SET

880:
881: arp_standard.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));
882:
883:
884: update ar_receivable_applications SET
885: created_by = l_created_by,
886: last_update_date = sysdate,
887: last_updated_by = l_created_by,
888: last_update_login = l_last_update_login,

Line 908: ar_receivable_applications app,

904: update ar_cash_receipts cr SET
905: receipt_number = nvl((
906: select ps.trx_number
907: from
908: ar_receivable_applications app,
909: ar_payment_schedules ps
910: where
911: app.cash_receipt_id = cr.cash_receipt_id
912: and ps.customer_trx_id = app.applied_customer_trx_id

Line 4787: from ar_receivable_applications

4783:
4784: delete from ar_distributions
4785: where source_table = 'RA'
4786: and source_id in ( select receivable_application_id
4787: from ar_receivable_applications
4788: where cash_receipt_id in ( select distinct cash_receipt_id
4789: from ar_autorec_exceptions
4790: where request_id = l_request_id));
4791:

Line 4796: delete from ar_receivable_applications

4792: IF PG_DEBUG in ('Y','C') THEN
4793: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );
4794: END IF;
4795:
4796: delete from ar_receivable_applications
4797: where cash_receipt_id in ( select distinct cash_receipt_id
4798: from ar_autorec_exceptions
4799: where request_id = l_request_id);
4800: