APPS.OKE_UTILS SQL Statements

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

Line: 50

  SELECT employee_id
  FROM   fnd_user
  WHERE  user_id = c_user_id;

Line: 99

  SELECT full_name
  FROM   per_all_people_f
  WHERE  person_id = c_person_id;

Line: 153

  SELECT meaning
  FROM   fnd_lookups
  WHERE  lookup_type = 'YES_NO'
  AND    lookup_code = X_Lookup_Code;

Line: 193

  SELECT meaning
  FROM   mfg_lookups
  WHERE  lookup_type = 'SYS_YES_NO'
  AND    lookup_code = X_Lookup_Code;

Line: 293

  SELECT Item_Number
  FROM   mtl_item_flexfields
  WHERE  organization_id = X_Inventory_Org_ID
  AND    inventory_item_id = X_Item_ID;

Line: 339

  SELECT Description
  FROM   mtl_system_items
  WHERE  organization_id = X_Inventory_Org_ID
  AND    inventory_item_id = X_Item_ID;

Line: 397

  stmt := 'SELECT 1 FROM ' || X_Table_Name ||
          ' WHERE ' || X_Column_Name || ' = :column_value';

Line: 446

SELECT nvl(description,'')
FROM hr_locations_all
WHERE location_id=id;

Line: 451

SELECT substr(address1,1,240)
FROM hz_locations
WHERE location_id=id;

Line: 456

SELECT description
FROM hr_locations
WHERE location_id=id;

Line: 499

  SELECT NAME , DESCRIPTION , START_DATE_ACTIVE , END_DATE_ACTIVE
  INTO v_chr1 , v_chr2 , v_date1 , v_date2
  FROM AP_TERMS
  WHERE TERM_ID = to_number(p_term_value_pk1);

Line: 506

  SELECT DESCRIPTION , DESCRIPTION , TO_DATE(NULL) , DISABLE_DATE
  into v_chr1 , v_chr2 , v_date1 , v_date2
  FROM ORG_FREIGHT
  WHERE ORGANIZATION_ID = to_number(p_term_value_pk1)
  AND   FREIGHT_CODE = p_term_value_pk2;

Line: 514

  SELECT NAME , DESCRIPTION , START_DATE_ACTIVE , END_DATE_ACTIVE
  INTO v_chr1 , v_chr2 , v_date1 , v_date2
  FROM RA_TERMS
  WHERE TERM_ID = to_number(p_term_value_pk1);

Line: 521

  SELECT LU.MEANING , LU.DESCRIPTION , LU.START_DATE_ACTIVE , LU.END_DATE_ACTIVE
  INTO v_chr1 , v_chr2 , v_date1 , v_date2
  FROM FND_LOOKUP_VALUES_VL LU
  ,    OKE_TERMS_B T
  WHERE T.TERM_CODE = p_term_code
  AND   LU.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
  AND   LU.LOOKUP_TYPE = T.LOOKUP_TYPE
  AND   LU.LOOKUP_CODE = p_term_value_pk1;

Line: 554

        select term_value_pk1
              from oke_k_terms
              where k_header_id = p_id
              and term_code = p_term_code
              and rownum=1;

Line: 625

  SELECT FND_CURRENCY_CACHE.Get_Format_Mask
         ( Currency_Code , C_Field_Length )
  FROM   okc_k_headers_b
  WHERE  id = C_K_Header_ID;

Line: 752

     select ppa.start_date
           ,ppa.completion_date
       into d_proj_start_date
           ,d_proj_end_date
       from pa_projects_all                ppa
      where ppa.project_id                =p_project_id
           ;

Line: 791

	select text
	from okc_k_articles_v where id = P_id;

Line: 820

  SELECT r.name
  FROM wf_roles r
  WHERE r.orig_system ='PER'
  AND   r.orig_system_id = person_id;

Line: 827

  SELECT Resource_source_id
  FROM PA_Project_Parties
  WHERE Resource_type_id = 101          -- employees only
  AND   Object_type = 'OKE_K_HEADERS'   -- header assignments only
  AND   Object_id   = P_header_id       -- for the requested header id only
  AND   Project_role_id = P_role_id     -- for the requested role
  AND   Trunc(SYSDATE) >= Trunc(Start_Date_Active)
  AND   (End_Date_Active IS NULL  OR  Trunc(SYSDATE) <= Trunc(End_Date_Active));

Line: 837

  SELECT Resource_source_id
  FROM PA_Project_Parties pr, OKE_K_Headers
  WHERE Resource_type_id = 101         -- employees only
  AND   Object_type = 'OKE_PROGRAMS'   -- program  assignments only
  AND   Object_id   = program_id       -- for the program id
  AND   K_Header_id = P_header_id      -- related to the requested header id
  AND   Project_role_id = P_role_id    -- for the requested role
  AND   Trunc(SYSDATE) >= Trunc(Start_Date_Active)
  AND   (End_Date_Active IS NULL  OR  Trunc(SYSDATE) <= Trunc(End_Date_Active))
  and not exists ( -- Same Person shouldnot exist at contract level in any other role
  SELECT 'x'
  FROM PA_Project_Parties pr1
  WHERE Resource_type_id = 101
  AND   Object_type = 'OKE_K_HEADERS'
  AND   Object_id   = P_header_id
  AnD   pr.resource_id = pr1.resource_id
  AND   Trunc(SYSDATE) >= Trunc(Start_Date_Active)
  AND   (End_Date_Active IS NULL  OR  Trunc(SYSDATE) <= Trunc(End_Date_Active)))
  order by pr.creation_date;

Line: 859

  SELECT Resource_source_id
  FROM PA_Project_Parties pr
  WHERE Resource_type_id = 101         -- employees only
  AND   Object_type = 'OKE_PROGRAMS'   -- site assignments only
  AND   Object_id   = 0                -- for the program id is 0 for site
  AND   Project_role_id = P_role_id    -- for the requested role
  AND   Trunc(SYSDATE) >= Trunc(Start_Date_Active)
  AND   (End_Date_Active IS NULL  OR  Trunc(SYSDATE) <= Trunc(End_Date_Active))
  and not exists ( -- Same Person shouldnot exist at contract level in any other role
  SELECT 'x'
  FROM PA_Project_Parties pr1
  WHERE Resource_type_id = 101
  AND   Object_type = 'OKE_K_HEADERS'
  AND   Object_id   = P_header_id
  AnD   pr.resource_id = pr1.resource_id
  AND   Trunc(SYSDATE) >= Trunc(Start_Date_Active)
  AND   (End_Date_Active IS NULL  OR  Trunc(SYSDATE) <= Trunc(End_Date_Active)))
  and not exists ( -- Same Person shouldnot exist at program level in any other role
  SELECT 'x'
  FROM PA_Project_Parties pr2, OKE_K_Headers
  WHERE Resource_type_id = 101
  AND   Object_type = 'OKE_PROGRAMS'
  AND   Object_id   = program_id
  AND   K_Header_id = P_header_id
  AND   pr.resource_id = pr2.resource_id
  AND   Trunc(SYSDATE) >= Trunc(Start_Date_Active)
  AND   (End_Date_Active IS NULL  OR  Trunc(SYSDATE) <= Trunc(End_Date_Active)))
  order by pr.creation_date;