APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_POPL_YR_PERD

Line 16018: -- and tr.where_clause = l_BEN_POPL_YR_PERD

16014: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16015: pqh_table_route tr
16016: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16017: and cpe.table_route_id = tr.table_route_id
16018: -- and tr.where_clause = l_BEN_POPL_YR_PERD
16019: and tr.table_alias = l_table_alias
16020: and cpe.number_of_copies = 1 -- ADDITION
16021: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
16022: order by information1, information2; --added for bug: 5151945

Line 16054: from BEN_POPL_YR_PERD CPY

16050: c_business_group_id number,
16051: c_new_pk_id number) is
16052: select
16053: CPY.popl_yr_perd_id new_value
16054: from BEN_POPL_YR_PERD CPY
16055: where
16056: nvl(CPY.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
16057: nvl(CPY.PL_ID,-999) = nvl(l_PL_ID,-999) and
16058: CPY.YR_PERD_ID = l_YR_PERD_ID and

Line 16210: hr_utility.set_location(' BEN_POPL_YR_PERD CREATE_POPL_YR_PERD ',20);

16206: end if;
16207: --
16208: if l_first_rec and not l_update then
16209: -- Call Create routine.
16210: hr_utility.set_location(' BEN_POPL_YR_PERD CREATE_POPL_YR_PERD ',20);
16211: BEN_POPL_YR_PERD_API.CREATE_POPL_YR_PERD(
16212: --
16213: P_VALIDATE => false
16214: --,P_EFFECTIVE_DATE => p_effective_date

Line 16211: BEN_POPL_YR_PERD_API.CREATE_POPL_YR_PERD(

16207: --
16208: if l_first_rec and not l_update then
16209: -- Call Create routine.
16210: hr_utility.set_location(' BEN_POPL_YR_PERD CREATE_POPL_YR_PERD ',20);
16211: BEN_POPL_YR_PERD_API.CREATE_POPL_YR_PERD(
16212: --
16213: P_VALIDATE => false
16214: --,P_EFFECTIVE_DATE => p_effective_date
16215: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 16273: BEN_POPL_YR_PERD_API.UPDATE_POPL_YR_PERD(

16269: -- update_cer_with_target( BEN_PD_COPY_TO_BEN_ONE.g_pk_tbl(BEN_PD_COPY_TO_BEN_ONE.g_count),p_copy_entity_txn_id ) ;
16270: --
16271: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
16272: elsif l_update then
16273: BEN_POPL_YR_PERD_API.UPDATE_POPL_YR_PERD(
16274: --
16275: P_VALIDATE => false
16276: --,P_EFFECTIVE_DATE => p_effective_date
16277: ,P_BUSINESS_GROUP_ID => p_target_business_group_id