The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select
'Y'
Into
l_dummy
From
Pa_Rbs_Elements
Where
Rbs_Element_Id = P_Element_Id;
Select
Rbs_Element_Name_Id
Into
l_Rbs_Element_Name_Id
From
Pa_Rbs_Element_Names_B
Where
Resource_Type_id = P_Resource_Type_Id
And Resource_Source_Id = P_Resource_Source_Id;
Select
Res_Type_Code
Into
l_Res_Type_Code
From
Pa_Res_Types_B
Where
Res_Type_Id = P_Res_Type_Id;