DBA Data[Home] [Help]

APPS.PAY_SIV_BUS dependencies on PAY_SHADOW_FORMULAS

Line 1132: from pay_shadow_formulas sf

1128: -- formula must encompass that of the template.
1129:
1130: cursor csr_T_formula_valid is
1131: select null
1132: from pay_shadow_formulas sf
1133: where sf.formula_id = p_formula_id
1134: and sf.template_type = 'T'
1135: and sf.formula_type_name = pay_sf_shd.g_input_val_formula_type
1136: and ((sf.legislation_code is null and sf.business_group_id is null) or

Line 1145: from pay_shadow_formulas sf

1141: -- must not be shared with any other templates to avoid name clashes.
1142: --
1143: cursor csr_U_formula_valid is
1144: select null
1145: from pay_shadow_formulas sf
1146: where sf.formula_id = p_formula_id
1147: and sf.template_type = 'U'
1148: and sf.formula_type_name = pay_sf_shd.g_input_val_formula_type
1149: and sf.business_group_id = p_business_group_id