APPS.PER_ORG_STRUCTURE_VERSIONS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 212: from per_org_structure_elements ose

208: --
209: -- Define cursor for inserts
210: --
211: cursor struct_element is select *
212: from per_org_structure_elements ose
213: where ose.org_structure_version_id = p_copy_structure_version_id;
214: --
215: -- Local Variable
216: --

Line 224: INSERT INTO PER_ORG_STRUCTURE_ELEMENTS(

220: open struct_element;
221: fetch struct_element into ele_record;
222: loop
223: exit when struct_element%NOTFOUND;
224: INSERT INTO PER_ORG_STRUCTURE_ELEMENTS(
225: org_structure_element_id,
226: business_group_id,
227: organization_id_parent,
228: org_structure_version_id,

Line 231: PER_ORG_STRUCTURE_ELEMENTS_S.NEXTVAL,

227: organization_id_parent,
228: org_structure_version_id,
229: organization_id_child
230: ) VALUES (
231: PER_ORG_STRUCTURE_ELEMENTS_S.NEXTVAL,
232: ele_record.Business_Group_Id,
233: ele_record.Organization_Id_Parent,
234: p_org_structure_version_id,
235: ele_record.Organization_Id_Child

Line 454: from per_org_structure_elements ose

450: select null
451: into l_dummy
452: from sys.dual
453: where exists ( select 1
454: from per_org_structure_elements ose
455: where ose.org_structure_version_id = p_org_Structure_Version_Id
456: );
457: --
458: hr_utility.set_message('801','HR_6204_ORG_SUBORD_EXIST');