Validation for Order Type

SELECT DISTINCT oetl.transaction_type_id
                    FROM apps.oe_transaction_types_all oeta,
                         apps.oe_transaction_types_tl oetl
                   WHERE oeta.transaction_type_code = 'ORDER'
                     AND oetl.transaction_type_id = oeta.transaction_type_id
                     AND oeta.org_id =p_org_id
                     AND (   UPPER (oetl.NAME) = UPPER (p_order_type)
                          OR UPPER (oetl.description) = UPPER (p_order_type)
                         )
                     AND NVL (oeta.end_date_active, gd_sysdate + 1) >=gd_sysdate;