APPS.PSB_BUDGET_PERIOD_PVT dependencies on PSB_BUDGET_PERIODS_S

Line 599: update PSB_BUDGET_PERIODS set

595: end if;
596:
597: -- do the update of the record
598: --
599: update PSB_BUDGET_PERIODS set
600: budget_calendar_id = p_budget_calendar_id,
601: name = p_name,
602: start_date = p_start_date,
603: end_date = p_end_date,

Line 1191: SELECT psb_budget_periods_s.nextval

1187: --
1188: l_end_date := LAST_DAY(l_lstart_date) ;
1189: l_short_name := substr(p_parent_name, 1, 10)||'-'||to_char(l_counter);
1190: --
1191: SELECT psb_budget_periods_s.nextval
1192: INTO l_budget_period_id
1193: FROM dual;
1194: --
1195: --

Line 1610: SELECT psb_budget_periods_s.nextval

1606: l_skip_first_rec := FALSE ;
1607: -- disregard first year to be shifted
1608: ELSE
1609: --
1610: SELECT psb_budget_periods_s.nextval
1611: INTO l_year_id
1612: FROM dual;
1613: --
1614: IF p_shift_flag = 'N' THEN