DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 671: from per_pos_structure_elements pse

667: begin
668: hr_utility.set_location('hr_reports.count_pos_subordinates',10);
669: select nvl(count(*),0)
670: into v_subordinate_count
671: from per_pos_structure_elements pse
672: connect by pse.parent_position_id = prior pse.subordinate_position_id
673: and pse.pos_structure_version_id = p_pos_structure_version_id
674: start with pse.parent_position_id = p_parent_position_id
675: and pse.pos_structure_version_id = p_pos_structure_version_id;