APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_BALANCE_TYPES

Line 249: from pay_shadow_balance_types sbt

245: and psiv.formula_id = p_shadow_object_id;
246: --
247: cursor csr_sbt_belongs is
248: select null
249: from pay_shadow_balance_types sbt
250: where sbt.template_id = p_template_id
251: and sbt.balance_type_id = p_shadow_object_id;
252: --
253: cursor csr_sdb_belongs is

Line 255: from pay_shadow_balance_types sbt

251: and sbt.balance_type_id = p_shadow_object_id;
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;

Line 277: from pay_shadow_balance_types sbt

273: and scr.sub_classification_rule_id = p_shadow_object_id;
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;

Line 335: from pay_shadow_balance_types sbt

331: and sgb.grossup_balances_id = p_shadow_object_id;
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

Line 400: l_table := 'PAY_SHADOW_BALANCE_TYPES';

396: if csr_sf_belongs%isopen then
397: close csr_sf_belongs;
398: end if;
399: elsif p_core_object_type = pay_tco_shd.g_sbt_lookup_type then
400: l_table := 'PAY_SHADOW_BALANCE_TYPES';
401: open csr_sbt_belongs;
402: fetch csr_sbt_belongs into l_exists;
403: if csr_sbt_belongs%notfound then
404: close csr_sbt_belongs;