[Home] [Help]
3940: from ben_copy_entity_results cpe
3941: -- pqh_table_route tr UPD
3942: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3943: -- and cpe.table_route_id = tr.table_route_id UPD
3944: -- and tr.where_clause = l_BEN_COMP_LVL_FCTR
3945: and cpe.table_alias = l_table_alias --UPD
3946: and cpe.number_of_copies = 1 --ADDITION
3947: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,
3948: cpe.dml_operation
3977: c_business_group_id number,
3978: c_new_pk_id number) is
3979: select
3980: CLF.comp_lvl_fctr_id new_value
3981: from BEN_COMP_LVL_FCTR CLF
3982: where CLF.name = c_CLF_name
3983: and CLF.business_group_id = c_business_group_id
3984: and CLF.comp_lvl_fctr_id <> c_new_pk_id;
3985: --
4154: l_first_rec := true ;
4155: --
4156: end if ;
4157: --
4158: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_COMP_LVL_FCTR' ,l_prefix || r_CLF.INFORMATION170 || l_suffix);
4159: --
4160:
4161: l_parent_effective_start_date := r_CLF.information10;
4162: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null ) then
4183: --
4184: if l_first_rec and not l_update then
4185: --UPD END
4186: -- Call Create routine.
4187: hr_utility.set_location(' BEN_COMP_LVL_FCTR CREATE_COMP_LEVEL_FACTORS ',20);
4188:
4189: BEN_COMP_LEVEL_FACTORS_API.CREATE_COMP_LEVEL_FACTORS(
4190: --
4191: P_VALIDATE => false
4267: --
4268: --UPD START
4269: elsif l_update THEN
4270: --
4271: hr_utility.set_location(' BEN_COMP_LVL_FCTR UPDATE_COMP_LEVEL_FACTORS ',20);
4272: --
4273: BEN_COMP_LEVEL_FACTORS_API.UPDATE_COMP_LEVEL_FACTORS(
4274: --
4275: P_VALIDATE => false