DBA Data[Home] [Help]

APPS.PA_RBS_ELEMENTS_UTILS SQL Statements

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

Line: 15

        Select
                'Y'
	Into
		l_dummy
        From
                Pa_Rbs_Elements
        Where
                Rbs_Element_Id = P_Element_Id;
Line: 45

	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;
Line: 126

	Select
		Res_Type_Code
	Into
		l_Res_Type_Code
	From
		Pa_Res_Types_B
	Where
		Res_Type_Id = P_Res_Type_Id;