APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_CWB_WKSHT_GRP

Line 22294: l_WKSHT_GRP_CD ben_cwb_wksht_grp.wksht_grp_cd%type;

22290: ,p_prefix_suffix_cd in varchar2 default null
22291: ) is
22292: --
22293: l_PL_ID number;
22294: l_WKSHT_GRP_CD ben_cwb_wksht_grp.wksht_grp_cd%type;
22295: cursor c_unique_CWG(l_table_alias varchar2) is
22296: select distinct cpe.information1,
22297: cpe.information2,
22298: cpe.information3,

Line 22304: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP

22300: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22301: pqh_table_route tr
22302: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22303: and cpe.table_route_id = tr.table_route_id
22304: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP
22305: and tr.table_alias = l_table_alias
22306: and cpe.number_of_copies = 1 -- ADDITION
22307: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
22308: order by information1, information2; --added for bug: 5151945

Line 22340: from BEN_CWB_WKSHT_GRP CWG

22336: c_business_group_id number,
22337: c_new_pk_id number) is
22338: select
22339: CWG.cwb_wksht_grp_id new_value
22340: from BEN_CWB_WKSHT_GRP CWG
22341: where
22342: CWG.PL_ID = l_PL_ID and
22343: CWG.WKSHT_GRP_CD = l_WKSHT_GRP_CD and
22344: CWG.business_group_id = c_business_group_id

Line 22500: hr_utility.set_location(' BEN_CWB_WKSHT_GRP CREATE_CWB_WKSHT_GRP ',20);

22496: end if;
22497: --
22498: if l_first_rec and not l_update then
22499: -- Call Create routine.
22500: hr_utility.set_location(' BEN_CWB_WKSHT_GRP CREATE_CWB_WKSHT_GRP ',20);
22501: BEN_CWB_WKSHT_GRP_API.CREATE_CWB_WKSHT_GRP(
22502: --
22503: P_VALIDATE => false
22504: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 22501: BEN_CWB_WKSHT_GRP_API.CREATE_CWB_WKSHT_GRP(

22497: --
22498: if l_first_rec and not l_update then
22499: -- Call Create routine.
22500: hr_utility.set_location(' BEN_CWB_WKSHT_GRP CREATE_CWB_WKSHT_GRP ',20);
22501: BEN_CWB_WKSHT_GRP_API.CREATE_CWB_WKSHT_GRP(
22502: --
22503: P_VALIDATE => false
22504: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
22505: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 22564: BEN_CWB_WKSHT_GRP_API.UPDATE_CWB_WKSHT_GRP(

22560: --
22561: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
22562: --
22563: elsif l_update then
22564: BEN_CWB_WKSHT_GRP_API.UPDATE_CWB_WKSHT_GRP(
22565: --
22566: P_VALIDATE => false
22567: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
22568: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 22702: l_fk_cwb_wksht_grp_id ben_cwb_wksht_grp.cwb_wksht_grp_id%type;

22698:
22699: l_object_version_number number ;
22700: l_object_found_in_target boolean := false ;
22701: l_custom_key ben_custom_region_items.custom_key%type;
22702: l_fk_cwb_wksht_grp_id ben_cwb_wksht_grp.cwb_wksht_grp_id%type;
22703: --
22704: begin
22705:
22706: for r_CRI_unique in c_unique_CRI('CRI') loop