APPS.PAY_TCO_BUS dependencies on PAY_BALANCE_CLASSIFICATIONS

Line 585: from pay_balance_classifications bc

581: scr.effective_start_date and scr.effective_end_date;
582: --
583: cursor csr_sbc_exists is
584: select null
585: from pay_balance_classifications bc
586: where bc.balance_classification_id = p_core_object_id
587: and bc.business_group_id = p_business_group_id;
588: --
589: cursor csr_siv_exists is

Line 738: l_table := 'PAY_BALANCE_CLASSIFICATIONS';

734: raise l_error;
735: end if;
736: close csr_ssr_exists;
737: elsif p_core_object_type = pay_tco_shd.g_sbc_lookup_type then
738: l_table := 'PAY_BALANCE_CLASSIFICATIONS';
739: open csr_sbc_exists;
740: fetch csr_sbc_exists into l_exists;
741: if csr_sbc_exists%notfound then
742: close csr_sbc_exists;