APPS.PSP_MATRIX_DRIVER2_PKG SQL Statements

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

Line: 53

  select sum(PERIOD_SCHEDULE_PERCENT)
	into total
	from psp_matrix_driver2
	where period = st_date;

Line: 63

 dat.DELETE;

Line: 69

    SELECT 	schedule_line_id l_id,
		schedule_begin_date sbd,
		schedule_end_date sed,
		schedule_percent sp
    FROM	psp_schedule_lines
    WHERE	schedule_hierarchy_id = s_id;

Line: 114

  	  insert into psp_matrix_driver2(SCHEDULE_LINE_ID,
				PERIOD,
				PERIOD_SCHEDULE_PERCENT) values
				(sch_rec.l_id,
				 dat(i),
				 per);