DBA Data[Home] [Help]

APPS.HR_JP_PARAMETERS_PKG SQL Statements

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

Line: 11

			select	parameter_value
			from	hr_jp_parameters
			where	owner=p_owner
			and	parameter_name=p_parameter_name;
Line: 34

			select	rowid
			from	hr_jp_parameters
			where	owner=p_owner
			and	parameter_name=p_parameter_name
			for update nowait;
Line: 48

			update	hr_jp_parameters
			set	parameter_value=p_parameter_value
			where	rowid=l_rowid;
Line: 52

			insert into HR_JP_PARAMETERS(
				OWNER,
				PARAMETER_NAME,
				PARAMETER_VALUE)
			values(	p_owner,
				p_parameter_name,
				p_parameter_value);