Line 188: x_pa_period pa_periods.period_name%TYPE;
184: FUNCTION get_pa_period (
185: x_pa_date IN DATE
186: )
187: RETURN VARCHAR2 IS 188: x_pa_period pa_periods.period_name%TYPE; 189: BEGIN
190:
191: SELECT pp.period_name
192: INTO x_pa_period
Line 193: FROM pa_periods pp
189: BEGIN
190:
191: SELECT pp.period_name
192: INTO x_pa_period 193: FROM pa_periods pp 194: WHERE x_pa_date between pp.start_date and pp.end_date;
195: RETURN x_pa_period;
196:
197: EXCEPTION