APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_YR_PERD

Line 2677: Ben_Yr_Perd yrp

2673:
2674: From
2675:
2676: Ben_Popl_Yr_Perd cpy,
2677: Ben_Yr_Perd yrp
2678: Where
2679: cpy.pl_id = l_PLN.Information1
2680: And cpy.business_group_id = p_business_group_id
2681: And cpy.business_group_id = yrp.business_group_id

Line 3586: -- START OF BEN_YR_PERD ----------------------

3582: l_proc varchar2(72) := g_package||'.Create_YRP_Result';
3583:
3584:
3585: ---------------------------------------------------------------
3586: -- START OF BEN_YR_PERD ----------------------
3587: ---------------------------------------------------------------
3588:
3589: cursor c_yrp(c_table_alias varchar2) is
3590: select yrp.*

Line 3591: from BEN_YR_PERD yrp

3587: ---------------------------------------------------------------
3588:
3589: cursor c_yrp(c_table_alias varchar2) is
3590: select yrp.*
3591: from BEN_YR_PERD yrp
3592: where
3593:
3594: yrp.business_group_id = p_business_group_id
3595: and not exists (

Line 3622: -- END OF BEN_YR_PERD ----------------------

3618: l_INFORMATION5 Varchar2(500);
3619: l_RESULT_TYPE_CD varchar2(10);
3620:
3621: ---------------------------------------------------------------
3622: -- END OF BEN_YR_PERD ----------------------
3623: ---------------------------------------------------------------
3624:
3625: Begin
3626: hr_utility.set_location('Entering: '||l_proc,10);