APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_YR_PERD

Line 13885: -- and tr.where_clause = l_BEN_YR_PERD

13881: from ben_copy_entity_results cpe,
13882: pqh_table_route tr
13883: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13884: and cpe.table_route_id = tr.table_route_id
13885: -- and tr.where_clause = l_BEN_YR_PERD
13886: and tr.table_alias = l_table_alias
13887: and cpe.number_of_copies = 1 --ADDITION
13888: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13889: order by information1, information2; --added for bug: 5151945

Line 13920: from BEN_YR_PERD YRP

13916: c_business_group_id number,
13917: c_new_pk_id number) is
13918: select
13919: YRP.yr_perd_id new_value
13920: from BEN_YR_PERD YRP
13921: where
13922: YRP.business_group_id = c_business_group_id
13923: and YRP.start_date = c_start_date
13924: and YRP.end_date = c_end_date

Line 14072: hr_utility.set_location(' BEN_YR_PERD CREATE_PGM_OR_PL_YR_PERD ',20);

14068: end if ;
14069: --
14070: if l_first_rec and not l_update then
14071: -- Call Create routine.
14072: hr_utility.set_location(' BEN_YR_PERD CREATE_PGM_OR_PL_YR_PERD ',20);
14073: BEN_PGM_OR_PL_YR_PERD_API.CREATE_PGM_OR_PL_YR_PERD(
14074: --
14075: P_VALIDATE => false
14076: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 14138: hr_utility.set_location(' BEN_YR_PERD UPDATE_PGM_OR_PL_YR_PERD ',20);

14134: g_count := g_count + 1 ;
14135: --
14136: elsif l_update then
14137:
14138: hr_utility.set_location(' BEN_YR_PERD UPDATE_PGM_OR_PL_YR_PERD ',20);
14139: BEN_PGM_OR_PL_YR_PERD_API.UPDATE_PGM_OR_PL_YR_PERD(
14140: --
14141: P_VALIDATE => false
14142: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)