DBA Data[Home] [Help]

APPS.OTA_PLE_BUS dependencies on HR_GENERAL

Line 503: elsif nvl(p_ple_enddate,hr_general.end_of_time) <= l_tpl_enddate then

499: hr_utility.trace('PLE End Date = '||to_char(p_ple_enddate));
500: --
501: if l_tpl_enddate is null then
502: return TRUE;
503: elsif nvl(p_ple_enddate,hr_general.end_of_time) <= l_tpl_enddate then
504: return TRUE;
505: else
506: return FALSE;
507: end if;

Line 550: elsif nvl(p_ple_enddate,hr_general.end_of_time) <= l_tav_enddate then

546: end if;
547: --
548: if l_tav_enddate is null then
549: return TRUE;
550: elsif nvl(p_ple_enddate,hr_general.end_of_time) <= l_tav_enddate then
551: return TRUE;
552: else
553: return FALSE;
554: end if;

Line 678: g_end_of_time := hr_general.end_of_time;

674: begin
675: --
676: chkp;
677: --
678: g_end_of_time := hr_general.end_of_time;
679: --
680: if p_price_basis = 'C' then
681: open csr_cple;
682: fetch csr_cple into l_dummy;