APPS.IGIDOSL dependencies on PER_POS_STRUCTURE_VERSIONS

Line 674: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;

670:
671: l_picked_role wf_notifications.responder%TYPE;
672: l_error VARCHAR2(1000) ;
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 ;

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

Line 750: FROM per_pos_structure_versions

746: CURSOR c_pos_hier_ver(p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
747: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
748: IS
749: SELECT pos_structure_version_id
750: FROM per_pos_structure_versions
751: WHERE position_structure_id = p_hierarchy_id
752: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
753: AND business_group_id = p_business_group_id
754: AND version_number =

Line 756: FROM per_pos_structure_versions

752: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
753: AND business_group_id = p_business_group_id
754: AND version_number =
755: (SELECT MAX(version_number)
756: FROM per_pos_structure_versions
757: WHERE position_structure_id = p_hierarchy_id
758: AND SYSDATE BETWEEN date_FROM AND NVL(date_to,SYSDATE)
759: AND business_group_id = p_business_group_id);
760:

Line 784: (p_hier_ver_id per_pos_structure_versions.pos_structure_version_id%TYPE,

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

Line 3075: per_pos_structure_versions.pos_structure_version_id%TYPE;

3071:
3072: l_hierarchy_id
3073: per_position_structures.position_structure_id%TYPE;
3074: l_hierarchy_version_id
3075: per_pos_structure_versions.pos_structure_version_id%TYPE;
3076: l_pos_structure_element_id
3077: per_pos_structure_elements.pos_structure_element_id%TYPE;
3078:
3079: -- Cursor to FETCH position hierarchy

Line 3090: FROM per_pos_structure_versions

3086: CURSOR c_pos_hier_ver
3087: (p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
3088: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS
3089: SELECT pos_structure_version_id
3090: FROM per_pos_structure_versions
3091: WHERE position_structure_id = p_hierarchy_id
3092: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
3093: AND business_group_id = p_business_group_id
3094: AND version_number =

Line 3096: FROM per_pos_structure_versions

3092: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)
3093: AND business_group_id = p_business_group_id
3094: AND version_number =
3095: (SELECT MAX(version_number)
3096: FROM per_pos_structure_versions
3097: WHERE position_structure_id = p_hierarchy_id
3098: AND SYSDATE BETWEEN date_FROM AND NVL(date_to,SYSDATE)
3099: AND business_group_id = p_business_group_id);
3100: