The following lines contain the word 'select', 'insert', 'update' or 'delete':
select tl.name
into G_Organization_Name
from hr_org_units_no_join o,
hr_all_organization_units_tl tl
where
o.organization_id(+) = P_Organization_Id
and o.organization_id = tl.organization_id(+)
and ( ( tl.organization_id is null and
1 = 1)
or ( tl.organization_id is not null and
tl.language = userenv('LANG'))) ;
select tl.name
into G_Organization_Name
from hr_org_units_no_join o,
hr_all_organization_units_tl tl
where
o.organization_id(+) = P_Organization_Id
and o.organization_id = tl.organization_id(+)
and ( ( tl.organization_id is null and
1 = 1)
or ( tl.organization_id is not null and
tl.language = userenv('LANG'))) ;
select tl.name
into G_Organization_Name_1
from hr_org_units_no_join o,
hr_all_organization_units_tl tl
where
o.organization_id(+) = P_Organization_Id
and o.organization_id = tl.organization_id(+)
and ( ( tl.organization_id is null and
1 = 1)
or ( tl.organization_id is not null and
tl.language = userenv('LANG'))) ;
select name
into G_Organization_Name_US
from hr_org_units_no_join
where organization_id = P_Organization_Id;
SELECT
TL.NAME
INTO
X_ORG_NAME
FROM
HR_ORG_UNITS_NO_JOIN O,
HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE
O.ORGANIZATION_ID(+) = P_ORG_ID
AND
O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
AND
( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
OR
( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;
SELECT
TL.NAME
INTO
X_ORG_NAME
FROM
HR_ORG_UNITS_NO_JOIN O,
HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE
O.ORGANIZATION_ID(+) = P_ORG_ID
AND
O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
AND
( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
OR
( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;
SELECT
TL.NAME
INTO
X_ORG_NAME
FROM
HR_ORG_UNITS_NO_JOIN O,
HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE
O.ORGANIZATION_ID(+) = P_ORG_ID
AND
O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
AND
( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
OR
( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;
SELECT
TL.NAME
INTO
X_ORG_NAME
FROM
HR_ORG_UNITS_NO_JOIN O,
HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE
O.ORGANIZATION_ID(+) = P_ORG_ID
AND
O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
AND
( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
OR
( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;
SELECT
TL.NAME
INTO
X_ORG_NAME
FROM
HR_ORG_UNITS_NO_JOIN O,
HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE
O.ORGANIZATION_ID(+) = P_ORG_ID
AND
O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
AND
( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
OR
( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;
select name
into G_job_name
from per_jobs
where job_id = p_job_id;
SELECT function
INTO x_sys_link_func
FROM pa_system_linkages
WHERE function = p_sys_link_func;
SELECT function
INTO x_sys_link_func
FROM pa_system_linkages
WHERE meaning = p_exp_meaning;
select count(*)
into l_dummy
from pa_expenditure_types_expend_v
where p_ei_date between expnd_typ_start_date_active
and nvl(expnd_typ_end_date_active,p_ei_date)
and p_ei_date between SYS_LINK_START_DATE_ACTIVE
and nvl(sys_link_end_date_active,p_ei_date)
and system_linkage_function = p_sys_link_func
and expenditure_type = p_exp_type;
SELECT PA_DATE,
GL_DATE,
RECVR_PA_DATE,
RECVR_GL_DATE,
PA_PERIOD_NAME,
GL_PERIOD_NAME,
RECVR_PA_PERIOD_NAME,
RECVR_GL_PERIOD_NAME
INTO
G_PA_DATE,
G_GL_DATE,
G_RECVR_PA_DATE,
G_RECVR_GL_DATE,
G_PA_PERIOD_NAME,
G_GL_PERIOD_NAME,
G_RECVR_PA_PERIOD_NAME,
G_RECVR_GL_PERIOD_NAME
FROM PA_COST_DISTRIBUTION_LINES_ALL
WHERE EXPENDITURE_ITEM_ID = P_EXP_ITEM_ID
AND LINE_TYPE = 'R'
AND LINE_NUM_REVERSED IS NULL
AND REVERSED_FLAG IS NULL ;
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_Gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');
Select pa_date,
gl_date,
recvr_pa_date,
recvr_gl_date,
pa_period_name,
gl_period_name,
recvr_pa_period_name,
recvr_gl_period_name
Into
g_pa_date,
g_gl_date,
g_recvr_pa_date,
g_recvr_gl_date,
g_pa_period_name,
g_gl_period_name,
g_recvr_pa_period_name,
g_recvr_gl_period_name
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R'
And line_num = (
Select max(line_num)
From pa_cost_distribution_lines_all
Where expenditure_item_id = P_Exp_Item_Id
And line_type = 'R');