APPS.PSP_PSPRCLSL_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 36: from per_time_periods

32: x_person_name VARCHAR2(240);
33: x_end_date DATE;
34: begin
35: select end_date into x_end_date
36: from per_time_periods
37: where time_period_id = p_time_period_id;
38:
39: select full_name into x_person_name
40: from per_people_f

Line 90: from per_time_periods

86: --orientation := 'LANDSCAPE';
87:
88:
89: select start_date into p_start_date
90: from per_time_periods
91: where time_period_id = p_time_period_id;
92: return (TRUE);
93: RETURN NULL; exception when no_data_found then
94: /*srw.message(1,'Start Date not found for the selected time period id');*/null;

Line 203: select period_name into x_time_period from per_time_periods

199: function CF_time_periodFormula return VARCHAR2 is
200: x_time_period varchar2(35);
201: begin
202: if p_time_period_id is not null then
203: select period_name into x_time_period from per_time_periods
204: where time_period_id = p_time_period_id;
205: return(x_time_period);
206: end if;
207: RETURN NULL; end;