APPS.PER_PSV_BUS dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 192: from per_pos_structure_elements ose

188: --
189: -- Define cursor for inserts
190: --
191: cursor struct_element is select *
192: from per_pos_structure_elements ose
193: where ose.pos_structure_version_id = p_src_psv_id;
194: --
195: -- Local Variable
196: --

Line 229: INSERT INTO PER_POS_STRUCTURE_ELEMENTS(

225: open struct_element;
226: fetch struct_element into ele_record;
227: loop
228: exit when struct_element%NOTFOUND;
229: INSERT INTO PER_POS_STRUCTURE_ELEMENTS(
230: pos_structure_element_id,
231: business_group_id,
232: parent_position_id,
233: pos_structure_version_id

Line 235: PER_POS_STRUCTURE_ELEMENTS_S.NEXTVAL,

231: business_group_id,
232: parent_position_id,
233: pos_structure_version_id
234: ) VALUES (
235: PER_POS_STRUCTURE_ELEMENTS_S.NEXTVAL,
236: ele_record.Business_Group_Id,
237: ele_record.parent_position_Id,
238: p_pos_structure_version_id
239: );