eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ACTY_VRBL_RATE_API dependencies on BEN_ACTY_VRBL_RT_F

Line 72: l_acty_vrbl_rt_id ben_acty_vrbl_rt_f.acty_vrbl_rt_id%TYPE;

68: where oipl.opt_id = p_opt_id ;
69: --
70: -- End Option Level Rates
71: --
72: l_acty_vrbl_rt_id ben_acty_vrbl_rt_f.acty_vrbl_rt_id%TYPE;
73: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
74: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
75: l_proc varchar2(72) := g_package||'create_acty_vrbl_rate';
76: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;

Line 73: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;

69: --
70: -- End Option Level Rates
71: --
72: l_acty_vrbl_rt_id ben_acty_vrbl_rt_f.acty_vrbl_rt_id%TYPE;
73: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
74: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
75: l_proc varchar2(72) := g_package||'create_acty_vrbl_rate';
76: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
77: --

Line 74: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;

70: -- End Option Level Rates
71: --
72: l_acty_vrbl_rt_id ben_acty_vrbl_rt_f.acty_vrbl_rt_id%TYPE;
73: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
74: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
75: l_proc varchar2(72) := g_package||'create_acty_vrbl_rate';
76: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
77: --
78: begin

Line 76: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;

72: l_acty_vrbl_rt_id ben_acty_vrbl_rt_f.acty_vrbl_rt_id%TYPE;
73: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
74: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
75: l_proc varchar2(72) := g_package||'create_acty_vrbl_rate';
76: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
77: --
78: begin
79: --
80: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 374: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;

370: --
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_acty_vrbl_rate';
374: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
375: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
377: --
378: begin

Line 375: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;

371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_acty_vrbl_rate';
374: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
375: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
377: --
378: begin
379: --

Line 376: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;

372: --
373: l_proc varchar2(72) := g_package||'update_acty_vrbl_rate';
374: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
375: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
377: --
378: begin
379: --
380: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 615: from ben_acty_base_rt_f abr, ben_acty_vrbl_rt_f avr

611: ) is
612: --
613: -- Declare cursors and local variables
614: cursor c1 is select pgm_id,pl_id,ptip_id,plip_id,oipl_id,opt_id
615: from ben_acty_base_rt_f abr, ben_acty_vrbl_rt_f avr
616: where abr.acty_base_rt_id = avr.acty_base_rt_id and
617: avr.acty_vrbl_rt_id = p_acty_vrbl_rt_id;
618:
619: --

Line 637: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;

633: --
634: -- End Option Level Rates
635: --
636: l_proc varchar2(72) := g_package||'update_acty_vrbl_rate';
637: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
638: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
639: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
640: --
641: begin

Line 638: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;

634: -- End Option Level Rates
635: --
636: l_proc varchar2(72) := g_package||'update_acty_vrbl_rate';
637: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
638: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
639: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
640: --
641: begin
642: --

Line 639: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;

635: --
636: l_proc varchar2(72) := g_package||'update_acty_vrbl_rate';
637: l_object_version_number ben_acty_vrbl_rt_f.object_version_number%TYPE;
638: l_effective_start_date ben_acty_vrbl_rt_f.effective_start_date%TYPE;
639: l_effective_end_date ben_acty_vrbl_rt_f.effective_end_date%TYPE;
640: --
641: begin
642: --
643: hr_utility.set_location('Entering:'|| l_proc, 10);