APPS.PJI_COMPLETION_GRAPH SQL Statements

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

Line: 64

		SELECT 	name,
		ent_period_id period_id,
		start_date ,
		end_date
		FROM  	pji_time_ent_period_v
		where 	p_table_identifier = 'PJI_TIME_ENT_PERIOD_V'
	UNION ALL
		SELECT 	name,
		ent_qtr_id period_id,
		start_date,
		end_date
		FROM  	pji_time_ent_qtr_v
		where 	p_table_identifier = 'PJI_TIME_ENT_QTR_V'
	UNION ALL
		SELECT  name,
		ent_year_id period_id,
		start_date,
		end_date
		FROM 	pji_time_ent_year_v
		where 	p_table_identifier = 'PJI_TIME_ENT_YEAR_V'
	UNION ALL
		SELECT 	name,
		cal_period_id period_id,
		start_date,
		end_date
		FROM  	pji_time_cal_period_v
		where p_table_identifier = 'PJI_TIME_CAL_PERIOD_V'
		and CALENDAR_ID = p_calendar_id
	UNION ALL
		SELECT 	name,
		cal_qtr_id period_id,
		start_date,
		end_date
		FROM 	pji_time_cal_qtr_v
		where 	p_table_identifier = 'PJI_TIME_CAL_QTR_V'
		and CALENDAR_ID = p_calendar_id
	UNION ALL
		SELECT 	name,
		cal_year_id period_id,
		start_date,
		end_date
		FROM 	pji_time_cal_year_v
		where 	p_table_identifier = 'PJI_TIME_CAL_YEAR_V'
		and CALENDAR_ID = p_calendar_id;

Line: 118

   select bv.budget_version_id, Min(bl.start_date) start_date, Max(bl.end_date) end_date
   from pa_budget_versions bv, pa_budget_lines bl
   where project_id=p_project_id
   and fin_plan_type_id=l_plan_version_id
   AND bv.budget_version_id = bl.budget_version_id
   and budget_status_code='B'
   and (version_type = l_version_type OR version_type = 'ALL')
   GROUP BY bv.budget_version_id;

Line: 187

		   inserts a  record and then exist out of this loop*/
		    l_bud_cst_ver_index := l_bud_cst_ver_index + 1;

Line: 414

       delete from  pji_period_budget_ver_tmp;

Line: 416

	insert into pji_period_budget_ver_tmp(
				name,
				period_id,
				budget_version_id,
				start_date,
				end_date,
				cst_rev_flag,
				bud_for_act_flag)
			values	(p_ins_name(j),
				 p_ins_period_id(j),
      				 p_ins_version_id(j),
				 p_ins_start_date(j),
				 p_ins_end_date(j),
			      	 p_ins_cst_rev_flag(j),
			      	 p_ins_budget_forecast_flag(j));