eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ARP_DET_DIST_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 13508: select count(*) into l_count from ar_payment_schedules where customer_trx_id=p_customer_trx.customer_trx_id;

13504: END IF;
13505:
13506: l_boundary_flag := 'N';
13507:
13508: select count(*) into l_count from ar_payment_schedules where customer_trx_id=p_customer_trx.customer_trx_id;
13509:
13510: IF l_count = 1 THEN
13511: select status,amount_due_original,amount_due_remaining into l_status,l_amt_due_orig_ps,l_amt_due_rem_ps
13512: from ar_payment_schedules where customer_trx_id=p_customer_trx.customer_trx_id;

Line 13512: from ar_payment_schedules where customer_trx_id=p_customer_trx.customer_trx_id;

13508: select count(*) into l_count from ar_payment_schedules where customer_trx_id=p_customer_trx.customer_trx_id;
13509:
13510: IF l_count = 1 THEN
13511: select status,amount_due_original,amount_due_remaining into l_status,l_amt_due_orig_ps,l_amt_due_rem_ps
13512: from ar_payment_schedules where customer_trx_id=p_customer_trx.customer_trx_id;
13513: if l_status = 'CL' THEN
13514: l_boundary_flag := 'C';
13515: end if;
13516: ELSE

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 15409: FROM ar_payment_schedules ps,

15405: SELECT ps.trx_date, NVL(ps.exchange_rate, 1),
15406: ps1.trx_date, NVL(ps1.exchange_rate, 1)
15407: INTO l_app_date, l_app_exch_rate,
15408: l_trx_date, l_trx_exch_rate
15409: FROM ar_payment_schedules ps,
15410: ar_payment_schedules ps1,
15411: ar_receivable_applications ra
15412: WHERE ra.receivable_application_id = p_app_rec.receivable_application_id
15413: and ps.payment_schedule_id = ra.payment_schedule_id

Line 15410: ar_payment_schedules ps1,

15406: ps1.trx_date, NVL(ps1.exchange_rate, 1)
15407: INTO l_app_date, l_app_exch_rate,
15408: l_trx_date, l_trx_exch_rate
15409: FROM ar_payment_schedules ps,
15410: ar_payment_schedules ps1,
15411: ar_receivable_applications ra
15412: WHERE ra.receivable_application_id = p_app_rec.receivable_application_id
15413: and ps.payment_schedule_id = ra.payment_schedule_id
15414: AND ps1.payment_schedule_id = ra.applied_payment_schedule_id;

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

Line 18032: ar_payment_schedules c

18028: SUM(DECODE(line_type,'CHARGES',amount_due_remaining, 0)) chrg_app,
18029: customer_trx_id
18030: FROM ra_customer_trx_lines
18031: GROUP BY customer_trx_id) d,
18032: ar_payment_schedules c
18033: WHERE b.customer_trx_id = a.customer_trx_id
18034: AND a.customer_trx_id = c.customer_trx_id
18035: AND a.customer_trx_id = d.customer_trx_id
18036: AND c.customer_trx_id = p_customer_trx_id;