DBA Data[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 15307: ar_payment_schedules_all pay

15303:
15304: select count(*)
15305: into l_br_count
15306: from ar_receivable_applications_all ra,
15307: ar_payment_schedules_all pay
15308: where ra.receivable_application_id = l_source_id and
15309: ra.applied_payment_schedule_id = pay.payment_schedule_id and
15310: pay.class ='BR';
15311: EXCEPTION

Line 17151: ar_payment_schedules_all sch

17147: -1* lad.acctd_amount)) * ABS(lad.from_acctd_amount) --FROM_ACCTD_AMOUNT
17148: , lad.ledger_id --LEDGER_ID
17149: , lad.base_currency --BASE_CURRENCY
17150: FROM AR_LINE_APP_DETAIL_GT lad,
17151: ar_payment_schedules_all sch
17152: WHERE lad.ref_customer_trx_id = sch.customer_trx_id
17153: AND lad.gt_id = p_gt_id;
17154: l_rows := sql%rowcount;
17155: IF PG_DEBUG = 'Y' THEN