APPS.HR_BUDGET_CALENDAR SQL Statements

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

Line: 65

     select tpe.end_date - tpe.start_date + 1
     into   v_midpoint_offset
     from   per_time_periods tpe
     where  tpe.period_set_name = p_period_set_name
       and  tpe.start_date = p_start_date;

Line: 102

     select cal.period_set_name
     from   pay_calendars cal
     where  cal.period_set_name = p_period_set_name
     for    update;

Line: 118

     select count(*)
     into   v_yr_count
     from   per_time_period_sets tps
     where  tps.period_set_name = p_period_set_name;

Line: 156

   insert into per_time_periods
   (time_period_id,
    period_set_name,
    period_name,
    period_type,
    year_number,
    period_year,
    quarter_num,
    period_num,
    start_date,
    end_date,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date)
   select
    per_time_periods_s.nextval,
    p_period_set_name,
    to_char(p_prd_num) || ' ' || to_char(p_prd_end_date, 'YYYY') || ' ' ||
      p_prd_type,
    p_prd_type,
    fnd_number.canonical_to_number(to_char(p_prd_end_date, 'YYYY')),
    p_yr_num,
    p_qtr_num,
    p_prd_num,
    p_prd_start_date,
    p_prd_end_date,
    trunc(sysdate),
    0,
    0,
    0,
    trunc(sysdate)
   from  sys.dual;

Line: 287

     select cal.start_date,
	    cal.actual_period_type,
            cal.proc_period_type,
	    tpt.number_per_fiscal_year
     into   v_cal_details.start_date,
	    v_cal_details.actual_period_type,
	    v_cal_details.proc_period_type,
	    v_cal_details.number_per_fiscal_year
     from   pay_calendars cal,
	    per_time_period_types tpt
     where  cal.period_set_name = p_period_set_name
       and  tpt.period_type = cal.actual_period_type;

Line: 339

     select max(tpe.end_date) + 1
     into   v_cal_details.start_date
     from   per_time_periods tpe
     where  tpe.period_set_name = v_cal_details.period_set_name;

Line: 423

     insert into per_time_period_sets
     (start_date,
      period_set_name,
      period_type,
      end_date_q1,
      end_date_q2,
      end_date_q3,
      end_date_q4,
      month_mid_day,
      year_number)
     values
     (v_yr_start_date,
      v_cal_details.period_set_name,
      v_cal_details.actual_period_type,
      v_1st_qtr_end_date,
      v_2nd_qtr_end_date,
      v_3rd_qtr_end_date,
      v_4th_qtr_end_date,
      v_cal_details.midpoint_offset,
      v_yr_num);

Line: 527

     select tpe.time_period_id
     from   per_time_periods tpe
     where  tpe.period_set_name = p_period_set_name
       and  tpe.period_year     > p_number_of_years
       and  exists
	    (select null
	     from   per_budget_values bv
	     where  bv.time_period_id = tpe.time_period_id);

Line: 560

     delete from per_time_periods tpe
     where  tpe.period_set_name = p_period_set_name
       and  tpe.period_year     > p_number_of_years;

Line: 565

     delete from per_time_period_sets tps
     where  tps.period_set_name = p_period_set_name
       and  tps.year_number > p_number_of_years;