APPS.AR_PREPAYMENTS dependencies on AR_PAYMENT_SCHEDULES

Line 769: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

765: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
766: -- ** OUT NOCOPY variables for Creating receipt
767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
768: -- Receipt application parameters
769: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
770: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
771: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
772: p_application_ref_id IN OUT NOCOPY NUMBER ,
773: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,

Line 1596: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

1592: AND applied_payment_schedule_id = -7
1593: AND payment_set_id = c_payment_set_id
1594: order by amount_applied;
1595:
1596: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
1597: l_ps_rec ar_payment_schedules%ROWTYPE;
1598: l_api_version CONSTANT NUMBER := 1.0;
1599: l_api_name CONSTANT VARCHAR2(20) := 'MATCH_PREPAYMENT';
1600: l_return_status VARCHAR2(1);

Line 1597: l_ps_rec ar_payment_schedules%ROWTYPE;

1593: AND payment_set_id = c_payment_set_id
1594: order by amount_applied;
1595:
1596: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
1597: l_ps_rec ar_payment_schedules%ROWTYPE;
1598: l_api_version CONSTANT NUMBER := 1.0;
1599: l_api_name CONSTANT VARCHAR2(20) := 'MATCH_PREPAYMENT';
1600: l_return_status VARCHAR2(1);
1601: l_msg_count NUMBER;

Line 1623: FROM ar_payment_schedules ps,

1619:
1620: BEGIN
1621: SELECT 'Y'
1622: INTO l_prepayment_exist_flag
1623: FROM ar_payment_schedules ps,
1624: ra_customer_trx ct
1625: WHERE ps.customer_trx_id =ct.customer_trx_id
1626: AND NVL(ct.prepayment_flag,'N') = 'Y'
1627: AND ps.payment_schedule_id=l_payment_schedule_id;

Line 2152: ar_payment_schedules ps

2148: ps.payment_schedule_id,
2149: ps.amount_due_remaining
2150: FROM
2151: ra_customer_trx ct,
2152: ar_payment_schedules ps
2153: WHERE ps.status = 'OP'
2154: AND ps.amount_due_remaining > 0
2155: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')
2156: --- Bug : 917451 in order to force the use of AR_PAYMENT_SCHEDULES_N9 --

Line 2156: --- Bug : 917451 in order to force the use of AR_PAYMENT_SCHEDULES_N9 --

2152: ar_payment_schedules ps
2153: WHERE ps.status = 'OP'
2154: AND ps.amount_due_remaining > 0
2155: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')
2156: --- Bug : 917451 in order to force the use of AR_PAYMENT_SCHEDULES_N9 --
2157: AND ps.selected_for_receipt_batch_id IS NULL
2158: ---AND ps.due_date +0 <= TO_DATE(SYSDATE) + TO_NUMBER(rm.lead_days)
2159: AND nvl(ct.prepayment_flag, 'N') = 'Y'
2160: AND ps.customer_trx_id = ct.customer_trx_id