APPS.OE_OE_FORM_HEADER dependencies on OE_PAYMENTS

Line 2561: FROM oe_payments

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

Line 2641: FROM oe_payments

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