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 16071: , ben_popl_yr_perd byrp

16067: , yrp2.start_date
16068: , yrp2.end_date
16069: FROM ben_yr_perd yrp1
16070: , ben_yr_perd yrp2
16071: , ben_popl_yr_perd byrp
16072: WHERE yrp1.yr_perd_id = p_yr_perd_id
16073: AND byrp.pl_id = p_pl_id
16074: AND byrp.business_group_id + 0 = p_target_business_group_id
16075: AND yrp1.business_group_id + 0 = p_target_business_group_id

Line 16096: FROM ben_popl_yr_perd cpy

16092:
16093: cursor c_dup_pl_yrp(p_yr_perd_id number,
16094: p_pl_id number) is
16095: SELECT NULL
16096: FROM ben_popl_yr_perd cpy
16097: WHERE cpy.pl_id = p_pl_id
16098: AND cpy.yr_perd_id = p_yr_perd_id
16099: AND cpy.business_group_id + 0 = p_target_business_group_id;
16100:

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

16292:
16293: if not l_skip_pl_yrp then
16294: --End Bug 14490456
16295: -- Call Create routine.
16296: hr_utility.set_location(' BEN_POPL_YR_PERD CREATE_POPL_YR_PERD ',20);
16297: BEN_POPL_YR_PERD_API.CREATE_POPL_YR_PERD(
16298: --
16299: P_VALIDATE => false
16300: --,P_EFFECTIVE_DATE => p_effective_date

Line 16297: BEN_POPL_YR_PERD_API.CREATE_POPL_YR_PERD(

16293: if not l_skip_pl_yrp then
16294: --End Bug 14490456
16295: -- Call Create routine.
16296: hr_utility.set_location(' BEN_POPL_YR_PERD CREATE_POPL_YR_PERD ',20);
16297: BEN_POPL_YR_PERD_API.CREATE_POPL_YR_PERD(
16298: --
16299: P_VALIDATE => false
16300: --,P_EFFECTIVE_DATE => p_effective_date
16301: ,P_BUSINESS_GROUP_ID => p_target_business_group_id

Line 16360: BEN_POPL_YR_PERD_API.UPDATE_POPL_YR_PERD(

16356: --
16357: BEN_PD_COPY_TO_BEN_ONE.g_count := BEN_PD_COPY_TO_BEN_ONE.g_count + 1 ;
16358: end if;--Bug 14490456
16359: elsif l_update then
16360: BEN_POPL_YR_PERD_API.UPDATE_POPL_YR_PERD(
16361: --
16362: P_VALIDATE => false
16363: --,P_EFFECTIVE_DATE => p_effective_date
16364: ,P_BUSINESS_GROUP_ID => p_target_business_group_id