14: )
15: is
16: --
17: cursor struct_element is select *
18: from per_org_structure_elements ose
19: where ose.org_structure_version_id = p_copy_structure_version_id;
20:
21:
22: ele_record struct_element%ROWTYPE;
19: where ose.org_structure_version_id = p_copy_structure_version_id;
20:
21:
22: ele_record struct_element%ROWTYPE;
23: l_org_structure_element_id per_org_structure_elements.org_structure_element_id%TYPE;
24: l_object_version_number per_org_structure_elements.object_version_number%TYPE;
25: l_inactive_org_warning boolean;
26: l_effective_date date;
27: --
20:
21:
22: ele_record struct_element%ROWTYPE;
23: l_org_structure_element_id per_org_structure_elements.org_structure_element_id%TYPE;
24: l_object_version_number per_org_structure_elements.object_version_number%TYPE;
25: l_inactive_org_warning boolean;
26: l_effective_date date;
27: --
28: begin