DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_BAL_ATTRIBUTES

Line 337: , pay_shadow_bal_attributes sba

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
341: and sbt.template_id = p_template_id;

Line 501: l_table := 'PAY_SHADOW_BAL_ATTRIBUTES';

497: raise l_error;
498: end if;
499: close csr_sgb_belongs;
500: elsif p_core_object_type = pay_tco_shd.g_sba_lookup_type then
501: l_table := 'PAY_SHADOW_BAL_ATTRIBUTES';
502: open csr_sba_belongs;
503: fetch csr_sba_belongs into l_exists;
504: if csr_sba_belongs%notfound then
505: close csr_sba_belongs;