APPS.IGI_EXP_APPROVAL_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 1408: l_pos_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE;

1404: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;
1405: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
1406: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1407: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
1408: l_pos_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE;
1409:
1410: --
1411: -- Find the current version of the position hierarchy
1412: --

Line 1432: CURSOR c_is_pos_subord(p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE

1428: --
1429: -- Find out NOCOPY if the position exists as a subordinate position in the current
1430: -- version of the position hierarchy
1431: --
1432: CURSOR c_is_pos_subord(p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE
1433: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
1434: ,p_position_id per_all_positions.position_id%TYPE)
1435: IS
1436: SELECT pos_structure_element_id

Line 1437: FROM per_pos_structure_elements

1433: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
1434: ,p_position_id per_all_positions.position_id%TYPE)
1435: IS
1436: SELECT pos_structure_element_id
1437: FROM per_pos_structure_elements
1438: WHERE pos_structure_version_id = p_pos_structure_ver_id
1439: AND business_group_id = p_business_group_id
1440: AND subordinate_position_id = p_position_id;
1441:

Line 1446: CURSOR c_is_pos_parent(p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE

1442: --
1443: -- Find out NOCOPY if the position exists as a parent position in the current
1444: -- version of the position hierarchy
1445: --
1446: CURSOR c_is_pos_parent(p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE
1447: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
1448: ,p_position_id per_all_positions.position_id%TYPE)
1449: IS
1450: SELECT pos_structure_element_id

Line 1451: FROM per_pos_structure_elements

1447: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
1448: ,p_position_id per_all_positions.position_id%TYPE)
1449: IS
1450: SELECT pos_structure_element_id
1451: FROM per_pos_structure_elements
1452: WHERE pos_structure_version_id = p_pos_structure_ver_id
1453: AND business_group_id = p_business_group_id
1454: AND parent_position_id = p_position_id;
1455:

Line 1775: FROM per_pos_structure_elements

1771: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
1772: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
1773: IS
1774: SELECT parent_position_id
1775: FROM per_pos_structure_elements
1776: WHERE pos_structure_version_id = p_pos_structure_version_id
1777: AND business_group_id = p_business_group_id
1778: AND subordinate_position_id = p_position_id;
1779:

Line 3186: FROM per_pos_structure_elements

3182: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
3183: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
3184: IS
3185: SELECT subordinate_position_id
3186: FROM per_pos_structure_elements
3187: WHERE pos_structure_version_id = p_pos_structure_version_id
3188: AND business_group_id = p_business_group_id
3189: AND parent_position_id = p_position_id;
3190:

Line 5721: FROM per_pos_structure_elements

5717: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
5718: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
5719: IS
5720: SELECT parent_position_id
5721: FROM per_pos_structure_elements
5722: WHERE pos_structure_version_id = p_pos_structure_version_id
5723: AND business_group_id = p_business_group_id
5724: AND subordinate_position_id = p_position_id;
5725: