DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_BALANCE_CLASSI

Line 278: , pay_shadow_balance_classi sbc

274: --
275: cursor csr_sbc_belongs is
276: select null
277: from pay_shadow_balance_types sbt
278: , pay_shadow_balance_classi sbc
279: where sbt.template_id = p_template_id
280: and sbc.balance_type_id = sbt.balance_type_id
281: and sbc.balance_classification_id = p_shadow_object_id;
282: --

Line 438: l_table := 'PAY_SHADOW_BALANCE_CLASSI';

434: raise l_error;
435: end if;
436: close csr_ssr_belongs;
437: elsif p_core_object_type = pay_tco_shd.g_sbc_lookup_type then
438: l_table := 'PAY_SHADOW_BALANCE_CLASSI';
439: open csr_sbc_belongs;
440: fetch csr_sbc_belongs into l_exists;
441: if csr_sbc_belongs%notfound then
442: close csr_sbc_belongs;