APPS.AHL_UTILITY_PVT SQL Statements

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

Line: 121

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

Line: 168

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;

Line: 215

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

Line: 353

  SELECT  1 FROM DUAL
  WHERE EXISTS (SELECT *  FROM AHL_USER_STATUSES_VL
                WHERE user_status_id = p_user_status_id
                  AND system_status_type = p_status_type
                  AND system_status_code = p_next_status
                  AND active_flag = 'Y');

Line: 395

  SELECT  1 FROM DUAL
  WHERE EXISTS (SELECT *  FROM AHL_STATUS_ORDER_RULES
                WHERE system_status_type = p_status_type
                  AND current_status_code = p_current_status
                  AND next_status_code = p_next_status);

Line: 404

  SELECT system_status_code
    FROM AHL_USER_STATUSES_VL
   WHERE system_status_type = c_status_type
     AND name               = c_status_code;

Line: 475

  SELECT '1'  FROM AHL_STATUS_ORDER_RULES
    WHERE system_status_type = c_status_type
      AND current_status_code = c_current_status
      AND next_status_code = c_next_status;

Line: 545

      SELECT  wf_process_name, Item_type, Active_flag
      FROM    AHL_WF_MAPPING
      WHERE   Approval_object = in_object
      AND APPLICATION_USG_CODE = in_appl_usg_code;

Line: 551

      SELECT  wf_process_name, Item_type, Active_flag
      FROM    AHL_WF_MAPPING
      WHERE   Approval_object IS NULL
      AND APPLICATION_USG_CODE = in_appl_usg_code;

Line: 557

    SELECT 1 FROM FND_LOOKUPS
    WHERE lookup_code = p_application_usg_code
    AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';

Line: 622

    SELECT object_id
      FROM csi_ii_relationships
     WHERE object_id IN (SELECT csi_item_instance_id
                           FROM ahl_unit_config_headers
                          WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
START WITH subject_id = p_instance_id
       AND relationship_type_code = 'COMPONENT-OF'
       AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
       AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
CONNECT BY subject_id = PRIOR object_id
       AND relationship_type_code = 'COMPONENT-OF'
       AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
       AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line: 637

    SELECT name
      FROM ahl_unit_config_headers
     WHERE csi_item_instance_id = c_instance_id
       AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line: 683

SELECT hou.organization_id
FROM HR_ORGANIZATION_UNITS hou
WHERE hou.name = p_org_name;

Line: 692

SELECT hou.organization_id
FROM HR_ORGANIZATION_UNITS hou,
MTL_PARAMETERS mtl
WHERE
hou.organization_id IN (
                SELECT organization_id
                FROM INV_ORGANIZATION_INFO_V

                WHERE NVL(operating_unit, mo_global.get_current_org_id()) =
                                      mo_global.get_current_org_id()

                   )
AND mtl.organization_id = hou.organization_id
AND mtl.eam_enabled_flag = 'Y'
AND hou.organization_id = p_org_id;

Line: 769

        SELECT meaning
        FROM fnd_lookup_values
        WHERE lookup_type = p_lookup_type
        AND lookup_code = p_lookup_code
        AND language = userenv('LANG');