APPS.OE_VALIDATE_HEADER_PAYMENT dependencies on OE_PAYMENTS

Line 115: from oe_payments

111: -- total prepayment payment amount cannot be greater than order total.
112: BEGIN
113: select nvl(sum(payment_amount),0)
114: into l_prepay_payment_amount
115: from oe_payments
116: where header_id = p_Header_Payment_rec.header_id
117: and payment_collection_event = 'PREPAY'
118: and prepaid_amount is null
119: and nvl(payment_number, -1) <> nvl(p_Header_Payment_rec.payment_number, -1);

Line 128: from oe_payments

124:
125: BEGIN
126: select nvl(sum(prepaid_amount),0)
127: into l_prepaid_amount
128: from oe_payments
129: where header_id = p_Header_Payment_rec.header_id
130: and prepaid_amount is not null
131: and nvl(payment_number, -1) <> nvl(p_Header_Payment_rec.payment_number, -1);
132: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 159: from oe_payments

155:
156:
157: -- if there exists any line level payment.
158: select count(payment_type_code) into l_line_payment_count
159: from oe_payments
160: where header_id = p_Header_Payment_rec.header_id
161: and line_id is not null
162: and payment_type_code <> 'COMMITMENT';
163:

Line 318: FROM oe_payments

314:
315: -- Cannot have more than one 'Invoice' payment instrument
316: SELECT count(*)
317: INTO l_count
318: FROM oe_payments
319: WHERE header_id = p_Header_Payment_rec.header_id
320: AND line_id is null
321: AND payment_level_code = 'ORDER'
322: AND nvl(payment_collection_event, 'INVOICE') = 'INVOICE'

Line 655: from oe_payments

651: x_return_status := FND_API.G_RET_STS_ERROR;
652: END IF;
653:
654: select count(payment_type_code) into l_line_payment_count
655: from oe_payments
656: where header_id = p_Header_Payment_rec.header_id
657: and line_id is not null;
658:
659: if l_line_payment_count > 0 then