APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_ITERATIVE_RULES

Line 312: , pay_shadow_iterative_rules sir

308: --
309: cursor csr_sir_belongs is
310: select null
311: from pay_shadow_element_types pset
312: , pay_shadow_iterative_rules sir
313: where pset.template_id = p_template_id
314: and sir.element_type_id = pset.element_type_id
315: and sir.iterative_rule_id = p_shadow_object_id;
316: --

Line 474: l_table := 'PAY_SHADOW_ITERATIVE_RULES';

470: raise l_error;
471: end if;
472: close csr_sfr_belongs;
473: elsif p_core_object_type = pay_tco_shd.g_sir_lookup_type then
474: l_table := 'PAY_SHADOW_ITERATIVE_RULES';
475: open csr_sir_belongs;
476: fetch csr_sir_belongs into l_exists;
477: if csr_sir_belongs%notfound then
478: close csr_sir_belongs;