APPS.AR_RECEIPT_VAL_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 2349: -- in AR_PAYMENT_SCHEDULES table. Also check to see if the CB has

2345: IF p_reversal_date IS NULL OR
2346: p_receipt_state <> 'APPROVED' THEN
2347: -- Check if a 'CB' was created against this PMT to be reversed.
2348: -- Check if there are any PMT, ADJ, or CM or CB against this 'CB' records
2349: -- in AR_PAYMENT_SCHEDULES table. Also check to see if the CB has
2350: -- already been posted. If any of these 2 conditions is TRUE, then
2351: -- PMT can only be reversed using DM Reversal.
2352: -- Make sure that the adj which is automatically created against the CB
2353: -- associated with the receipt being reversed does not get caught in

Line 2359: FROM ar_payment_schedules ps,

2355:
2356:
2357: SELECT COUNT(payment_schedule_id)
2358: INTO l_dummy
2359: FROM ar_payment_schedules ps,
2360: ra_cust_trx_line_gl_dist rctlg
2361: WHERE ps.associated_cash_receipt_id = p_cash_receipt_id
2362: AND ps.class = 'CB'
2363: AND ps.customer_trx_id = rctlg.customer_trx_id

Line 2421: FROM ar_payment_schedules ps,

2417:
2418: BEGIN
2419: SELECT 'Y'
2420: INTO l_reserved
2421: FROM ar_payment_schedules ps,
2422: ar_receivable_applications ra
2423: WHERE ra.cash_receipt_id = p_cash_receipt_id
2424: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
2425: AND ps.reserved_type IS NOT NULL

Line 3166: FROM ar_payment_schedules

3162: IF p_link_to_customer_trx_id IS NOT NULL THEN
3163: BEGIN
3164: SELECT 'Y'
3165: INTO l_valid
3166: FROM ar_payment_schedules
3167: WHERE customer_trx_id=p_link_to_customer_trx_id
3168: AND class='CB';
3169: EXCEPTION
3170: WHEN no_data_found THEN