APPS.PAY_SET_BUS dependencies on PAY_SF_SHD

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

830: select null
831: from pay_shadow_formulas sf
832: where sf.formula_id = p_payroll_formula_id
833: and sf.template_type = 'T'
834: and nvl(sf.formula_type_name,pay_sf_shd.g_payroll_formula_type) = pay_sf_shd.g_payroll_formula_type
835: and ((sf.legislation_code is null and sf.business_group_id is null) or
836: sf.legislation_code = p_legislation_code or
837: sf.business_group_id = p_business_group_id);
838: --

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

843: select null
844: from pay_shadow_formulas sf
845: where sf.formula_id = p_payroll_formula_id
846: and sf.template_type = 'U'
847: and nvl(sf.formula_type_name,pay_sf_shd.g_payroll_formula_type) = pay_sf_shd.g_payroll_formula_type
848: and sf.business_group_id = p_business_group_id
849: and not exists
850: (select null
851: from pay_shadow_element_types pset