eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IDP_BUS dependencies on HR_ALL_POSITIONS_F

Line 440: -- - Validates that a position id exists in table hr_all_positions_f.

436: -- |---------------------------< chk_position_id >--------------------------|
437: -- ---------------------------------------------------------------------------
438: --
439: -- Description:
440: -- - Validates that a position id exists in table hr_all_positions_f.
441: --
442: -- Pre-conditions:
443: -- None.
444: --

Line 449: -- If a row does exist in hr_all_positions_f for the given position id then

445: -- In Arguments:
446: -- p_position_id
447: --
448: -- Post Success:
449: -- If a row does exist in hr_all_positions_f for the given position id then
450: -- processing continues.
451: --
452: -- Post Failure:
453: -- If a row does not exist in hr_all_positions_f for the given position id then

Line 453: -- If a row does not exist in hr_all_positions_f for the given position id then

449: -- If a row does exist in hr_all_positions_f for the given position id then
450: -- processing continues.
451: --
452: -- Post Failure:
453: -- If a row does not exist in hr_all_positions_f for the given position id then
454: -- an application error will be raised and processing is terminated.
455: --
456: -- Access Status:
457: -- Internal Table Handler Use Only.

Line 470: from hr_all_positions_f hapf

466: l_proc varchar2(72) := g_package||'chk_position_id';
467: l_pos varchar2(1);
468: cursor csr_pos is
469: select null
470: from hr_all_positions_f hapf
471: where hapf.position_id = p_position_id
472: and trunc(sysdate) between hapf.effective_start_date
473: and hapf.effective_end_date;
474: --