[Home] [Help]
5159: from ben_copy_entity_results cpe,
5160: pqh_table_route tr
5161: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5162: and cpe.table_route_id = tr.table_route_id
5163: -- and tr.where_clause = l_BEN_LOS_FCTR
5164: and tr.table_alias = l_table_alias
5165: and cpe.number_of_copies = 1 --ADDITION
5166: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5167: order by information1, information2; --added for bug: 5151945
5195: c_business_group_id number,
5196: c_new_pk_id number) is
5197: select
5198: LSF.los_fctr_id new_value
5199: from BEN_LOS_FCTR LSF
5200: where LSF.name = c_LSF_name
5201: and LSF.business_group_id = c_business_group_id
5202: and LSF.los_fctr_id <> c_new_pk_id
5203: ;
5345: l_LOS_DET_RL := get_fk('FORMULA_ID', r_LSF.INFORMATION257,l_dml_operation);
5346: l_LOS_DT_TO_USE_RL := get_fk('FORMULA_ID', r_LSF.INFORMATION258,l_dml_operation);
5347: l_RNDG_RL := get_fk('FORMULA_ID', r_LSF.INFORMATION259,l_dml_operation);
5348: --
5349: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_LOS_FCTR',l_prefix || r_LSF.INFORMATION170 || l_suffix);
5350: --
5351: if l_first_rec and not l_update then
5352: -- Call Create routine.
5353: hr_utility.set_location(' BEN_LOS_FCTR CREATE_LOS_FACTORS ',20);
5349: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_LOS_FCTR',l_prefix || r_LSF.INFORMATION170 || l_suffix);
5350: --
5351: if l_first_rec and not l_update then
5352: -- Call Create routine.
5353: hr_utility.set_location(' BEN_LOS_FCTR CREATE_LOS_FACTORS ',20);
5354: BEN_LOS_FACTORS_API.CREATE_LOS_FACTORS(
5355: --
5356: P_VALIDATE => false
5357: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date,p_effective_date)