APPS.IGIDOSL dependencies on PER_ALL_POSITIONS

Line 677: l_position_id per_all_positions.position_id%TYPE;

673: l_position_structure_id per_position_structures.position_structure_id%TYPE ;
674: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
675: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;
676: l_parent_position_id per_positions.position_id%TYPE ;
677: l_position_id per_all_positions.position_id%TYPE;
678: l_top_position_id per_all_positions.position_id%TYPE ;
679: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
680: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
681: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 678: l_top_position_id per_all_positions.position_id%TYPE ;

674: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
675: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;
676: l_parent_position_id per_positions.position_id%TYPE ;
677: l_position_id per_all_positions.position_id%TYPE;
678: l_top_position_id per_all_positions.position_id%TYPE ;
679: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
680: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
681: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
682: l_organization_id hr_all_positions_f.organization_id%TYPE;

Line 785: p_position_id per_all_positions.position_id%TYPE,

781: /****************************/
782:
783: CURSOR c_par_pos_id
784: (p_hier_ver_id per_pos_structure_versions.pos_structure_version_id%TYPE,
785: p_position_id per_all_positions.position_id%TYPE,
786: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
787: IS
788: SELECT parent_position_id
789: FROM per_pos_structure_elements

Line 3107: p_position_id per_all_positions.position_id%TYPE) IS

3103: (p_business_group_id
3104: hr_all_positions_f.business_group_id%TYPE,
3105: p_pos_structure_ver_id
3106: per_pos_structure_elements.pos_structure_version_id%TYPE,
3107: p_position_id per_all_positions.position_id%TYPE) IS
3108: SELECT pos_structure_element_id
3109: FROM per_pos_structure_elements
3110: WHERE pos_structure_version_id = p_pos_structure_ver_id
3111: AND business_group_id = p_business_group_id