APPS.PAY_SFR_SHD SQL Statements

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

Line: 64

    select
		formula_result_rule_id,
	shadow_element_type_id,
	element_type_id,
	result_name,
	result_rule_type,
	severity_level,
	input_value_id,
	exclusion_rule_id,
	object_version_number,
        element_name
    from	pay_shadow_formula_rules
    where	formula_result_rule_id = p_formula_result_rule_id;

Line: 144

    select 	formula_result_rule_id,
	shadow_element_type_id,
	element_type_id,
	result_name,
	result_rule_type,
	severity_level,
	input_value_id,
	exclusion_rule_id,
	object_version_number,
        element_name
    from	pay_shadow_formula_rules
    where	formula_result_rule_id = p_formula_result_rule_id
    for	update nowait;