APPS.PA_BUDGET_CHECK_PVT SQL Statements

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

Line: 61

   SELECT period_start_date
          ,  period_end_date
          ,  PERIOD_YEAR        /* bug 4588279: added PERIOD_YEAR */
   FROM   pa_budget_periods_v
   WHERE  period_name = p_period_name
   AND    period_type_code = p_period_type_code;

Line: 73

   SELECT period_name
          ,  PERIOD_YEAR        /* bug 4588279: added PERIOD_YEAR */
   FROM   pa_budget_periods_v
   WHERE  period_type_code = p_period_type_code
   AND    period_start_date = p_start_date
   AND    period_end_date = p_end_date;

Line: 84

   SELECT trunc(start_date)  --Added trunc for Bug 3899746
   ,      trunc(completion_date)  --Added trunc for Bug 3899746
   FROM   pa_projects
   WHERE  project_id = p_project_id;

Line: 92

   SELECT trunc(start_date)  --Added trunc for Bug 3899746
   ,      trunc(completion_date)  --Added trunc for Bug 3899746
   FROM   pa_tasks
   WHERE  task_id = p_task_id;

Line: 115

   SELECT   segment1
   FROM     pa_projects p
   WHERE p.project_id = p_pa_project_id;

Line: 122

   SELECT   task_number
   FROM     pa_tasks p
   WHERE p.task_id = p_pa_task_id;

Line: 732

                                    SELECT  pev.element_version_id
                                    INTO    l_elem_ver_id
                                    FROM    pa_proj_element_versions pev
                                    WHERE   pev.proj_element_id = p_task_id
                                    AND     pev.parent_structure_version_id = l_parent_structure_version_id;

Line: 802

                                     SELECT 'Y'
                                     INTO   valid_gl_start_date
                                     FROM   dual
                                     WHERE EXISTS (SELECT 'X'
                                                   FROM   pa_budget_periods_v
                                                   WHERE  period_type_code = 'G'
                                                   AND    period_start_date = l_budget_start_date_in);

Line: 815

                                     SELECT 'Y'
                                     INTO   valid_gl_end_date
                                     FROM   dual
                                     WHERE EXISTS (SELECT 'X'
                                                   FROM   pa_budget_periods_v
                                                   WHERE  period_type_code = 'G'
                                                   AND    period_end_date = l_budget_end_date_in);

Line: 847

                                     SELECT 'Y'
                                     INTO   valid_pa_start_date
                                     FROM   dual
                                     WHERE EXISTS (SELECT 'X'
                                                   FROM   pa_budget_periods_v
                                                   WHERE  period_type_code = 'P'
                                                   AND    period_start_date = l_budget_start_date_in);

Line: 860

                                     SELECT 'Y'
                                     INTO   valid_pa_end_date
                                     FROM   dual
                                     WHERE EXISTS (SELECT 'X'
                                                   FROM   pa_budget_periods_v
                                                   WHERE  period_type_code = 'P'
                                                   AND    period_end_date = l_budget_end_date_in);

Line: 1050

      SELECT cost_quantity_flag
      ,      raw_cost_flag
      ,      burdened_cost_flag
      ,      rev_quantity_flag
      ,      revenue_flag
      FROM   pa_budget_entry_methods
      WHERE  budget_entry_method_code = p_budget_entry_method_code
      AND    trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));

Line: 1849

               SELECT unit_of_measure
               INTO   l_unit_of_measure
               FROM   pa_resource_list_members
               WHERE  resource_list_member_id = p_res_list_mem_id;

Line: 1856

                        pa_debug.g_err_stage := 'No values obtained from the select';