DBA Data[Home] [Help]

APPS.PER_POS_STRUCTURE_ELEMENTS_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS_S

Line 379: CURSOR C2 IS SELECT per_pos_structure_elements_s.nextval FROM sys.dual;

375: X_Parent_Position_Id NUMBER
376: ) IS
377: CURSOR C IS SELECT rowid FROM PER_POS_STRUCTURE_ELEMENTS
378: WHERE pos_structure_element_id = X_Pos_Structure_Element_Id;
379: CURSOR C2 IS SELECT per_pos_structure_elements_s.nextval FROM sys.dual;
380: --
381: cursor get_details is select rowid, POS_STRUCTURE_ELEMENT_ID
382: ,BUSINESS_GROUP_ID, POS_STRUCTURE_VERSION_ID
383: ,SUBORDINATE_POSITION_ID,PARENT_POSITION_ID