APPS.OE_OE_FORM_HEADER dependencies on OE_PAYMENTS

Line 2562: FROM oe_payments

2558: IF x_header_val_rec.payment_set_id IS NOT NULL THEN
2559: BEGIN
2560: SELECT NVL(SUM(NVL(commitment_applied_amount, 0)), 0)
2561: INTO l_commitment_amount
2562: FROM oe_payments
2563: WHERE header_id = p_header_rec_type.header_id;
2564: EXCEPTION
2565: WHEN NO_DATA_FOUND THEN
2566: l_commitment_amount := 0;

Line 2642: FROM oe_payments

2638:
2639: BEGIN
2640: SELECT trxn_extension_id
2641: INTO l_trxn_extension_id
2642: FROM oe_payments
2643: WHERE header_id = p_header_rec_type.header_id
2644: AND nvl(payment_collection_event,'PREPAY') = 'INVOICE'
2645: AND payment_type_code = 'CREDIT_CARD'
2646: AND line_id is null;