283: select * from per_time_periods where rowid = l_row_id;
284: Begin
285: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
286:
287: l_date_start := nvl(fnd_date.canonical_to_date(p_date_start),hr_api.g_sot);
288: l_date_to := nvl(fnd_date.canonical_to_date(p_date_to),hr_api.g_eot);
289:
290: hr_utility.set_location( g_package||l_proc, 20);
291: for get_rowid in c_get_rowid loop
284: Begin
285: hr_utility.set_location('entering :'|| g_package||l_proc, 10);
286:
287: l_date_start := nvl(fnd_date.canonical_to_date(p_date_start),hr_api.g_sot);
288: l_date_to := nvl(fnd_date.canonical_to_date(p_date_to),hr_api.g_eot);
289:
290: hr_utility.set_location( g_package||l_proc, 20);
291: for get_rowid in c_get_rowid loop
292: l_row_id := get_rowid.ROWID;