587: and bc.business_group_id = p_business_group_id;
588: --
589: cursor csr_siv_exists is
590: select null
591: from pay_input_values_f iv
592: where iv.input_value_id = p_core_object_id
593: and iv.business_group_id = p_business_group_id
594: and p_effective_date between
595: iv.effective_start_date and iv.effective_end_date;
743: raise l_error;
744: end if;
745: close csr_sbc_exists;
746: elsif p_core_object_type = pay_tco_shd.g_siv_lookup_type then
747: l_table := 'PAY_INPUT_VALUES_F';
748: open csr_siv_exists;
749: fetch csr_siv_exists into l_exists;
750: if csr_siv_exists%notfound then
751: close csr_siv_exists;