DBA Data[Home] [Help]

APPS.ARP_PROCESS_DIST dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1191: FROM ar_receivable_applications app

1187: DECLARE
1188: CURSOR del_app_dist IS
1189: SELECT app.receivable_application_id app_id,
1190: app.customer_trx_id trx_id
1191: FROM ar_receivable_applications app
1192: WHERE app.applied_customer_trx_id = l_previous_customer_trx_id
1193: AND app.customer_trx_id = p_customer_trx_id
1194: AND app.posting_control_id = -3
1195: AND NVL(app.confirmed_flag,'Y') = 'Y'