APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_DEFINED_BALANCES

Line 256: , pay_shadow_defined_balances sdb

252: --
253: cursor csr_sdb_belongs is
254: select null
255: from pay_shadow_balance_types sbt
256: , pay_shadow_defined_balances sdb
257: where sbt.template_id = p_template_id
258: and sdb.balance_type_id = sbt.balance_type_id
259: and sdb.defined_balance_id = p_shadow_object_id;
260: --

Line 336: , pay_shadow_defined_balances sdb

332: --
333: cursor csr_sba_belongs is
334: select null
335: from pay_shadow_balance_types sbt
336: , pay_shadow_defined_balances sdb
337: , pay_shadow_bal_attributes sba
338: where sba.balance_attribute_id = p_shadow_object_id
339: and sba.defined_balance_id = sdb.defined_balance_id
340: and sdb.balance_type_id = sbt.balance_type_id

Line 409: l_table := 'PAY_SHADOW_DEFINED_BALANCES';

405: raise l_error;
406: end if;
407: close csr_sbt_belongs;
408: elsif p_core_object_type = pay_tco_shd.g_sdb_lookup_type then
409: l_table := 'PAY_SHADOW_DEFINED_BALANCES';
410: open csr_sdb_belongs;
411: fetch csr_sdb_belongs into l_exists;
412: if csr_sdb_belongs%notfound then
413: close csr_sdb_belongs;