54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_bnft_vrbl_rt_id ben_bnft_vrbl_rt_f.bnft_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt';
62: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
55: --
56: -- Declare cursors and local variables
57: --
58: l_bnft_vrbl_rt_id ben_bnft_vrbl_rt_f.bnft_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt';
62: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
63: --
56: -- Declare cursors and local variables
57: --
58: l_bnft_vrbl_rt_id ben_bnft_vrbl_rt_f.bnft_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt';
62: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
63: --
64: cursor c1 is
58: l_bnft_vrbl_rt_id ben_bnft_vrbl_rt_f.bnft_vrbl_rt_id%TYPE;
59: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
60: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_bnft_vrbl_rt';
62: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
63: --
64: cursor c1 is
65: select pl_id,
66: oipl_id,
360: --
361: -- Declare cursors and local variables
362: --
363: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt';
364: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
365: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
366: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
367: --
368: begin
361: -- Declare cursors and local variables
362: --
363: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt';
364: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
365: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
366: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
367: --
368: begin
369: --
362: --
363: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt';
364: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
365: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
366: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
367: --
368: begin
369: --
370: hr_utility.set_location('Entering:'|| l_proc, 10);
600: --
601: -- Declare cursors and local variables
602: --
603: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt';
604: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
605: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
606: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
607: --
608: cursor c1 is
601: -- Declare cursors and local variables
602: --
603: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt';
604: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
605: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
606: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
607: --
608: cursor c1 is
609: select plip_id,
602: --
603: l_proc varchar2(72) := g_package||'update_bnft_vrbl_rt';
604: l_object_version_number ben_bnft_vrbl_rt_f.object_version_number%TYPE;
605: l_effective_start_date ben_bnft_vrbl_rt_f.effective_start_date%TYPE;
606: l_effective_end_date ben_bnft_vrbl_rt_f.effective_end_date%TYPE;
607: --
608: cursor c1 is
609: select plip_id,
610: pl_id,
609: select plip_id,
610: pl_id,
611: oipl_id
612: from ben_cvg_amt_calc_mthd_f ccm,
613: ben_bnft_vrbl_rt_f bvr
614: where ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
615: and bvr.bnft_vrbl_rt_id = p_bnft_vrbl_rt_id;
616: --
617: l_c1 c1%rowtype;