DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_BALANCE_FEEDS_F

Line 599: from pay_balance_feeds_f bf

595: iv.effective_start_date and iv.effective_end_date;
596: --
597: cursor csr_sbf_exists is
598: select null
599: from pay_balance_feeds_f bf
600: where bf.balance_feed_id = p_core_object_id
601: and bf.business_group_id = p_business_group_id
602: and p_effective_date between
603: bf.effective_start_date and bf.effective_end_date;

Line 756: l_table := 'PAY_BALANCE_FEEDS_F';

752: raise l_error;
753: end if;
754: close csr_siv_exists;
755: elsif p_core_object_type = pay_tco_shd.g_sbf_lookup_type then
756: l_table := 'PAY_BALANCE_FEEDS_F';
757: open csr_sbf_exists;
758: fetch csr_sbf_exists into l_exists;
759: if csr_sbf_exists%notfound then
760: close csr_sbf_exists;