APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_VRBL_RT_PRFL_F

Line 5182: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_F

5178: from ben_copy_entity_results cpe,
5179: pqh_table_route tr
5180: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5181: and cpe.table_route_id = tr.table_route_id
5182: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_F
5183: and tr.table_alias = l_table_alias
5184: and cpe.number_of_copies = 1 -- ADDITION
5185: group by cpe.information1,cpe.information2,cpe.information3, cpe.information170 , cpe.table_route_id ,cpe.dml_operation,cpe.datetrack_mode
5186: order by information1, information2; --added for bug: 5151945

Line 5220: from BEN_VRBL_RT_PRFL_F VPF

5216: c_business_group_id number,
5217: c_new_pk_id number) is
5218: select
5219: VPF.vrbl_rt_prfl_id new_value
5220: from BEN_VRBL_RT_PRFL_F VPF
5221: where
5222: VPF.name = l_name and
5223: VPF.business_group_id = c_business_group_id
5224: and VPF.vrbl_rt_prfl_id <> c_new_pk_id

Line 5231: from BEN_VRBL_RT_PRFL_F VPF1

5227: and effective_end_date ;
5228: --END TEMPIK
5229: /*TEMPIK
5230: and exists ( select null
5231: from BEN_VRBL_RT_PRFL_F VPF1
5232: where
5233: VPF1.name = l_name and
5234: VPF1.business_group_id = c_business_group_id
5235: and VPF1.effective_start_date <= c_effective_start_date )

Line 5237: from BEN_VRBL_RT_PRFL_F VPF2

5233: VPF1.name = l_name and
5234: VPF1.business_group_id = c_business_group_id
5235: and VPF1.effective_start_date <= c_effective_start_date )
5236: and exists ( select null
5237: from BEN_VRBL_RT_PRFL_F VPF2
5238: where
5239: VPF2.name = l_name and
5240: VPF2.business_group_id = c_business_group_id
5241: and VPF2.effective_end_date >= c_effective_end_date )

Line 5398: (p_base_table_name => 'BEN_VRBL_RT_PRFL_F',

5394: fetch c_find_VPF_in_target into l_new_value ;
5395: if c_find_VPF_in_target%found then
5396: --TEMPIK
5397: l_dt_rec_found := dt_api.check_min_max_dates
5398: (p_base_table_name => 'BEN_VRBL_RT_PRFL_F',
5399: p_base_key_column => 'VRBL_RT_PRFL_ID',
5400: p_base_key_value => l_new_value,
5401: p_from_date => l_min_esd,
5402: p_to_date => l_max_eed );

Line 5456: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_VRBL_RT_PRFL_F',l_prefix || r_VPF.information170 || l_suffix);

5452: l_first_rec := true ;
5453: --
5454: end if ;
5455: --
5456: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_VRBL_RT_PRFL_F',l_prefix || r_VPF.information170 || l_suffix);
5457: --
5458:
5459: l_effective_date := r_VPF.information2;
5460: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 5470: hr_utility.set_location(' BEN_VRBL_RT_PRFL_F CREATE_VRBL_RATE_PROFILE ',20);

5466: if l_first_rec and not l_update then
5467: -- UPD END
5468:
5469: -- Call Create routine.
5470: hr_utility.set_location(' BEN_VRBL_RT_PRFL_F CREATE_VRBL_RATE_PROFILE ',20);
5471: BEN_VRBL_RATE_PROFILE_API.CREATE_VRBL_RATE_PROFILE(
5472: --
5473: P_VALIDATE => false
5474: ,P_EFFECTIVE_DATE => l_effective_date

Line 5629: hr_utility.set_location(' BEN_VRBL_RT_PRFL_F UPDATE_VRBL_RATE_PROFILE ',30);

5625: else
5626: --
5627: -- Call Update routine for the pk_id created in prev run .
5628: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5629: hr_utility.set_location(' BEN_VRBL_RT_PRFL_F UPDATE_VRBL_RATE_PROFILE ',30);
5630:
5631: --UPD START
5632: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
5633: --