DBA Data[Home] [Help]

APPS.PA_MISC dependencies on PA_PERIODS

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