APPS.IGIDOSL dependencies on PER_POS_STRUCTURE_VERSIONS

Line 659: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;

655:
656: l_picked_role wf_notifications.responder%TYPE;
657: l_error VARCHAR2(1000) ;
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 ;

Line 664: l_hierarchy_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;
668: l_current_user_name fnd_user.user_name%TYPE;

Line 735: FROM per_pos_structure_versions

731: CURSOR c_pos_hier_ver(p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
732: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
733: IS
734: SELECT pos_structure_version_id
735: FROM per_pos_structure_versions
736: WHERE position_structure_id = p_hierarchy_id
737: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
738: AND business_group_id = p_business_group_id
739: AND version_number =

Line 741: FROM per_pos_structure_versions

737: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
738: AND business_group_id = p_business_group_id
739: AND version_number =
740: (SELECT MAX(version_number)
741: FROM per_pos_structure_versions
742: WHERE position_structure_id = p_hierarchy_id
743: AND SYSDATE BETWEEN date_FROM AND NVL(date_to,SYSDATE)
744: AND business_group_id = p_business_group_id);
745:

Line 769: (p_hier_ver_id per_pos_structure_versions.pos_structure_version_id%TYPE,

765: /* FETCH parent position id */
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

Line 2941: per_pos_structure_versions.pos_structure_version_id%TYPE;

2937:
2938: l_hierarchy_id
2939: per_position_structures.position_structure_id%TYPE;
2940: l_hierarchy_version_id
2941: per_pos_structure_versions.pos_structure_version_id%TYPE;
2942: l_pos_structure_element_id
2943: per_pos_structure_elements.pos_structure_element_id%TYPE;
2944:
2945: -- Cursor to FETCH position hierarchy

Line 2956: FROM per_pos_structure_versions

2952: CURSOR c_pos_hier_ver
2953: (p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
2954: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS
2955: SELECT pos_structure_version_id
2956: FROM per_pos_structure_versions
2957: WHERE position_structure_id = p_hierarchy_id
2958: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
2959: AND business_group_id = p_business_group_id
2960: AND version_number =

Line 2962: FROM per_pos_structure_versions

2958: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
2959: AND business_group_id = p_business_group_id
2960: AND version_number =
2961: (SELECT MAX(version_number)
2962: FROM per_pos_structure_versions
2963: WHERE position_structure_id = p_hierarchy_id
2964: AND SYSDATE BETWEEN date_FROM AND NVL(date_to,SYSDATE)
2965: AND business_group_id = p_business_group_id);
2966: