APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_CWB_WKSHT_GRP

Line 22207: l_WKSHT_GRP_CD ben_cwb_wksht_grp.wksht_grp_cd%type;

22203: ,p_prefix_suffix_cd in varchar2 default null
22204: ) is
22205: --
22206: l_PL_ID number;
22207: l_WKSHT_GRP_CD ben_cwb_wksht_grp.wksht_grp_cd%type;
22208: cursor c_unique_CWG(l_table_alias varchar2) is
22209: select distinct cpe.information1,
22210: cpe.information2,
22211: cpe.information3,

Line 22217: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP

22213: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22214: pqh_table_route tr
22215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22216: and cpe.table_route_id = tr.table_route_id
22217: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP
22218: and tr.table_alias = l_table_alias
22219: and cpe.number_of_copies = 1 -- ADDITION
22220: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
22221: order by information1, information2; --added for bug: 5151945

Line 22253: from BEN_CWB_WKSHT_GRP CWG

22249: c_business_group_id number,
22250: c_new_pk_id number) is
22251: select
22252: CWG.cwb_wksht_grp_id new_value
22253: from BEN_CWB_WKSHT_GRP CWG
22254: where
22255: CWG.PL_ID = l_PL_ID and
22256: CWG.WKSHT_GRP_CD = l_WKSHT_GRP_CD and
22257: CWG.business_group_id = c_business_group_id

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

22409: end if;
22410: --
22411: if l_first_rec and not l_update then
22412: -- Call Create routine.
22413: hr_utility.set_location(' BEN_CWB_WKSHT_GRP CREATE_CWB_WKSHT_GRP ',20);
22414: BEN_CWB_WKSHT_GRP_API.CREATE_CWB_WKSHT_GRP(
22415: --
22416: P_VALIDATE => false
22417: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 22414: BEN_CWB_WKSHT_GRP_API.CREATE_CWB_WKSHT_GRP(

22410: --
22411: if l_first_rec and not l_update then
22412: -- Call Create routine.
22413: hr_utility.set_location(' BEN_CWB_WKSHT_GRP CREATE_CWB_WKSHT_GRP ',20);
22414: BEN_CWB_WKSHT_GRP_API.CREATE_CWB_WKSHT_GRP(
22415: --
22416: P_VALIDATE => false
22417: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
22418: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 22477: BEN_CWB_WKSHT_GRP_API.UPDATE_CWB_WKSHT_GRP(

22473: --
22474: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
22475: --
22476: elsif l_update then
22477: BEN_CWB_WKSHT_GRP_API.UPDATE_CWB_WKSHT_GRP(
22478: --
22479: P_VALIDATE => false
22480: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)
22481: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 22615: l_fk_cwb_wksht_grp_id ben_cwb_wksht_grp.cwb_wksht_grp_id%type;

22611:
22612: l_object_version_number number ;
22613: l_object_found_in_target boolean := false ;
22614: l_custom_key ben_custom_region_items.custom_key%type;
22615: l_fk_cwb_wksht_grp_id ben_cwb_wksht_grp.cwb_wksht_grp_id%type;
22616: --
22617: begin
22618:
22619: for r_CRI_unique in c_unique_CRI('CRI') loop