APPS.IRC_ITA_BUS dependencies on HR_ALL_POSITIONS_F

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

502: -- |---------------------------< chk_position_id >--------------------------|
503: -- ---------------------------------------------------------------------------
504: --
505: -- Description:
506: -- - Validates that a position id exists in table hr_all_positions_f.
507: --
508: -- Pre-conditions:
509: -- None.
510: --

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

511: -- In Arguments:
512: -- p_position_id
513: --
514: -- Post Success:
515: -- If a row does exist in hr_all_positions_f for the given position id then
516: -- processing continues.
517: --
518: -- Post Failure:
519: -- If a row does not exist in hr_all_positions_f for the given position id then

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

515: -- If a row does exist in hr_all_positions_f for the given position id then
516: -- processing continues.
517: --
518: -- Post Failure:
519: -- If a row does not exist in hr_all_positions_f for the given position id then
520: -- an application error will be raised and processing is terminated.
521: --
522: -- Access Status:
523: -- Internal Table Handler Use Only.

Line 536: from hr_all_positions_f hapf

532: l_proc varchar2(72) := g_package||'chk_position_id';
533: l_pos varchar2(1);
534: cursor csr_pos is
535: select null
536: from hr_all_positions_f hapf
537: where hapf.position_id = p_position_id
538: and trunc(sysdate) between hapf.effective_start_date
539: and hapf.effective_end_date;
540: --

Line 557: -- valid position on HR_ALL_POSITIONS_F

553: --
554: hr_utility.set_location(l_proc, 20);
555: --
556: -- Check that the Position ID is linked to a
557: -- valid position on HR_ALL_POSITIONS_F
558: --
559: open csr_pos;
560: fetch csr_pos into l_pos;
561: --