APPS.PER_PSE_BUS dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 29: , per_pos_structure_elements pse

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_pos_structure_elements pse
30: where pse.pos_structure_element_id = p_pos_structure_element_id
31: and pbg.business_group_id = pse.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_pos_structure_elements pse

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_pos_structure_elements pse
90: where pse.pos_structure_element_id = p_pos_structure_element_id
91: and pbg.business_group_id = pse.business_group_id;
92: --
93: -- Declare local variables

Line 222: task is achieved by a constraint PER_POS_STRUCTURE_ELEMENTS_UK2 according

218:
219: Removing following check on Position hierarchy so that updation of
220: Position nodes can be done in it. We don't need to put extra check
221: for ensuring not having cycle into position hierarcy because this
222: task is achieved by a constraint PER_POS_STRUCTURE_ELEMENTS_UK2 according
223: to which POS_STRUCTURE_VERSION_ID and SUBORDINATE_POSITION_ID is the unique
224: combination in table PER_POS_STRUCTURE_ELEMENTS.
225:
226: if nvl(p_rec.parent_position_id, hr_api.g_number) <>

Line 224: combination in table PER_POS_STRUCTURE_ELEMENTS.

220: Position nodes can be done in it. We don't need to put extra check
221: for ensuring not having cycle into position hierarcy because this
222: task is achieved by a constraint PER_POS_STRUCTURE_ELEMENTS_UK2 according
223: to which POS_STRUCTURE_VERSION_ID and SUBORDINATE_POSITION_ID is the unique
224: combination in table PER_POS_STRUCTURE_ELEMENTS.
225:
226: if nvl(p_rec.parent_position_id, hr_api.g_number) <>
227: nvl(per_pse_shd.g_old_rec.parent_position_id
228: ,hr_api.g_number

Line 258: per_pos_structure_elements.pos_structure_version_id%TYPE

254: -- |---------------------------< chk_children_exist >----------------------------|
255: -- -------------------------------------------------------------------------------
256: PROCEDURE chk_children_exist
257: (p_pos_structure_version_id in
258: per_pos_structure_elements.pos_structure_version_id%TYPE
259: ,p_Subordinate_position_Id in
260: per_pos_structure_elements.Subordinate_position_Id%TYPE
261: ) is
262: --

Line 260: per_pos_structure_elements.Subordinate_position_Id%TYPE

256: PROCEDURE chk_children_exist
257: (p_pos_structure_version_id in
258: per_pos_structure_elements.pos_structure_version_id%TYPE
259: ,p_Subordinate_position_Id in
260: per_pos_structure_elements.Subordinate_position_Id%TYPE
261: ) is
262: --
263: l_temp VARCHAR2(1);
264: --

Line 274: from per_pos_structure_elements pse

270: select null
271: into l_temp
272: from sys.dual
273: where exists(select 1
274: from per_pos_structure_elements pse
275: where pse.parent_position_id = p_Subordinate_position_Id
276: and pse.pos_structure_version_id = p_Pos_Structure_version_Id);
277: --
278: hr_utility.set_message('801','HR_6915_POS_DEL_FIRST');

Line 452: from per_pos_structure_elements ele

448: and pos.EFFECTIVE_END_DATE;
449:
450: CURSOR csr_ele IS
451: SELECT 'X'
452: from per_pos_structure_elements ele
453: where ele.pos_structure_version_id = p_pos_structure_version_id
454: and ele.subordinate_position_id = p_subordinate_position_id;
455:
456: l_dummy varchar2(1);