APPS.PQH_DE_DETACH_WP_SP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE DELETE_STELLEN_PLAN(pWrkplc_id IN NUMBER ,pStellen_Plan_id IN NUMBER) is

-- cursor to find stellens attached to workplace

cursor extra_info_id(Wid Number, Sid Number) is
select
position_extra_info_id
,object_version_number
from per_position_extra_info
where information_type='DE_PQH_WRKPLC_STELLE_LINK'
and position_id=Wid
and to_number(poei_information3)=Sid;

Line: 20

select
position_id
from hr_all_positions_f
where
       information1='ST'
and    to_number(information6)=SpId;

Line: 34

   hr_position_extra_info_api.delete_position_extra_info
    (
     p_position_extra_info_id => C2. position_extra_info_id
    ,p_object_version_number=>C2.object_version_number
    );

Line: 41

end DELETE_STELLEN_PLAN;