DBA Data[Home] [Help]

APPS.PAY_TFU_BUS dependencies on PAY_SF_SHD

Line 302: and nvl(sf.formula_type_name, pay_sf_shd.g_payroll_formula_type) =

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);

Line 303: pay_sf_shd.g_payroll_formula_type

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: --