APPS.PA_TASK_TYPE_UTILS SQL Statements

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

Line: 10

  SELECT 'X'
  FROM pa_task_types
  WHERE task_type = p_task_type
  AND object_type = 'PA_TASKS'  /* bug 3279978 FP M Enhancement */
  AND ((task_type_id <> p_task_type_id AND p_task_type_id IS NOT NULL)
       OR p_task_type_id IS NULL);

Line: 47

    SELECT prog_entry_enable_flag, wq_enable_flag, percent_comp_enable_flag, remain_effort_enable_flag
    FROM pa_task_types
    WHERE task_type_id = p_task_type_id;

Line: 52

    SELECT prog_entry_enable_flag, wq_enable_flag, percent_comp_enable_flag, remain_effort_enable_flag
    FROM pa_task_types
    WHERE task_type_id = p_task_type_id;

Line: 61

    select a.project_id, a.proj_element_id
      from pa_proj_element_versions a,
           pa_proj_element_versions b
     where b.proj_element_id = p_task_id
       and b.parent_structure_version_id = a.element_version_id
       and b.project_id = a.project_id;

Line: 273

  Select 'X' from pa_task_types
  where task_progress_entry_page_id = p_page_id
  AND object_type = 'PA_TASKS';  /* bug 3279978 FP M Enhancement */

Line: 534

    select 'Y'
      from pa_task_types
     where task_type_id = p_task_type_id
       and sysdate > start_date_active
       and (end_date_active IS NULL or end_date_active > sysdate);

Line: 554

    select 'Y'
      from pa_task_types
     where task_type_id = p_task_type_id
       and PROG_ENTRY_ENABLE_FLAG = 'Y';

Line: 575

    select 'Y'
      from pa_task_types
     where task_type_id = p_task_type_id
       and WQ_ENABLE_FLAG = 'Y';