APPS.PER_PSE_BUS dependencies on HR_ALL_POSITIONS_F

Line 410: -- exist in hr_all_positions_f for the business group on the effective_date.

406: -- |-------------------< chk_parent_child_position_id >------------------------|
407: -- -----------------------------------------------------------------------------
408: -- Description:
409: -- Validates that both the parent and subordinate positions are supplied and
410: -- exist in hr_all_positions_f for the business group on the effective_date.
411: -- Also checks that the subordinate position is unique within the structure
412: -- version, to prevent circular hierarchies. (Insert Only).
413: --
414: -- Pre-conditions:

Line 444: from hr_all_positions_f pos

440: ,p_subordinate_position_id in NUMBER) IS
441:
442: CURSOR csr_pos (p_pos_id in NUMBER) IS
443: SELECT 'X'
444: from hr_all_positions_f pos
445: where pos.POSITION_ID = p_pos_id
446: and pos.business_group_id = p_business_group_id
447: and p_effective_date between pos.EFFECTIVE_START_DATE
448: and pos.EFFECTIVE_END_DATE;