APPS.PJI_EV_UTIL SQL Statements

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

Line: 24

	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;

Line: 44

	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;

Line: 67

	SELECT object_type
	FROM pa_proj_elements
	WHERE proj_element_id =  p_proj_element_id
	AND project_id =  p_project_id ;

Line: 80

	DELETE PJI_PRD_PER_COMPLETE_TMP;

Line: 100

				INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES
				(rec_ent_periods.period_id,l_completed_per);

Line: 124

				INSERT INTO PJI_PRD_PER_COMPLETE_TMP (period_id,completed_percentage) VALUES
				(rec_gl_pa_periods.period_id,l_completed_per );