APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 2812: BEN_PER_INFO_CHG_CS_LER_F psl

2808: Begin
2809:
2810: Select psl.Name into l_temp
2811: From
2812: BEN_PER_INFO_CHG_CS_LER_F psl
2813: Where
2814: psl.business_group_id = p_business_group_id
2815: And p_effective_date between psl.effective_start_date and psl.effective_end_date
2816: And psl.Name = l_name ;

Line 2910: BEN_PER_INFO_CHG_CS_LER_F psl

2906: Select
2907: psl.*
2908:
2909: from
2910: BEN_PER_INFO_CHG_CS_LER_F psl
2911: Where
2912: psl.business_group_id = p_business_group_id
2913: And p_effective_date between psl.effective_start_date and psl.effective_end_date
2914: And

Line 3052: BEN_PER_INFO_CHG_CS_LER_F_S.nextVal into

3048:
3049: --dbms_output.put_line('name is '||l_name);
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