APPS.PA_PAXMGPBS_XMLP_PKG SQL Statements

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

Line: 61

select meaning into enter_param from pa_lookups where
lookup_type = 'ENTER VALUE' and
lookup_code = 'ENTER_ORG_MGR';

Line: 68

    select substr(name,1,60) into org_name from hr_organization_units where
      organization_id = p_start_organization_id;

Line: 74

   select full_name into member_name from per_people_f where
    person_id = project_member
    and   sysdate between effective_start_date
	 and     nvl(effective_end_date,sysdate + 1)
and (Current_NPW_Flag='Y' OR Current_Employee_Flag='Y')
    and Decode(Current_NPW_Flag,'Y',NPW_Number,employee_number) IS NOT NULL ;

Line: 84

   select meaning into role_type
   from pa_project_role_types where
   project_role_type = PA_PAXMGPBS_XMLP_PKG.project_role_type;

Line: 91

   select segment1 into p_number
   from pa_projects where
   project = project_id;

Line: 98

   select name into p_name
   from pa_projects where
   project = project_id;

Line: 105

   select meaning into p_never_billed
   from fnd_lookups where
   never_billed = lookup_code
   and lookup_type = 'YES_NO';

Line: 113

   select meaning into p_billing_method
   from pa_lookups where
   billing_method = lookup_code
   and lookup_type = 'BILLING_TYPE';

Line: 141

  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: 161

    select
       decode(p_start_organization_id,null,
     start_organization_id,p_start_organization_id)
    into
     c_start_organization_id
    from
     pa_implementations;

Line: 170

    select null
    into c_start_organization_id
    from sys.dual;

Line: 174

   insert into
    pa_org_reporting_sessions
    (start_organization_id,session_id)
   values
    (c_start_organization_id,userenv('SESSIONID'));

Line: 217

  select meaning
    into l_meaning
    from pa_lookups
   where lookup_type = 'YES_NO'
     and lookup_code = nvl(enable_top_task_inv_mth_flag, 'N');