APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_FORMULA_RULES

Line 304: , pay_shadow_formula_rules sfr

300: --
301: cursor csr_sfr_belongs is
302: select null
303: from pay_shadow_element_types pset
304: , pay_shadow_formula_rules sfr
305: where pset.template_id = p_template_id
306: and sfr.shadow_element_type_id = pset.element_type_id
307: and sfr.formula_result_rule_id = p_shadow_object_id;
308: --

Line 465: l_table := 'PAY_SHADOW_FORMULA_RULES';

461: raise l_error;
462: end if;
463: close csr_sbf_belongs;
464: elsif p_core_object_type = pay_tco_shd.g_sfr_lookup_type then
465: l_table := 'PAY_SHADOW_FORMULA_RULES';
466: open csr_sfr_belongs;
467: fetch csr_sfr_belongs into l_exists;
468: if csr_sfr_belongs%notfound then
469: close csr_sfr_belongs;