APPS.AR_RECEIPT_VAL_PVT dependencies on AR_PAYMENT_SCHEDULES

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

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

Line 2289: FROM ar_payment_schedules ps,

2285:
2286:
2287: SELECT COUNT(payment_schedule_id)
2288: INTO l_dummy
2289: FROM ar_payment_schedules ps,
2290: ra_cust_trx_line_gl_dist rctlg
2291: WHERE ps.associated_cash_receipt_id = p_cash_receipt_id
2292: AND ps.class = 'CB'
2293: AND ps.customer_trx_id = rctlg.customer_trx_id

Line 2351: FROM ar_payment_schedules ps,

2347:
2348: BEGIN
2349: SELECT 'Y'
2350: INTO l_reserved
2351: FROM ar_payment_schedules ps,
2352: ar_receivable_applications ra
2353: WHERE ra.cash_receipt_id = p_cash_receipt_id
2354: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
2355: AND ps.reserved_type IS NOT NULL

Line 3029: FROM ar_payment_schedules

3025: IF p_link_to_customer_trx_id IS NOT NULL THEN
3026: BEGIN
3027: SELECT 'Y'
3028: INTO l_valid
3029: FROM ar_payment_schedules
3030: WHERE customer_trx_id=p_link_to_customer_trx_id
3031: AND class='CB';
3032: EXCEPTION
3033: WHEN no_data_found THEN