2343: SET line_collectible_flag = 'Y'
2344: WHERE dl.request_id = p_request_id
2345: AND NOT EXISTS
2346: (SELECT 'incomplete contingency'
2347: FROM ar_line_conts_all lc
2348: WHERE request_id = p_request_id
2349: AND lc.customer_trx_line_id = dl.customer_trx_line_id
2350: AND lc.completed_flag = 'N');
2351: ELSIF p_customer_trx_line_id IS NOT NULL THEN
2353: SET line_collectible_flag = 'Y'
2354: WHERE dl.customer_trx_line_id = p_customer_trx_line_id
2355: AND NOT EXISTS
2356: (SELECT 'incomplete contingency'
2357: FROM ar_line_conts_all lc
2358: WHERE customer_trx_line_id = p_customer_trx_line_id
2359: AND lc.customer_trx_line_id = dl.customer_trx_line_id
2360: AND lc.completed_flag = 'N');
2361: END IF;