Validation for Organization Code

         SELECT organization_id
           FROM apps.org_organization_definitions
          WHERE NVL (disable_date, sysdate + 1) >= sysdate
            AND inventory_enabled_flag = 'Y'
            AND (   UPPER (organization_code) =UPPER (p_org_code)
                 OR UPPER (organization_name) = UPPER (p_org_code)
                );

Validation for Master Org  :
==================

     SELECT master_organization_id
     FROM apps.mtl_parameters
     WHERE organization_id = (SELECT organization_id FROM apps.org_organization_definitions
                              WHERE organization_code=p_org_code);