APPS.AR_CM_VAL_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 134: p_cm_amount_rem OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,

130:
131: PROCEDURE default_cm_info(
132: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
133: p_cm_gl_date OUT NOCOPY DATE,
134: p_cm_amount_rem OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
135: p_cm_trx_date OUT NOCOPY DATE,
136: p_cm_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ,
137: p_cm_currency_code OUT NOCOPY fnd_currencies.currency_code%TYPE,
138: p_cm_customer_id OUT NOCOPY ra_customer_trx.paying_customer_id%TYPE,

Line 136: p_cm_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ,

132: p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
133: p_cm_gl_date OUT NOCOPY DATE,
134: p_cm_amount_rem OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
135: p_cm_trx_date OUT NOCOPY DATE,
136: p_cm_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ,
137: p_cm_currency_code OUT NOCOPY fnd_currencies.currency_code%TYPE,
138: p_cm_customer_id OUT NOCOPY ra_customer_trx.paying_customer_id%TYPE,
139: p_return_status OUT NOCOPY VARCHAR2
140: ) IS

Line 166: ar_payment_schedules ps

162: p_cm_amount_rem,
163: p_cm_customer_id,
164: p_cm_currency_code
165: FROM ra_customer_trx cm,
166: ar_payment_schedules ps
167: WHERE ps.customer_trx_id = cm.customer_trx_id
168: AND cm.customer_trx_id = p_cm_customer_trx_id;
169:
170: EXCEPTION

Line 378: p_cm_amount_rem IN ar_payment_schedules.amount_due_remaining%TYPE,

374:
375: PROCEDURE default_amt_applied(
376: p_inv_currency_code IN fnd_currencies.currency_code%TYPE,
377: p_cm_currency_code IN fnd_currencies.currency_code%TYPE,
378: p_cm_amount_rem IN ar_payment_schedules.amount_due_remaining%TYPE,
379: p_inv_amount_rem IN ar_payment_schedules.amount_due_Remaining%TYPE,
380: p_amount_applied IN OUT NOCOPY NUMBER,
381: p_return_status OUT NOCOPY VARCHAR2
382: )

Line 379: p_inv_amount_rem IN ar_payment_schedules.amount_due_Remaining%TYPE,

375: PROCEDURE default_amt_applied(
376: p_inv_currency_code IN fnd_currencies.currency_code%TYPE,
377: p_cm_currency_code IN fnd_currencies.currency_code%TYPE,
378: p_cm_amount_rem IN ar_payment_schedules.amount_due_remaining%TYPE,
379: p_inv_amount_rem IN ar_payment_schedules.amount_due_Remaining%TYPE,
380: p_amount_applied IN OUT NOCOPY NUMBER,
381: p_return_status OUT NOCOPY VARCHAR2
382: )
383:

Line 583: ar_payment_schedules ps

579: BEGIN
580: SELECT ps.payment_schedule_id
581: INTO l_inv_ps_id
582: FROM ra_customer_trx ct,
583: ar_payment_schedules ps
584: WHERE ct.customer_trx_id = p_inv_customer_trx_id
585: AND ct.customer_trx_id = ps.customer_trx_id
586: --AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
587: AND ps.terms_sequence_number = p_installment

Line 609: ar_payment_schedules ps

605: BEGIN
606: SELECT ps.payment_schedule_id
607: INTO l_inv_ps_id
608: FROM ra_customer_trx ct,
609: ar_payment_schedules ps
610: WHERE ct.customer_trx_id = p_inv_customer_trx_id
611: AND ct.customer_trx_id = ps.customer_trx_id
612: --AND ps.class IN ('CB','CM','DEP','DM','INV','BR')
613: ;

Line 652: ar_payment_schedules ps

648: ) IS
649: CURSOR rec_apppln IS
650: SELECT ra.applied_customer_trx_id, ra.applied_payment_schedule_id, ra.gl_date
651: FROM ar_receivable_applications ra,
652: ar_payment_schedules ps
653: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
654: AND ra.receivable_application_id = p_ra_id
655: AND ra.display = 'Y'
656: AND ra.status = 'APP'

Line 954: FROM ar_payment_schedules

950:
951:
952: CURSOR c_pay_sched IS
953: SELECT customer_trx_id, terms_sequence_number
954: FROM ar_payment_schedules
955: WHERE payment_schedule_id = p_applied_payment_schedule_id and
956: payment_schedule_id >0 and
957: class in ('INV','DM'); -- Should we include DM, DEP, GUAR, CB?
958:

Line 1049: FROM ar_payment_schedules

1045: IF p_installment IS NULL THEN
1046: BEGIN
1047: SELECT terms_sequence_number
1048: INTO p_installment
1049: FROM ar_payment_schedules
1050: WHERE customer_trx_id = p_inv_customer_trx_id;
1051: EXCEPTION
1052: WHEN no_data_found THEN
1053: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');

Line 1377: FROM ar_payment_schedules

1373: ) IS
1374:
1375: CURSOR c_pay_sched IS
1376: SELECT customer_trx_id, terms_sequence_number
1377: FROM ar_payment_schedules
1378: WHERE payment_schedule_id = p_applied_payment_schedule_id and
1379: payment_schedule_id >0 and
1380: class in ('INV','DM'); -- Should we include BR, DEP, GUAR, CB?
1381:

Line 1550: FROM ar_payment_schedules

1546: THEN
1547: BEGIN
1548: SELECT gl_date
1549: INTO p_cm_gl_date
1550: FROM ar_payment_schedules
1551: WHERE customer_trx_id = l_cm_customer_trx_id;
1552: EXCEPTION
1553: WHEN no_data_found THEN
1554: null;