DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on OE_PAYMENTS

Line 2562: from oe_payments

2558:
2559: THEN
2560:
2561: select count(payment_type_code) into l_payment_count
2562: from oe_payments
2563: where header_id = p_header_rec.header_id
2564: and line_id is null;
2565:
2566: if l_payment_count > 1 then

Line 3719: oe_payments op

3715: BEGIN
3716: SELECT 'Y'
3717: INTO l_auth_exist
3718: FROM iby_trxn_ext_auths_v iby_auth ,
3719: oe_payments op
3720: WHERE iby_auth.trxn_extension_id = op.trxn_extension_id
3721: AND NVL(iby_auth.authorization_amount,0) > 0
3722: AND iby_auth.authorization_status =0
3723: AND op.payment_level_code ='ORDER'