DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_BALANCE_FEEDS

Line 295: , pay_shadow_balance_feeds sbf

291: cursor csr_sbf_belongs is
292: select null
293: from pay_shadow_element_types pset
294: , pay_shadow_input_values siv
295: , pay_shadow_balance_feeds sbf
296: where pset.template_id = p_template_id
297: and siv.element_type_id = pset.element_type_id
298: and sbf.input_value_id = siv.input_value_id
299: and sbf.balance_feed_id = p_shadow_object_id;

Line 456: l_table := 'PAY_SHADOW_BALANCE_FEEDS';

452: raise l_error;
453: end if;
454: close csr_siv_belongs;
455: elsif p_core_object_type = pay_tco_shd.g_sbf_lookup_type then
456: l_table := 'PAY_SHADOW_BALANCE_FEEDS';
457: open csr_sbf_belongs;
458: fetch csr_sbf_belongs into l_exists;
459: if csr_sbf_belongs%notfound then
460: close csr_sbf_belongs;