298: select null
299: from pay_shadow_formulas sf
300: where sf.formula_id = p_formula_id
301: and sf.template_type = 'T'
302: and nvl(sf.formula_type_name, pay_sf_shd.g_payroll_formula_type) =
303: pay_sf_shd.g_payroll_formula_type
304: and ((sf.legislation_code is null and sf.business_group_id is null) or
305: sf.legislation_code = p_legislation_code or
306: sf.business_group_id = p_business_group_id);
299: from pay_shadow_formulas sf
300: where sf.formula_id = p_formula_id
301: and sf.template_type = 'T'
302: and nvl(sf.formula_type_name, pay_sf_shd.g_payroll_formula_type) =
303: pay_sf_shd.g_payroll_formula_type
304: and ((sf.legislation_code is null and sf.business_group_id is null) or
305: sf.legislation_code = p_legislation_code or
306: sf.business_group_id = p_business_group_id);
307: --