APPS.GHR_TSP_CATCHUP_PLAN_DESIGN dependencies on HR_API

Line 232: and e.effective_end_date = hr_api.g_eot

228: and f.element_entry_id = e.element_entry_id
229: and f.input_value_id = b.input_value_id
230: and a.element_type_id = e.element_type_id
231: and g.business_group_id = c_business_group_id
232: and e.effective_end_date = hr_api.g_eot
233: --and trunc(sysdate) between e.effective_start_date and e.effective_End_date
234: and trunc(e.effective_start_date) between f.effective_start_date and f.effective_End_date
235: and g.assignment_id = e.assignment_id
236: and trunc(e.effective_start_date) between g.effective_start_date and g.effective_end_date

Line 279: --and start_date between nvl(p_date_start,hr_api.g_sot) and nvl(p_date_to,hr_api.g_eot);

275: Cursor c_get_rowid is
276: select ROWID
277: from per_time_periods
278: where payroll_id = p_payroll_id
279: --and start_date between nvl(p_date_start,hr_api.g_sot) and nvl(p_date_to,hr_api.g_eot);
280: and start_date between l_date_start and l_date_to ;
281:
282: Cursor c_get_details is
283: select * from per_time_periods where rowid = l_row_id;

Line 287: l_date_start := nvl(fnd_date.canonical_to_date(p_date_start),hr_api.g_sot);

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

Line 288: l_date_to := nvl(fnd_date.canonical_to_date(p_date_to),hr_api.g_eot);

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;