APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_SUB_CLASSI_RULES

Line 270: , pay_shadow_sub_classi_rules scr

266: --
267: cursor csr_ssr_belongs is
268: select null
269: from pay_shadow_element_types pset
270: , pay_shadow_sub_classi_rules scr
271: where pset.template_id = p_template_id
272: and scr.element_type_id = pset.element_type_id
273: and scr.sub_classification_rule_id = p_shadow_object_id;
274: --

Line 429: l_table := 'PAY_SHADOW_SUB_CLASSI_RULES';

425: raise l_error;
426: end if;
427: close csr_set_belongs;
428: elsif p_core_object_type = pay_tco_shd.g_ssr_lookup_type then
429: l_table := 'PAY_SHADOW_SUB_CLASSI_RULES';
430: open csr_ssr_belongs;
431: fetch csr_ssr_belongs into l_exists;
432: if csr_ssr_belongs%notfound then
433: close csr_ssr_belongs;