APPS.PA_PROJ_TEMPLATE_SETUP_UTILS SQL Statements

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

Line: 25

   SELECT option_name, option_function_name,sort_order, FFF.web_html_call
     FROM PA_OPTIONS PO, FND_FORM_FUNCTIONS FFF
    WHERE option_code = p_option_code
       AND PO.OPTION_FUNCTION_NAME = FFF.FUNCTION_NAME(+);

Line: 47

     SELECT user_defined_project_num_code
       FROM pa_implementations;

Line: 72

    SELECT 'X'
      FROM pa_options
     WHERE parent_option_code = p_option_code;

Line: 103

     SELECT roles.meaning
       FROM pa_project_role_types_vl roles
      WHERE trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
        AND roles.project_role_type = p_limiting_value;

Line: 110

     SELECT meaning
       FROM pa_lookups
      WHERE lookup_type = 'CUSTOMER PROJECT RELATIONSHIP'
        AND enabled_flag = 'Y'
        AND trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
        AND lookup_code = p_limiting_value;

Line: 284

      SELECT def_start_proj_Status_code
             ,service_type_code
             ,cost_ind_rate_sch_id
             ,labor_sch_type
             ,labor_bill_rate_org_id
             ,labor_std_bill_rate_schdl
             ,non_labor_sch_type
             ,non_labor_bill_rate_org_id
             ,non_labor_std_bill_rate_schdl
             ,rev_ind_rate_sch_id
             ,inv_ind_rate_sch_id
             ,labor_invoice_format_id
             ,non_labor_invoice_format_id
             ,Burden_cost_flag
             ,interface_asset_cost_code
             ,cost_sch_override_flag
             ,billing_offset
             ,billing_cycle_id
             ,cc_prvdr_flag
             ,bill_job_group_id
             ,cost_job_group_id
             ,work_type_id
             ,role_list_id
             ,unassigned_time
             ,emp_bill_rate_schedule_id
             ,job_bill_rate_schedule_id
             ,budgetary_override_flag
             ,baseline_funding_flag
             ,non_lab_std_bill_rt_sch_id
             ,project_type_class_code
-- anlee
-- patchset K changes
             ,revaluate_funding_flag
             ,include_gains_losses_flag
-- End of changes
--PA L Changes 2872708
            ,asset_allocation_method
            ,CAPITAL_EVENT_PROCESSING
            ,CINT_RATE_SCH_ID
--End PA L Changes 2872708
	    ,nvl(date_eff_funds_consumption,'N') --bug#5511353
            ,ar_rec_notify_flag     -- 7508661 : EnC
            ,auto_release_pwp_inv   -- 7508661 : EnC
        FROM pa_project_types
       WHERE project_type = p_project_type;

Line: 413

      SELECT lookup_code
        FROM pa_lookups
       WHERE meaning = p_field_name_meaning
         AND lookup_type = 'OVERRIDE FIELD';

Line: 460

     SELECT roles.project_role_type
       FROM pa_project_role_types_vl roles
      WHERE trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
        AND roles.meaning = p_specification;

Line: 467

     SELECT lookup_code
       FROM pa_lookups
      WHERE lookup_type = 'CUSTOMER PROJECT RELATIONSHIP'
        AND enabled_flag = 'Y'
        AND trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate)
        AND meaning = p_specification;

Line: 552

      select project_id
      from pa_projects
      where UPPER(name) = UPPER(p_template_name);

Line: 584

        SELECT project_id
        INTO   x_template_id
        FROM   pa_projects
        WHERE  project_id = p_template_id;

Line: 664

      select project_id
      from pa_projects_v      --cannot replace with project_all bcoz project name user enters must be validated with secuured view.
      where name = p_project_name; -- removed the UPPER function for perf. bug 2786121

Line: 699

        SELECT project_id
        INTO   x_project_id
        FROM   pa_projects_all               --replaced pa_projects_v with pa_projects_all for perf. bug 2786121
        WHERE  project_id = p_project_id;

Line: 861

  SELECT created_from_project_id
    FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 867

   SELECT 'Y'
     FROM PA_PROJECT_OPTIONS PPO
     WHERE option_code = p_option_code
     AND   project_id = c_project_id;

Line: 874

  SELECT 'Y'
  FROM PA_PROJECTS_ALL
  WHERE project_id = p_project_id
  AND template_flag = 'Y';

Line: 927

     SELECT Manual_Project_Num_Type
       FROM pa_implementations;