APPS.PA_GET_RESOURCE SQL Statements

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

Line: 17

   SELECT
   group_resource_type_id
   FROM
   pa_resource_lists
   WHERE resource_list_id = p_resource_list_id;

Line: 24

   SELECT
   resource_type_code
   FROM
   pa_resource_types
   WHERE resource_type_id = l_resource_type_id;

Line: 31

   SELECT
   resource_list_member_id,
   track_as_labor_flag
   FROM
   pa_resource_list_members
   WHERE resource_list_id = p_resource_list_id
   AND   parent_member_id IS NULL
   AND   resource_id      = l_resource_id;

Line: 41

   SELECT
   revenue_category_m
   FROM
   pa_revenue_categories_v
   WHERE
   revenue_category_code = p_resource_group;

Line: 49

   SELECT
   organization_name
   FROM
   pa_organizations_res_v
   WHERE
   organization_id = l_org_id ;

Line: 68

       p_err_stage := ' Select group_resource_type_id from pa_resource_lists';

Line: 93

       p_err_stage := 'Select resource_type_code from pa_resource_types ';

Line: 114

              ' Select revenue_category_m from pa_revenue_categories_v';

Line: 130

              ' Select organization_name from pa_organizations_res_v';

Line: 186

      'Select resource_list_member_id from pa_resource_list_members';

Line: 262

   SELECT
   resource_list_member_id,
   track_as_labor_flag
   FROM
   pa_resource_list_members
   WHERE resource_list_id = p_resource_list_id
   AND   parent_member_id IS NULL
   AND   resource_id      = l_resource_id;

Line: 272

   SELECT
   resource_list_member_id,
   track_as_labor_flag
   FROM
   pa_resource_list_members
   WHERE resource_list_id = p_resource_list_id
   AND   parent_member_id = p_parent_member_id
   AND   resource_id      = l_resource_id;

Line: 337

      'Select resource_list_member_id from pa_resource_list_members';

Line: 429

   SELECT
   resource_type_id
   FROM
   pa_resource_types
   WHERE resource_type_code = p_resource_type_code;

Line: 442

SELECT               a.resource_id
FROM		 pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.person_id = p_person_id;

Line: 450

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.job_id = p_job_id ;

Line: 458

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.organization_id  = p_proj_organization_id;

Line: 466

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.vendor_id = p_vendor_id;

Line: 475

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.expenditure_type  = p_expenditure_type;

Line: 483

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.event_type = p_event_type;

Line: 492

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND 		b.expenditure_category = p_expenditure_category;

Line: 502

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND 		b.revenue_category = p_revenue_category_code;

Line: 511

SELECT               a.resource_id
FROM		pa_resources a, pa_resource_txn_attributes b
WHERE               a.resource_type_id = l_resource_type_id
AND                     a.resource_id  = b.resource_id
AND		b.project_role_id = p_project_role_id ;

Line: 579

       p_err_stage := 'Select resource_type_id from pa_resource_types ';

Line: 599

p_err_stage := 'Select resource_id from pa_resource_txn_attributes ';

Line: 718

         l_statement := 'Select unit_of_measure,rollup_quantity_flag ,'||
                        ' track_as_labor_flag  from  ';

Line: 790

       p_err_stage := 'Select unit_of_measure...from ... ';

Line: 872

   SELECT
   rl.resource_list_id,
   rlm.resource_list_member_id,
   rlm.resource_id,
   rlm.track_as_labor_flag
   FROM
   pa_resource_lists rl,
   pa_resource_list_members rlm
   WHERE rl.uncategorized_flag = 'Y'
   AND rlm.resource_class_code = 'FINANCIAL_ELEMENTS' -- shelly
   AND rlm.resource_class_flag = 'Y' --shelly
   AND rl.resource_list_id = rlm.resource_list_id
   AND rl.business_group_id = pa_utils.business_group_id; /* Added for Bug 2373165 */

Line: 937

     SELECT
     resource_list_member_id,
     track_as_labor_flag
     FROM
     pa_resource_list_members
     WHERE  resource_list_id = p_resource_list_id
     AND parent_member_id IS NULL
     AND resource_id = p_unclassified_resource_id;

