DBA Data[Home] [Help]

APPS.PAY_TCO_BUS dependencies on PAY_INPUT_VALUES_F

Line 591: from pay_input_values_f iv

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;

Line 747: l_table := 'PAY_INPUT_VALUES_F';

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;