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

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

Line 2209: ar_payment_schedules ps

2205: ps.payment_schedule_id,
2206: ps.amount_due_remaining
2207: FROM
2208: ra_customer_trx ct,
2209: ar_payment_schedules ps
2210: WHERE ps.status = 'OP'
2211: AND ps.amount_due_remaining > 0
2212: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')
2213: --- Bug : 917451 in order to force the use of AR_PAYMENT_SCHEDULES_N9 --

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

2209: ar_payment_schedules ps
2210: WHERE ps.status = 'OP'
2211: AND ps.amount_due_remaining > 0
2212: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')
2213: --- Bug : 917451 in order to force the use of AR_PAYMENT_SCHEDULES_N9 --
2214: AND ps.selected_for_receipt_batch_id IS NULL
2215: ---AND ps.due_date +0 <= TO_DATE(SYSDATE) + TO_NUMBER(rm.lead_days)
2216: AND nvl(ct.prepayment_flag, 'N') = 'Y'
2217: AND ps.customer_trx_id = ct.customer_trx_id

Line 2253: ar_payment_schedules ps

2249: ps.amount_due_remaining,
2250: ps.due_date
2251: FROM
2252: ra_customer_trx ct,
2253: ar_payment_schedules ps
2254: WHERE ps.status = 'OP'
2255: AND ps.amount_due_remaining > 0
2256: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')
2257: AND ps.selected_for_receipt_batch_id IS NULL

Line 2269: ar_payment_schedules ps

2265: ps.amount_due_remaining,
2266: ps.due_date
2267: FROM
2268: ra_customer_trx ct,
2269: ar_payment_schedules ps
2270: WHERE ps.status = 'OP'
2271: AND ps.amount_due_remaining > 0
2272: AND ps.gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD')
2273: AND ps.selected_for_receipt_batch_id IS NULL