DBA Data[Home] [Help]

APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on DUAL

Line 2708: From dual ;

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: (
2712: p_copy_entity_result_id => l_copy_entity_result_id,

Line 3054: From dual ;

3050: l_per_info_chg_cs_ler_id :=null ;
3051: Select
3052: BEN_PER_INFO_CHG_CS_LER_F_S.nextVal into
3053: l_per_info_chg_cs_ler_id
3054: From dual ;
3055:
3056: -- Get the Name for the Ler Trigger
3057: l_name := chkName(p_effective_date,l_CPE.Information15,p_business_group_id);
3058: