DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_PCT_FL_TM_FCTR

Line 5527: -- and tr.where_clause = l_BEN_PCT_FL_TM_FCTR

5523: from ben_copy_entity_results cpe,
5524: pqh_table_route tr
5525: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5526: and cpe.table_route_id = tr.table_route_id
5527: -- and tr.where_clause = l_BEN_PCT_FL_TM_FCTR
5528: and tr.table_alias = l_table_alias
5529: and cpe.number_of_copies = 1 --ADDITION
5530: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION218, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5531: order by information1, information2; --added for bug: 5151945

Line 5563: from BEN_PCT_FL_TM_FCTR PFF

5559: c_business_group_id number,
5560: c_new_pk_id number) is
5561: select
5562: PFF.pct_fl_tm_fctr_id new_value
5563: from BEN_PCT_FL_TM_FCTR PFF
5564: where PFF.name = c_PFF_name
5565: and PFF.business_group_id = c_business_group_id
5566: and PFF.pct_fl_tm_fctr_id <> c_new_pk_id
5567: ;

Line 5706: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PCT_FL_TM_FCTR',l_prefix || r_PFF.INFORMATION218 || l_suffix);

5702: end if ;
5703: --
5704: l_RNDG_RL := get_fk('FORMULA_ID', r_PFF.INFORMATION257,l_dml_operation);
5705: --
5706: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PCT_FL_TM_FCTR',l_prefix || r_PFF.INFORMATION218 || l_suffix);
5707: --
5708: if l_first_rec and not l_update then
5709: -- Call Create routine.
5710: hr_utility.set_location(' BEN_PCT_FL_TM_FCTR CREATE_PERCENT_FT_FACTORS ',20);

Line 5710: hr_utility.set_location(' BEN_PCT_FL_TM_FCTR CREATE_PERCENT_FT_FACTORS ',20);

5706: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_PCT_FL_TM_FCTR',l_prefix || r_PFF.INFORMATION218 || l_suffix);
5707: --
5708: if l_first_rec and not l_update then
5709: -- Call Create routine.
5710: hr_utility.set_location(' BEN_PCT_FL_TM_FCTR CREATE_PERCENT_FT_FACTORS ',20);
5711: BEN_PERCENT_FT_FACTORS_API.CREATE_PERCENT_FT_FACTORS(
5712: --
5713: P_VALIDATE => false
5714: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 5780: hr_utility.set_location(' BEN_PCT_FL_TM_FCTR UPDATE_PERCENT_FT_FACTORS ',20);

5776: log_data('PFF',l_new_value,l_prefix || r_PFF.INFORMATION218 || l_suffix,'COPIED');
5777: --
5778: elsif l_update then
5779: --
5780: hr_utility.set_location(' BEN_PCT_FL_TM_FCTR UPDATE_PERCENT_FT_FACTORS ',20);
5781: BEN_PERCENT_FT_FACTORS_API.UPDATE_PERCENT_FT_FACTORS(
5782: --
5783: P_VALIDATE => false
5784: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)