APPS.PAY_SIV_BUS dependencies on PAY_SF_SHD

Line 1135: and sf.formula_type_name = pay_sf_shd.g_input_val_formula_type

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
1137: sf.legislation_code = p_legislation_code or
1138: sf.business_group_id = p_business_group_id);
1139: --

Line 1148: and sf.formula_type_name = pay_sf_shd.g_input_val_formula_type

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
1150: and not exists
1151: (select null
1152: from pay_shadow_input_values psiv , pay_shadow_element_types pset