APPS.OE_VALIDATE_LINE_PAYMENT dependencies on OE_PAYMENTS

Line 138: FROM oe_payments

134: IF p_line_payment_rec.Operation = OE_GLOBALS.G_OPR_CREATE THEN
135: BEGIN
136: SELECT trxn_extension_id
137: INTO l_hdr_trxn_extn_id
138: FROM oe_payments
139: WHERE header_id=p_Line_Payment_rec.header_id
140: AND line_id IS NULL
141: AND nvl(payment_collection_event, 'PREPAY') = 'INVOICE';
142:

Line 268: FROM oe_payments

264:
265: -- Cannot have more than one 'Invoice' payment instrument
266: SELECT count(payment_type_code)
267: INTO l_count
268: FROM oe_payments
269: WHERE line_id = p_Line_Payment_rec.line_id
270: AND header_id = p_Line_Payment_rec.header_id
271: AND payment_level_code = 'LINE'
272: AND nvl(payment_number, -1) <> nvl(p_Line_Payment_rec.payment_number, -1)

Line 281: from oe_payments

277: IF p_Line_Payment_rec.payment_type_code = 'COMMITMENT'
278: THEN
279: SELECT count(payment_type_code)
280: into l_comt_count
281: from oe_payments
282: where line_id = p_Line_Payment_rec.line_id
283: and header_id = p_Line_Payment_rec.header_id
284: and payment_level_code = 'LINE'
285: and nvl(payment_number, -1) <> nvl(p_Line_Payment_rec.payment_number, -1)

Line 302: from oe_payments

298: END IF;
299: END IF;
300:
301: select count(payment_type_code) into l_prepay_count
302: from oe_payments
303: where (payment_collection_event = 'PREPAY'
304: or prepaid_amount is not null )
305: and header_id = p_Line_Payment_rec.header_id;
306: