APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_EXTRA_INPUT_VALUES

Line 13715: -- and tr.where_clause = l_BEN_EXTRA_INPUT_VALUES

13711: from ben_copy_entity_results cpe,
13712: pqh_table_route tr
13713: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13714: and cpe.table_route_id = tr.table_route_id
13715: -- and tr.where_clause = l_BEN_EXTRA_INPUT_VALUES
13716: and tr.table_alias = l_table_alias
13717: and cpe.number_of_copies = 1 -- ADDITION
13718: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13719: order by information1, information2; --added for bug: 5151945

Line 13751: from BEN_EXTRA_INPUT_VALUES EIV

13747: c_business_group_id number,
13748: c_new_pk_id number) is
13749: select
13750: EIV.extra_input_value_id new_value
13751: from BEN_EXTRA_INPUT_VALUES EIV
13752: where
13753: EIV.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
13754: EIV.INPUT_VALUE_ID = l_INPUT_VALUE_ID and
13755: EIV.business_group_id = c_business_group_id

Line 13994: hr_utility.set_location(' BEN_EXTRA_INPUT_VALUES CREATE_EXTRA_INPUT_VALUE ',20);

13990: --
13991: --if l_first_rec then
13992: if l_first_rec and not l_update then
13993: -- Call Create routine.
13994: hr_utility.set_location(' BEN_EXTRA_INPUT_VALUES CREATE_EXTRA_INPUT_VALUE ',20);
13995: BEN_EXTRA_INPUT_VALUE_API.CREATE_EXTRA_INPUT_VALUE(
13996: --
13997: P_VALIDATE => false
13998: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

Line 14058: hr_utility.set_location(' BEN_EXTRA_INPUT_VALUES UPDATE_EXTRA_INPUT_VALUE ',20);

14054: ben_pd_copy_to_ben_one.g_count := ben_pd_copy_to_ben_one.g_count + 1 ;
14055: --
14056: elsif l_update then
14057: --
14058: hr_utility.set_location(' BEN_EXTRA_INPUT_VALUES UPDATE_EXTRA_INPUT_VALUE ',20);
14059: BEN_EXTRA_INPUT_VALUE_API.UPDATE_EXTRA_INPUT_VALUE(
14060: --
14061: P_VALIDATE => false
14062: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)