APPS.HR_ORGANIZATIONS_SV1 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

   SELECT count(*)
     INTO x_temp
     FROM org_organization_definitions
    WHERE organization_id = x_inv_organization_id
      AND sysdate < nvl(disable_date, sysdate+1)
      AND inventory_enabled_flag = 'Y';

Line: 60

 SELECT organization_id
   INTO X_organization_id_v
   FROM org_organization_definitions
  WHERE organization_code = X_organization_code
    AND sysdate < nvl(disable_date, sysdate+1)
    AND inventory_enabled_flag = 'Y';