APPS.OE_DEFAULT_LINE_PAYMENT dependencies on OE_PAYMENTS

Line 252: FROM oe_payments

248: END IF;
249: BEGIN
250: SELECT 'Y'
251: INTO l_exists_null_number
252: FROM oe_payments
253: WHERE payment_number is null
254: AND header_id = l_header_id
255: AND line_id = p_line_id
256: AND rownum = 1;

Line 264: FROM OE_PAYMENTS

260:
261: IF l_exists_null_number = 'N' THEN
262: SELECT NVL(MAX(PAYMENT_NUMBER)+1,1)
263: INTO l_payment_number
264: FROM OE_PAYMENTS
265: WHERE header_id = l_header_id
266: AND LINE_ID = p_line_id;
267: ELSE
268: SELECT MAX(NVL(PAYMENT_NUMBER, 1))+1

Line 270: FROM OE_PAYMENTS

266: AND LINE_ID = p_line_id;
267: ELSE
268: SELECT MAX(NVL(PAYMENT_NUMBER, 1))+1
269: INTO l_payment_number
270: FROM OE_PAYMENTS
271: WHERE header_id = l_header_id
272: AND LINE_ID = p_line_id;
273: END IF;
274: END IF;