APPS.OE_DEFAULT_HEADER_PAYMENT dependencies on OE_PAYMENTS

Line 228: FROM oe_payments

224: AND p_header_id <> FND_API.G_MISS_NUM THEN
225: BEGIN
226: SELECT 'Y'
227: INTO l_exists_null_number
228: FROM oe_payments
229: WHERE payment_number is null
230: AND header_id = p_header_id
231: AND line_id is null
232: AND rownum = 1;

Line 240: FROM OE_PAYMENTS

236:
237: IF l_exists_null_number = 'N' THEN
238: SELECT NVL(MAX(PAYMENT_NUMBER)+1,1)
239: INTO l_payment_number
240: FROM OE_PAYMENTS
241: WHERE HEADER_ID = p_header_id
242: AND LINE_ID IS NULL;
243: ELSE
244: SELECT MAX(NVL(PAYMENT_NUMBER, 1))+1

Line 246: FROM OE_PAYMENTS

242: AND LINE_ID IS NULL;
243: ELSE
244: SELECT MAX(NVL(PAYMENT_NUMBER, 1))+1
245: INTO l_payment_number
246: FROM OE_PAYMENTS
247: WHERE HEADER_ID = p_header_id
248: AND LINE_ID IS NULL;
249: END IF;
250: