DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_HRS_WKD_IN_PERD_FCTR

Line 4380: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_FCTR

4376: from ben_copy_entity_results cpe,
4377: pqh_table_route tr
4378: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4379: and cpe.table_route_id = tr.table_route_id
4380: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_FCTR
4381: and tr.table_alias = l_table_alias
4382: and cpe.number_of_copies = 1 --ADDITION
4383: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4384: order by information1, information2; --added for bug: 5151945

Line 4416: from BEN_HRS_WKD_IN_PERD_FCTR HWF

4412: c_business_group_id number,
4413: c_new_pk_id number) is
4414: select
4415: HWF.hrs_wkd_in_perd_fctr_id new_value
4416: from BEN_HRS_WKD_IN_PERD_FCTR HWF
4417: where HWF.name = c_HWF_name
4418: and HWF.business_group_id = c_business_group_id
4419: and HWF.hrs_wkd_in_perd_fctr_id <> c_new_pk_id
4420: ;

Line 4601: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_HRS_WKD_IN_PERD_FCTR' ,l_prefix || r_HWF.INFORMATION170 || l_suffix);

4597: else
4598: l_DEFINED_BALANCE_ID := r_HWF.information174;
4599: end if;
4600: --
4601: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_HRS_WKD_IN_PERD_FCTR' ,l_prefix || r_HWF.INFORMATION170 || l_suffix);
4602: --
4603:
4604: l_parent_effective_start_date := r_HWF.information10;
4605: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null ) then

Line 4621: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_FCTR CREATE_HRS_WKD_IN_PERD_FCTR ',20);

4617: end if;
4618: --
4619: if l_first_rec and not l_update then
4620: -- Call Create routine.
4621: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_FCTR CREATE_HRS_WKD_IN_PERD_FCTR ',20);
4622: BEN_HRS_WKD_IN_PERD_FCTR_API.CREATE_HRS_WKD_IN_PERD_FCTR(
4623: --
4624: P_VALIDATE => false
4625: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)

Line 4622: BEN_HRS_WKD_IN_PERD_FCTR_API.CREATE_HRS_WKD_IN_PERD_FCTR(

4618: --
4619: if l_first_rec and not l_update then
4620: -- Call Create routine.
4621: hr_utility.set_location(' BEN_HRS_WKD_IN_PERD_FCTR CREATE_HRS_WKD_IN_PERD_FCTR ',20);
4622: BEN_HRS_WKD_IN_PERD_FCTR_API.CREATE_HRS_WKD_IN_PERD_FCTR(
4623: --
4624: P_VALIDATE => false
4625: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)
4626: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 4698: BEN_HRS_WKD_IN_PERD_FCTR_API.UPDATE_HRS_WKD_IN_PERD_FCTR(

4694: log_data('HWF',l_new_value,l_prefix || r_HWF.INFORMATION170 || l_suffix,'COPIED');
4695: --
4696: ELSIF l_update THEN
4697: --
4698: BEN_HRS_WKD_IN_PERD_FCTR_API.UPDATE_HRS_WKD_IN_PERD_FCTR(
4699: --
4700: P_VALIDATE => false
4701: ,P_EFFECTIVE_DATE => NVL(l_parent_effective_start_date,p_effective_date)
4702: ,P_BUSINESS_GROUP_ID => p_target_business_group_id