APPS.PAY_SET_BUS dependencies on PAY_SHADOW_FORMULAS

Line 831: from pay_shadow_formulas sf

827: -- may be shared with other templates, but the legislative domain of the
828: -- formula must encompass that of the template.
829: cursor csr_T_formula_valid is
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

Line 844: from pay_shadow_formulas sf

840: -- must not be shared with any other templates to avoid name clashes.
841: --
842: cursor csr_U_formula_valid is
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