APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_WTHN_YR_PERD

Line 14225: -- and tr.where_clause = l_BEN_WTHN_YR_PERD

14221: from ben_copy_entity_results cpe,
14222: pqh_table_route tr
14223: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14224: and cpe.table_route_id = tr.table_route_id
14225: -- and tr.where_clause = l_BEN_WTHN_YR_PERD
14226: and tr.table_alias = l_table_alias
14227: and cpe.number_of_copies = 1 --ADDITION
14228: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14229: order by information1, information2; --added for bug: 5151945

Line 14263: from BEN_WTHN_YR_PERD WYP

14259: c_effective_end_date date,
14260: c_business_group_id number,
14261: c_new_pk_id number) is
14262: select WYP.wthn_yr_perd_id new_value
14263: from BEN_WTHN_YR_PERD WYP
14264: where WYP.business_group_id = c_business_group_id
14265: and WYP.strt_day = r_WYP.information293
14266: and WYP.strt_mo = r_WYP.information295
14267: and WYP.end_day = r_WYP.information294

Line 14406: hr_utility.set_location(' BEN_WTHN_YR_PERD CREATE_WITHIN_YEAR_PERD ',20);

14402: end if ;
14403: --
14404: if l_first_rec and not l_update then
14405: -- Call Create routine.
14406: hr_utility.set_location(' BEN_WTHN_YR_PERD CREATE_WITHIN_YEAR_PERD ',20);
14407: BEN_WITHIN_YEAR_PERD_API.CREATE_WITHIN_YEAR_PERD(
14408: --
14409: P_VALIDATE => false
14410: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)

Line 14471: hr_utility.set_location(' BEN_WTHN_YR_PERD UPDATE_WITHIN_YEAR_PERD ',20);

14467: g_count := g_count + 1 ;
14468: --
14469: elsif l_update then
14470:
14471: hr_utility.set_location(' BEN_WTHN_YR_PERD UPDATE_WITHIN_YEAR_PERD ',20);
14472: BEN_WITHIN_YEAR_PERD_API.UPDATE_WITHIN_YEAR_PERD(
14473: --
14474: P_VALIDATE => false
14475: ,P_EFFECTIVE_DATE => NVL(ben_pd_copy_to_ben_one.g_copy_effective_date ,p_effective_date)