The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ORGANIZATION_STRUCTURE_ID,
ORG_STRUCTURE_VERSION_ID,
DFLT_PRJPIP_PERIOD_TYPE,
DFLT_PRJPIP_CYCLE_ID,
DFLT_PRJBAB_PERIOD_TYPE,
DFLT_PRJBAB_CYCLE_ID,
DFLT_RESUTL_PERIOD_TYPE,
DFLT_RESUTL_CYCLE_ID,
DFLT_RESAVL_PERIOD_TYPE,
DFLT_RESAVL_CYCLE_ID,
DFLT_RESPLN_PERIOD_TYPE,
DFLT_RESPLN_CYCLE_ID,
DFLT_PRJHLT_PERIOD_TYPE,
DFLT_PRJHLT_CYCLE_ID,
DFLT_PRJACT_PERIOD_TYPE,
DFLT_PRJACT_CYCLE_ID,
DFLT_PRJPRF_PERIOD_TYPE,
DFLT_PRJPRF_CYCLE_ID,
DFLT_PRJCST_PERIOD_TYPE,
DFLT_PRJCST_CYCLE_ID
INTO InitialValues
FROM PJI_SYSTEM_SETTINGS;
select MONTH_ID,
ENT_PERIOD_ID,
ENT_QTR_ID,
ENT_YEAR_ID,
WEEK_ID
into G_Month_ID_Value,
G_Ent_Period_ID_Value,
G_Ent_Quarter_ID_Value,
G_Ent_Year_ID_Value,
G_Week_ID_Value
from fii_time_day
where report_date = trunc(sysdate);
l_insert_top_org_flag VARCHAR2(1);
x_insert_top_org_flag => l_insert_top_org_flag);
SELECT DISTINCT first_value(ID) over (ORDER BY lvl) into G_Org_ID
FROM
(
SELECT organization_level Lvl
, organization_id id
FROM
hri_org_hrchy_summary org_roll
WHERE org_roll.org_structure_version_id = G_Org_Version_Id
AND organization_level - sub_organization_level =0
);
SELECT DISTINCT first_value(ID) over (ORDER BY lvl) into G_Org_ID
FROM
(
SELECT org_roll.sup_org_absolute_level Lvl
, org_list.id id
, org_list.value value
FROM
hri_cs_orghro_v org_roll
, pji_organizations_v org_list
WHERE
org_roll.org_hierarchy_version_id = G_Org_Version_Id
AND org_roll.sup_organization_id = org_list.id
AND org_roll.sup_org_absolute_level - org_roll.sub_org_absolute_level = 0
AND org_roll.subro_sup_org_relative_level = 0
AND org_roll.subro_sub_org_relative_level = 0
);
SELECT prjpip.ID into G_Period_Type_ID
-- ,prjbab.value
FROM
pji_system_settings syssetting
, pji_period_types_v prjpip
, pji_period_types_v prjbab
WHERE
prjbab.global_disp_flag = 0
AND prjpip.global_disp_flag = 0
AND prjpip.ID='FII_TIME_'||DECODE(G_Period_Type_Code,
'YEAR','ENT_YEAR',
'QUARTER','ENT_QTR',
'MONTH','ENT_PERIOD',
'WEEK','WEEK')
AND prjbab.ID='FII_TIME_'||DECODE(G_Period_Type_Code,
'YEAR','ENT_YEAR',
'QUARTER','ENT_QTR',
'MONTH','ENT_PERIOD',
'WEEK','WEEK');
SELECT LOOKUP_CODE into G_EntPeriod_ID
FROM
pji_lookups
WHERE LOOKUP_TYPE='PJI_PERIOD_TYPE_LIST'
AND LOOKUP_CODE='FII_TIME_ENT_PERIOD';
SELECT LOOKUP_CODE into G_EntWeek_ID
FROM
pji_lookups
WHERE LOOKUP_TYPE='PJI_PERIOD_TYPE_LIST'
AND LOOKUP_CODE='FII_TIME_WEEK';
select DECODE(G_Period_Type_Code,'WEEK', WEEK_ID
,'MONTH', MONTH_ID
,'PERIOD',ENT_PERIOD_ID
,'QUARTER',ENT_QTR_ID
,'YEAR',ENT_YEAR_ID)
into G_Period_Id_Value from
fii_time_day
where report_date = trunc(sysdate);
select TO_CHAR(seq) into G_Avail_Threshold
from pji_mt_buckets where bucket_set_code ='PJI_RESOURCE_AVAILABILITY'
and default_flag='Y';