29: x_person_name VARCHAR2(240);
30: x_end_date DATE;
31: begin
32: select end_date into x_end_date
33: from per_time_periods
34: where time_period_id = p_time_period_id;
35:
36: select full_name into x_person_name
37: from per_people_f
53:
54:
55:
56: select start_date into p_start_date
57: from per_time_periods
58: where time_period_id = p_time_period_id;
59: return (TRUE);
60: RETURN NULL; exception when no_data_found then
61: /*srw.message(1,'Start Date not found for the selected time period id');*/null;
303: function CF_time_periodFormula return VARCHAR2 is
304: x_time_period varchar2(35);
305: begin
306: if p_time_period_id is not null then
307: select period_name into x_time_period from per_time_periods
308: where time_period_id = p_time_period_id;
309: return(x_time_period);
310: end if;
311: RETURN NULL; end;