APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_ELE_TYPE_USAGES

Line 320: , pay_shadow_ele_type_usages etu

316: --
317: cursor csr_seu_belongs is
318: select null
319: from pay_shadow_element_types pset
320: , pay_shadow_ele_type_usages etu
321: where pset.template_id = p_template_id
322: and etu.element_type_id = pset.element_type_id
323: and etu.element_type_usage_id = p_shadow_object_id;
324: --

Line 483: l_table := 'PAY_SHADOW_ELE_TYPE_USAGES';

479: raise l_error;
480: end if;
481: close csr_sir_belongs;
482: elsif p_core_object_type = pay_tco_shd.g_seu_lookup_type then
483: l_table := 'PAY_SHADOW_ELE_TYPE_USAGES';
484: open csr_seu_belongs;
485: fetch csr_seu_belongs into l_exists;
486: if csr_seu_belongs%notfound then
487: close csr_seu_belongs;