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.IGIDOSL dependencies on PER_ALL_POSITIONS

Line 662: l_position_id per_all_positions.position_id%TYPE;

658: l_position_structure_id per_position_structures.position_structure_id%TYPE ;
659: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
660: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;
661: l_parent_position_id per_positions.position_id%TYPE ;
662: l_position_id per_all_positions.position_id%TYPE;
663: l_top_position_id per_all_positions.position_id%TYPE ;
664: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
665: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
666: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 663: l_top_position_id per_all_positions.position_id%TYPE ;

659: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
660: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;
661: l_parent_position_id per_positions.position_id%TYPE ;
662: l_position_id per_all_positions.position_id%TYPE;
663: l_top_position_id per_all_positions.position_id%TYPE ;
664: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
665: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
666: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
667: l_organization_id hr_all_positions_f.organization_id%TYPE;

Line 770: p_position_id per_all_positions.position_id%TYPE,

766: /****************************/
767:
768: CURSOR c_par_pos_id
769: (p_hier_ver_id per_pos_structure_versions.pos_structure_version_id%TYPE,
770: p_position_id per_all_positions.position_id%TYPE,
771: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
772: IS
773: SELECT parent_position_id
774: FROM per_pos_structure_elements

Line 2973: p_position_id per_all_positions.position_id%TYPE) IS

2969: (p_business_group_id
2970: hr_all_positions_f.business_group_id%TYPE,
2971: p_pos_structure_ver_id
2972: per_pos_structure_elements.pos_structure_version_id%TYPE,
2973: p_position_id per_all_positions.position_id%TYPE) IS
2974: SELECT pos_structure_element_id
2975: FROM per_pos_structure_elements
2976: WHERE pos_structure_version_id = p_pos_structure_ver_id
2977: AND business_group_id = p_business_group_id