DBA Data[Home] [Help]

APPS.AR_CM_API_PUB dependencies on RA_CUSTOMER_TRX

Line 559: ra.customer_trx_id,

555: /*Bug 12760563*/
556: l_xla_ev_rec arp_xla_events.xla_events_type;
557: Cursor ra_event_rows (p_customer_trx_id in number) IS
558: SELECT ra.receivable_application_id,
559: ra.customer_trx_id,
560: ct.trx_number
561: from ar_receivable_applications ra, ra_customer_trx ct
562: where ra.posting_control_id=-3
563: and ra.application_type = 'CM'

Line 561: from ar_receivable_applications ra, ra_customer_trx ct

557: Cursor ra_event_rows (p_customer_trx_id in number) IS
558: SELECT ra.receivable_application_id,
559: ra.customer_trx_id,
560: ct.trx_number
561: from ar_receivable_applications ra, ra_customer_trx ct
562: where ra.posting_control_id=-3
563: and ra.application_type = 'CM'
564: and ra.customer_trx_id=p_customer_trx_id
565: and ra.event_id is null

Line 564: and ra.customer_trx_id=p_customer_trx_id

560: ct.trx_number
561: from ar_receivable_applications ra, ra_customer_trx ct
562: where ra.posting_control_id=-3
563: and ra.application_type = 'CM'
564: and ra.customer_trx_id=p_customer_trx_id
565: and ra.event_id is null
566: and ra.customer_trx_id = ct.customer_trx_id;
567:
568: BEGIN

Line 566: and ra.customer_trx_id = ct.customer_trx_id;

562: where ra.posting_control_id=-3
563: and ra.application_type = 'CM'
564: and ra.customer_trx_id=p_customer_trx_id
565: and ra.event_id is null
566: and ra.customer_trx_id = ct.customer_trx_id;
567:
568: BEGIN
569: IF PG_DEBUG in ('Y', 'C') THEN
570: arp_util.debug('ar_cm_api_pub.Unapply_on_account()+ ');