Line: 947

     SELECT
     resource_list_member_id,
     track_as_labor_flag
     FROM
     pa_resource_list_members
     WHERE  resource_list_id = p_resource_list_id
     AND parent_member_id = p_parent_member_id
     AND resource_id = p_unclassified_resource_id;

Line: 1021

   SELECT par.resource_id,
          par.name,
          par.track_as_labor_flag,
          par.unit_of_measure,
          par.rollup_quantity_flag
   FROM   pa_resources par,
          pa_resource_types part
   WHERE  part.resource_type_code = 'UNCLASSIFIED'
   AND    part.resource_type_id   = par.resource_type_id;

Line: 1103

    select 1
    into   temp
    from  sys.dual where
  exists ( select 1 from pa_resource_list_members p,pa_project_accum_headers h
    where p.resource_list_member_id = h.resource_list_member_id
      and p.parent_member_id = p_resource_id
      and h.project_id  = p_project_id
      and h.task_id  = p_task_id );

Line: 1120

Procedure delete_resource_list_ok(l_resource_list_id NUMBER,
                                  p_is_plan_res_list  IN VARCHAR2 default 'N',
                                  x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
                                  x_err_stage IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

l_dummy        VARCHAR2(1);

Line: 1130

SELECT   'x'
FROM     dual
WHERE    exists
      (select 'x'
      from pa_resource_list_members rlm
         , pa_resources r
         , pa_resource_types rt
                 where
      rlm.resource_list_id = l_resource_list_id
      and rlm.resource_id = r.resource_id
      and r.resource_type_id = rt.resource_type_id
      and rt.resource_type_code <> 'UNCLASSIFIED');

Line: 1147

SELECT   'x'
FROM     dual
WHERE    exists
      (select 'x'
        from pa_resource_list_assignments rla
         where    rla.resource_list_id = l_resource_list_id);

Line: 1159

Select 'X'
From dual
Where exists
(Select null
 From pa_project_types_all pa
 Where pa.DEFAULT_RESOURCE_LIST_ID     = l_resource_list_id
 Or    pa.COST_BUDGET_RESOURCE_LIST_ID = l_resource_list_id
 Or    pa.REV_BUDGET_RESOURCE_LIST_ID  = l_resource_list_id);

Line: 1173

Select 'X'
From dual
Where exists
(Select null
 From pa_budget_versions
 Where resource_list_id = l_resource_list_id);

Line: 1184

Select 'X'
From   pa_proj_fp_options
Where  all_resource_list_id = l_resource_list_id
      OR cost_resource_list_id = l_resource_list_id
      OR revenue_resource_list_id = l_resource_list_id;

Line: 1272

END delete_resource_list_ok;

Line: 1274

Procedure delete_resource_list_member_ok(l_resource_list_id NUMBER,l_resource_list_member_id NUMBER,x_err_code IN OUT NOCOPY NUMBER,x_err_stage IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

l_dummy        VARCHAR2(1);

Line: 1283

SELECT   'x'
FROM     dual
WHERE    exists
      (select 'x'
        from  pa_resource_list_assignments rla, pa_project_accum_headers pah
        where  rla.resource_list_id = l_resource_list_id
        and    rla.project_id = pah.project_id
        and rla.resource_list_id = pah.resource_list_id
        and pah.resource_list_member_id = l_resource_list_member_id);

Line: 1299

SELECT   'x'
FROM     dual
WHERE    exists
      (select 'x'
        from  pa_resource_list_assignments rla
         , pa_budget_versions bv
         , pa_resource_assignments ra
        where  rla.resource_list_id = l_resource_list_id
        and    rla.project_id = bv.project_id
        and rla.resource_list_id = bv.resource_list_id
        and    bv.budget_version_id = ra.budget_version_id
        and bv.project_id  = ra.project_id
        and ra.resource_list_member_id = l_resource_list_member_id);*/

Line: 1312

SELECT   'x'
FROM     dual
WHERE    exists
      (select 'x'
        from pa_resource_assignments ra
        where ra.resource_list_member_id = l_resource_list_member_id);

Line: 1393

END delete_resource_list_member_ok;