APPS.PSP_PSPRCPGD_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 33: from per_time_periods

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

Line 57: from per_time_periods

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;

Line 307: select period_name into x_time_period from per_time_periods

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;