APPS.OE_VALIDATE_HEADER_PAYMENT dependencies on OE_PAYMENTS

Line 150: from oe_payments

146: -- total prepayment payment amount cannot be greater than order total.
147: BEGIN
148: select nvl(sum(payment_amount),0)
149: into l_prepay_payment_amount
150: from oe_payments
151: where header_id = p_Header_Payment_rec.header_id
152: and payment_collection_event = 'PREPAY'
153: and prepaid_amount is null
154: and nvl(payment_number, -1) <> nvl(p_Header_Payment_rec.payment_number, -1);

Line 163: from oe_payments

159:
160: BEGIN
161: select nvl(sum(prepaid_amount),0)
162: into l_prepaid_amount
163: from oe_payments
164: where header_id = p_Header_Payment_rec.header_id
165: and prepaid_amount is not null
166: and nvl(payment_number, -1) <> nvl(p_Header_Payment_rec.payment_number, -1);
167: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 194: from oe_payments

190:
191:
192: -- if there exists any line level payment.
193: select count(payment_type_code) into l_line_payment_count
194: from oe_payments
195: where header_id = p_Header_Payment_rec.header_id
196: and line_id is not null
197: and payment_type_code <> 'COMMITMENT';
198:

Line 353: FROM oe_payments

349:
350: -- Cannot have more than one 'Invoice' payment instrument
351: SELECT count(*)
352: INTO l_count
353: FROM oe_payments
354: WHERE header_id = p_Header_Payment_rec.header_id
355: AND line_id is null
356: AND payment_level_code = 'ORDER'
357: AND nvl(payment_collection_event, 'INVOICE') = 'INVOICE'

Line 692: from oe_payments

688: --16309734 Start
689: IF p_Header_Payment_rec.payment_collection_event ='PREPAY' THEN
690: --16309734 End
691: select count(payment_type_code) into l_line_payment_count
692: from oe_payments
693: where header_id = p_Header_Payment_rec.header_id
694: and line_id is not null;
695:
696: if l_line_payment_count > 0 then