APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_POPL_YR_PERD

Line 2651: Ben_Popl_Yr_Perd cpy

2647: max(ordr_num)+10 into l_Sequence_Number
2648:
2649: From
2650:
2651: Ben_Popl_Yr_Perd cpy
2652:
2653: Where
2654: cpy.pl_id = l_PLN.Information1
2655: And cpy.business_group_id = p_business_group_id;

Line 2676: Ben_Popl_Yr_Perd cpy,

2672: 8 into l_pkId
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

Line 2707: Select BEN_POPL_YR_PERD_S.nextval into l_pkId

2703: --
2704: -- If there are No Records for this Year Period in Ben then create a CPY Row for
2705: -- a YRP
2706:
2707: Select BEN_POPL_YR_PERD_S.nextval into l_pkId
2708: From dual ;
2709: -- dbms_output.put_line(' yrp id '||to_char(l_CPY.information1));
2710: ben_copy_entity_results_api.create_copy_entity_results
2711: (