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.

APPS.ARP_BILLS_RECEIVABLE_MAIN dependencies on AR_PAYMENT_SCHEDULES

Line 103: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE);

99:
100: PROCEDURE reverse_single_dist_line(p_dist_rec IN ar_distributions%ROWTYPE);
101:
102: PROCEDURE reverse_old_acct(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
103: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE);
104:
105: PROCEDURE find_rec_dist_record(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
106: p_sign IN NUMBER,
107: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE);

Line 767: ar_payment_schedules pay

763: p_trh_rec.event,
764: p_trh_rec.prv_trx_history_id
765: from ar_transaction_history th,
766: ra_customer_trx ctinv,
767: ar_payment_schedules pay
768: where th.transaction_history_id = g_ae_doc_rec.source_id
769: and th.customer_trx_id = ctinv.customer_trx_id
770: and ctinv.customer_trx_id = pay.customer_trx_id;
771:

Line 1551: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE) IS

1547: | p_transaction_history_id Transaction history ID
1548: | p_ps_id Payment Schedule ID
1549: * ======================================================================*/
1550: PROCEDURE reverse_old_acct(p_transaction_history_id IN ar_transaction_history.transaction_history_id%TYPE,
1551: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE) IS
1552:
1553: /*----------------------------------------------------------+
1554: | This is used in deciding which distribution record |
1555: | to reverse and whether the amount has changed since last |

Line 1572: from ar_payment_schedules ps

1568: -- ps.payment_schedule_id,
1569: -- g_ae_sys_rec.set_of_books_id)) acctd_amount_due_remaining
1570: ps.acctd_amount_due_remaining acctd_amount_due_remaining
1571: --}
1572: from ar_payment_schedules ps
1573: where ps.payment_schedule_id = p_ps_id;
1574:
1575: l_ard_rec ar_distributions%ROWTYPE;
1576: l_prev_posted_trh_rec ar_transaction_history%ROWTYPE;

Line 2354: ar_payment_schedules ps,

2350: -- g_ae_sys_rec.set_of_books_id)) exchange_date
2351: ps.exchange_date exchange_date
2352: --}
2353: FROM ra_customer_trx_lines ctl,
2354: ar_payment_schedules ps,
2355: ar_payment_schedules assignment_ps,
2356: ra_customer_trx ct,
2357: ar_adjustments adj
2358: WHERE assignment_ps.payment_schedule_id = ctl.br_ref_payment_schedule_id

Line 2355: ar_payment_schedules assignment_ps,

2351: ps.exchange_date exchange_date
2352: --}
2353: FROM ra_customer_trx_lines ctl,
2354: ar_payment_schedules ps,
2355: ar_payment_schedules assignment_ps,
2356: ra_customer_trx ct,
2357: ar_adjustments adj
2358: WHERE assignment_ps.payment_schedule_id = ctl.br_ref_payment_schedule_id
2359: AND ps.customer_trx_id = ct.customer_trx_id