DBA Data[Home] [Help]

APPS.AR_BUS_EVENT_COVER dependencies on RA_CUSTOMER_TRX

Line 243: FROM RA_CUSTOMER_TRX_ALL

239: THEN
240:
241: SELECT org_id
242: INTO l_org_id
243: FROM RA_CUSTOMER_TRX_ALL
244: WHERE customer_trx_id = p_unique_id;
245:
246: ELSIF p_column_name = 'CASH_RECEIPT_ID'
247: THEN

Line 278: FROM ra_customer_trx_all

274: THEN
275:
276: SELECT org_id
277: INTO l_org_id
278: FROM ra_customer_trx_all
279: WHERE request_id = p_unique_id
280: AND rownum = 1;
281:
282: ELSIF p_trx_type = 'RECEIPTS'

Line 339: ra_customer_trx ctx

335: prev_trx_ps.class,
336: prev_trx_ps.amount_credited,
337: prev_trx_ps.due_date
338: from ar_payment_schedules prev_trx_ps,
339: ra_customer_trx ctx
340: where ctx.customer_trx_id = p_ctx_id
341: and ctx.previous_customer_trx_id = prev_trx_ps.customer_trx_id
342: ;
343:

Line 507: ra_customer_trx ctx

503: prev_trx_ps.amount_credited,
504: prev_trx_ps.due_date,
505: ctx.previous_customer_trx_id
506: from ar_payment_schedules prev_trx_ps,
507: ra_customer_trx ctx
508: where ctx.customer_trx_id = p_ctx_id
509: and ctx.previous_customer_trx_id = prev_trx_ps.customer_trx_id
510: ;
511: