APPS.PAY_SIV_SHD SQL Statements

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

Line: 59

    select
	input_value_id,
	element_type_id,
	display_sequence,
	generate_db_items_flag,
	hot_default_flag,
	mandatory_flag,
	name,
	uom,
	lookup_type,
	default_value,
	max_value,
	min_value,
	warning_or_error,
	default_value_column,
	exclusion_rule_id,
	formula_id,
	input_validation_formula,
	object_version_number
    from	pay_shadow_input_values
    where	input_value_id = p_input_value_id;

Line: 147

    select 	input_value_id,
	element_type_id,
	display_sequence,
	generate_db_items_flag,
	hot_default_flag,
	mandatory_flag,
	name,
	uom,
	lookup_type,
	default_value,
	max_value,
	min_value,
	warning_or_error,
	default_value_column,
	exclusion_rule_id,
	formula_id,
	input_validation_formula,
	object_version_number
    from	pay_shadow_input_values
    where	input_value_id = p_input_value_id
    for	update nowait;