54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_actl_prem_vrbl_rt_id ben_actl_prem_vrbl_rt_f.actl_prem_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_actual_premium_rate';
62: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
55: --
56: -- Declare cursors and local variables
57: --
58: l_actl_prem_vrbl_rt_id ben_actl_prem_vrbl_rt_f.actl_prem_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_actual_premium_rate';
62: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
63: --
56: -- Declare cursors and local variables
57: --
58: l_actl_prem_vrbl_rt_id ben_actl_prem_vrbl_rt_f.actl_prem_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_actual_premium_rate';
62: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
63: --
64: cursor c1 is
58: l_actl_prem_vrbl_rt_id ben_actl_prem_vrbl_rt_f.actl_prem_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_actual_premium_rate';
62: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
63: --
64: cursor c1 is
65: select pl_id,
66: oipl_id
353: --
354: -- Declare cursors and local variables
355: --
356: l_proc varchar2(72) := g_package||'update_actual_premium_rate';
357: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
358: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
359: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
360: l_in_object_version_number number := p_object_version_number ;
361: --
354: -- Declare cursors and local variables
355: --
356: l_proc varchar2(72) := g_package||'update_actual_premium_rate';
357: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
358: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
359: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
360: l_in_object_version_number number := p_object_version_number ;
361: --
362: begin
355: --
356: l_proc varchar2(72) := g_package||'update_actual_premium_rate';
357: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
358: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
359: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
360: l_in_object_version_number number := p_object_version_number ;
361: --
362: begin
363: --
593: --
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_actual_premium_rate';
597: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
600: l_in_object_version_number number := p_object_version_number ;
601: --
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_actual_premium_rate';
597: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
600: l_in_object_version_number number := p_object_version_number ;
601: --
602: cursor c1 is
595: --
596: l_proc varchar2(72) := g_package||'update_actual_premium_rate';
597: l_object_version_number ben_actl_prem_vrbl_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_actl_prem_vrbl_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_actl_prem_vrbl_rt_f.effective_end_date%TYPE;
600: l_in_object_version_number number := p_object_version_number ;
601: --
602: cursor c1 is
603: select pl_id,
602: cursor c1 is
603: select pl_id,
604: oipl_id
605: from ben_actl_prem_f apr,
606: ben_actl_prem_vrbl_rt_f apv
607: where apr.actl_prem_id = apv.actl_prem_id
608: and apv.actl_prem_vrbl_rt_id = p_actl_prem_vrbl_rt_id;
609: --
610: l_c1 c1%rowtype;