APPS.HR_BUDGET_CALENDAR dependencies on PER_TIME_PERIOD_SETS

Line 120: from per_time_period_sets tps

116: -- Count the number of existing periods for the calendar.
117: begin
118: select count(*)
119: into v_yr_count
120: from per_time_period_sets tps
121: where tps.period_set_name = p_period_set_name;
122: exception
123: when no_data_found then null;
124: end;

Line 423: insert into per_time_period_sets

419: v_4th_qtr_end_date := add_months(v_yr_start_date,12) - 1;
420: --
421: -- Create a calendar year. This is to allow the 2.3 form to query back
422: -- calendars created by the 4.0 form and vice versa.
423: insert into per_time_period_sets
424: (start_date,
425: period_set_name,
426: period_type,
427: end_date_q1,

Line 565: delete from per_time_period_sets tps

561: where tpe.period_set_name = p_period_set_name
562: and tpe.period_year > p_number_of_years;
563: --
564: -- Remove calendar years.
565: delete from per_time_period_sets tps
566: where tps.period_set_name = p_period_set_name
567: and tps.year_number > p_number_of_years;
568: --
569: end if;