DBA Data[Home] [Help]

APPS.PQH_RANKING dependencies on FND_DATE

Line 343: l_dt_start := trunc(fnd_date.canonical_to_date(p_process_dt_start));

339: l_dt_start date;
340: l_dt_end date;
341: BEGIN
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: l_dt_start := trunc(fnd_date.canonical_to_date(p_process_dt_start));
344: l_dt_end := trunc(fnd_date.canonical_to_date(p_process_dt_end ));
345:
346: l_dt_end := nvl(l_dt_end , hr_general.end_of_time );
347: l_dt_start := nvl(l_dt_start, hr_general.start_of_time);

Line 344: l_dt_end := trunc(fnd_date.canonical_to_date(p_process_dt_end ));

340: l_dt_end date;
341: BEGIN
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: l_dt_start := trunc(fnd_date.canonical_to_date(p_process_dt_start));
344: l_dt_end := trunc(fnd_date.canonical_to_date(p_process_dt_end ));
345:
346: l_dt_end := nvl(l_dt_end , hr_general.end_of_time );
347: l_dt_start := nvl(l_dt_start, hr_general.start_of_time);
348: