APPS.PA_PACRCBDT_XMLP_PKG SQL Statements

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

Line: 7

    select SUM(decode(cp_capital_cost_type_flag,'R',
                                            amount,
                                            decode(cdl.line_type,'D',cdl.amount,
                                                                     cdl.burdened_cost)))
    into  l_total_cost
    from  pa_cost_distribution_lines_all cdl,
           pa_expenditure_items_all ei
   where  ei.expenditure_item_id = cdl.expenditure_item_id
     and  cdl.project_id = cf_total_costformula.p_project_id
     and  ei.capital_event_id = cf_total_costformula.capital_event_id
     and  (cdl.line_type =  decode(cp_line_type, 'D', 'D', 'R', 'R')  OR
           cdl.line_type = decode(cp_line_type, 'D', 'D', 'R', 'I')
          );

Line: 27

CURSOR C_project_setup IS (SELECT PPT.capital_cost_type_code ,PPT.total_burden_flag,PPT.burden_amt_display_method
	 			 FROM PA_PROJECT_TYPES PPT,
           			      PA_PROJECTS_ALL PP
    				WHERE PP.project_type = PPT.project_type
	 			  AND PP.project_id=cf_project_setupformula.project_id);

Line: 57

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl,pa_implementations pi
  WHERE   gl.set_of_books_id = pi.set_of_books_id;

Line: 85

    select segment1
    into p_project_number
    from pa_projects_all
   where project_id=p_project_id;

Line: 96

    select name
    INTO p_org_name
    from pa_organizations_proj_all_bg_v
    where organization_id=p_org_id;

Line: 149

    select meaning
      into l_meaning
      from pa_lookups
     where lookup_type ='PROJECT_ASSET_TYPES'
       and lookup_code=project_asset_type;

Line: 164

   select meaning
     into l_meaning
     from pa_lookups
   where lookup_type ='CAPITAL_TYPE'
     and lookup_code=event_type;

Line: 179

  select  ORG.name
   INTO l_name
   from HR_ORGANIZATION_UNITS  ORG
   where  ORG.ORGANIZATION_ID = CARRYING_OUT_ORGANIZATION_ID;