148: p_effective_date date ) is
149: select PERIOD_NUM,
150: START_DATE,
151: END_DATE
152: from PER_TIME_PERIODS
153: where PAYROLL_ID = p_payroll_id
154: and p_effective_date between START_DATE and END_DATE;
155: --
156: -- Lwthomps, disabled indexes for performance problems
178: min(end_date),
179: max(start_date),
180: max(end_date),
181: count(period_num)
182: from per_time_periods
183: where payroll_id = p_payroll_id
184: and to_char(P_date,'YYYY') = to_char(end_date,'YYYY');
185: --
186: --