The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ent_period_id period_id , end_date
FROM pji_time_ent_period_v
WHERE end_date >= TO_DATE(p_start_date,'j')
AND start_date <= TO_DATE(p_end_date,'j')
AND 'PJI_TIME_ENT_PERIOD_V'=p_slice_name
UNION ALL
SELECT ent_qtr_id period_id , end_date
FROM pji_time_ent_qtr_v
WHERE end_date >= TO_DATE(p_start_date,'j')
AND start_date <= TO_DATE(p_end_date,'j')
AND 'PJI_TIME_ENT_QTR_V'=p_slice_name
UNION ALL
SELECT ent_year_id period_id , end_date
FROM pji_time_ent_year_v
WHERE end_date >= TO_DATE(p_start_date,'j')
AND start_date <= TO_DATE(p_end_date,'j')
AND 'PJI_TIME_ENT_YEAR_V'=p_slice_name
ORDER BY period_id;
SELECT cal_period_id period_id , end_date
FROM pji_time_cal_period_v
WHERE end_date >= TO_DATE(p_start_date,'j')
AND start_date <= TO_DATE(p_end_date,'j')
AND calendar_id=p_calendar_id
AND 'PJI_TIME_CAL_PERIOD_V'=p_slice_name
UNION ALL
SELECT cal_qtr_id period_id , end_date
FROM pji_time_cal_qtr_v
WHERE end_date >= TO_DATE(p_start_date,'j')
AND start_date <= TO_DATE(p_end_date,'j')
AND calendar_id=p_calendar_id
AND 'PJI_TIME_CAL_QTR_V'=p_slice_name
UNION ALL
SELECT cal_year_id period_id , end_date
FROM pji_time_cal_year_v
WHERE end_date >= TO_DATE(p_start_date,'j')
AND start_date <= TO_DATE(p_end_date,'j')
AND calendar_id=p_calendar_id
AND 'PJI_TIME_CAL_YEAR_V'=p_slice_name
ORDER BY period_id;
SELECT object_type
FROM pa_proj_elements
WHERE proj_element_id = p_proj_element_id
AND project_id = p_project_id ;
DELETE PJI_PRD_PER_COMPLETE_TMP;
INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES
(rec_ent_periods.period_id,l_completed_per);
INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES
(rec_gl_pa_periods.period_id,l_completed_per );