The following lines contain the word 'select', 'insert', 'update' or 'delete':
select project_id from pa_projects_all
where project_id = X_project_id;
select project_id from pjm_seiban_numbers
where project_id = X_project_id;
select project_id into L_proj_id
from pa_projects_all_expend_v
where project_id = X_project_id
and expenditure_org_id = X_org_id;
select TO_NUMBER(org_information3)
from hr_organization_information
where ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
and organization_id = X_inv_org;
select segment1
from pa_projects_all
where project_id = X_project_id
union
select project_number
from pjm_seiban_numbers
where project_id = X_project_id;
select name
from pa_projects_all
where project_id = X_project_id
union
select project_name
from pjm_seiban_numbers
where project_id = X_project_id;
select project_number
from PJM_PROJECTS_ORG_OU_SECURE_V /*Bug 6684081: Changed the view that should be used for MOAC. This API is called by OM team.*/
where project_id = X_project_id;
select 1
from pjm_project_parameters
where project_id = X_project_id
and organization_id = X_organization_id;
select project_number
from PJM_PROJECTS_V
where project_id = X_project_id;
select project_name
from pjm_projects_v
where project_id = X_project_id;
select 1
from pjm_project_parameters
where project_id = X_project_id
and organization_id = X_organization_id;
select project_id
from pjm_projects_v
where project_number = X_project_num;
select 1
from pjm_project_parameters
where project_id = L_project_id
and organization_id = X_organization_id;
select project_id
from pjm_projects_v
where project_name = X_project_name;
select 1
from pjm_project_parameters
where project_id = L_project_id
and organization_id = X_organization_id;
select task_number
from pa_tasks
where task_id = X_task_id;
select task_name
from pa_tasks
where task_id = X_task_id;
select task_number
from pjm_tasks_v
where project_id = X_project_id
and task_id = X_task_id;
select task_name
from pjm_tasks_v
where project_id = X_project_id
and task_id = X_task_id;
select task_id
from pjm_tasks_v
where project_id = L_project_id
and task_number = X_task_num;
select task_id
from pjm_tasks_v
where project_id = L_project_id
and task_name = X_task_name;
select mp.organization_code
, decode(pop.organization_id ,
null , 'GEN-ORG NOT PJM ENABLED' ,
decode(pop.project_reference_enabled ,
'N' , 'GEN-ORG NOT PRJ REF ENABLED' ,
null))
, decode(pop.project_control_level, 1, 'PROJECT', 2, 'TASK')
from pjm_org_parameters pop
, mtl_parameters mp
where mp.organization_id = X_inventory_org_id
and pop.organization_id (+) = mp.organization_id;
select p.segment1
, decode(pp.project_id ,
null , 'GEN-INVALID PROJ FOR ORG',
decode(PJM_PROJECT.Is_Exp_Proj(p.project_id,L_operating_unit),
'Y', null,
decode(p.org_id,
L_operating_unit, 'GEN-INVALID PROJ' ,
'GEN-INVALID PROJ FOR OU')))
, trunc(p.start_date)
, trunc(p.completion_date)
, trunc(pp.start_date_active)
, trunc(pp.end_date_active)
from pa_projects_all p
, pjm_project_parameters pp
where p.project_id = X_project_id
and pp.project_id (+) = p.project_id
and pp.organization_id (+) = X_inventory_org_id;
select sn.project_number
, decode(pp.project_id ,
null , 'GEN-INVALID PROJ FOR ORG' , null)
, to_date(null)
, to_date(null)
, trunc(pp.start_date_active)
, trunc(pp.end_date_active)
from pjm_seiban_numbers sn
, pjm_project_parameters pp
where sn.project_id = X_project_id
and pp.organization_id (+) = X_inventory_org_id
and pp.project_id (+) = sn.project_id;
select te.task_number
, decode(te.chargeable_flag ,
'N' , 'GEN-TASK NOT CHARGEABLE' , null)
, trunc(te.start_date)
, trunc(te.completion_date)
from pa_tasks_all_expend_v te
where te.task_id = X_task_id
and te.project_id = X_project_id
and te.expenditure_org_id = L_operating_unit;
select t.task_number
, 'GEN-INVALID TASK'
, trunc(t.start_date)
, trunc(t.completion_date)
from pa_tasks t
where t.task_id = X_task_id
and t.project_id = X_project_id;