[Home] [Help]
1580: ) IS
1581:
1582: CURSOR paymentset_cur(c_customer_trx_id NUMBER) IS
1583: SELECT distinct ctl.payment_set_id
1584: FROM ra_customer_trx_lines ctl
1585: WHERE ctl.payment_set_id is not null
1586: AND ctl.customer_trx_id= c_customer_trx_id;
1587:
1588: CURSOR prepayapp_cur(c_payment_set_id NUMBER) IS
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;
1629:
2204: SELECT
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')
2248: ps.payment_schedule_id,
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')
2264: ps.payment_schedule_id,
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')