APPS.ARP_DET_DIST_PKG dependencies on AR_PAYMENT_SCHEDULES

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

Line 16313: ar_payment_schedules c

16309: SUM(DECODE(line_type,'CHARGES',amount_due_remaining, 0)) chrg_app,
16310: customer_trx_id
16311: FROM ra_customer_trx_lines
16312: GROUP BY customer_trx_id) d,
16313: ar_payment_schedules c
16314: WHERE b.customer_trx_id = a.customer_trx_id
16315: AND a.customer_trx_id = c.customer_trx_id
16316: AND a.customer_trx_id = d.customer_trx_id
16317: AND c.customer_trx_id = p_customer_trx_id;