APPS.PJI_COMPLETION_GRAPH SQL Statements

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

Line: 56

		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: 109

                   select budget_version_id, baselined_date from pa_budget_versions
                   where project_id=p_project_id
                   and fin_plan_type_id=l_plan_version_id
                   and budget_status_code='B'
                   order by baselined_date desc;

Line: 171

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

Line: 394

       delete from  pji_period_budget_ver_tmp;

Line: 396

	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));