DBA Data[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 13653: ar_payment_schedules_all pay

13649:
13650: select count(*)
13651: into l_br_count
13652: from ar_receivable_applications_all ra,
13653: ar_payment_schedules_all pay
13654: where ra.receivable_application_id = l_source_id and
13655: ra.applied_payment_schedule_id = pay.payment_schedule_id and
13656: pay.class ='BR';
13657: EXCEPTION

Line 15439: ar_payment_schedules_all sch

15435: -1* lad.acctd_amount)) * ABS(lad.from_acctd_amount) --FROM_ACCTD_AMOUNT
15436: , lad.ledger_id --LEDGER_ID
15437: , lad.base_currency --BASE_CURRENCY
15438: FROM AR_LINE_APP_DETAIL_GT lad,
15439: ar_payment_schedules_all sch
15440: WHERE lad.ref_customer_trx_id = sch.customer_trx_id
15441: AND lad.gt_id = p_gt_id;
15442: l_rows := sql%rowcount;
15443: IF PG_DEBUG = 'Y' THEN