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_PLAN_TYPE_OPTION_TYPE_API dependencies on BEN_PL_TYP_OPT_TYP_F

Line 60: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%TYPE;

56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%TYPE;
61: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_plan_type_option_type';
64: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;

Line 61: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;

57: --
58: -- Declare cursors and local variables
59: --
60: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%TYPE;
61: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_plan_type_option_type';
64: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
65: --

Line 62: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;

58: -- Declare cursors and local variables
59: --
60: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%TYPE;
61: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_plan_type_option_type';
64: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
65: --
66:

Line 64: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;

60: l_pl_typ_opt_typ_id ben_pl_typ_opt_typ_f.pl_typ_opt_typ_id%TYPE;
61: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_plan_type_option_type';
64: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
65: --
66:
67: -- to find the cwb plan type for updating the group plan
68:

Line 397: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;

393: --
394: -- Declare cursors and local variables
395: --
396: l_proc varchar2(72) := g_package||'update_plan_type_option_type';
397: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
398: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
399: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
400: -- to find the cwb plan type for updating the group plan
401:

Line 398: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;

394: -- Declare cursors and local variables
395: --
396: l_proc varchar2(72) := g_package||'update_plan_type_option_type';
397: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
398: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
399: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
400: -- to find the cwb plan type for updating the group plan
401:
402: cursor c_opt is

Line 399: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;

395: --
396: l_proc varchar2(72) := g_package||'update_plan_type_option_type';
397: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
398: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
399: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
400: -- to find the cwb plan type for updating the group plan
401:
402: cursor c_opt is
403: select opt.Group_opt_id ,

Line 695: from ben_pl_typ_opt_typ_f pon, ben_opt_f opt

691: -- Declare cursors and local variables
692: --
693: cursor c1 is
694: select opt.opt_id, opt.object_version_number
695: from ben_pl_typ_opt_typ_f pon, ben_opt_f opt
696: where pon.opt_id = opt.opt_id
697: and pon.pl_typ_opt_typ_id = p_pl_typ_opt_typ_id
698: and p_effective_date between pon.effective_start_date and pon.effective_end_date
699: and p_effective_date between opt.effective_start_date and opt.effective_end_date;

Line 703: from ben_pl_typ_opt_typ_f

699: and p_effective_date between opt.effective_start_date and opt.effective_end_date;
700: --
701: cursor c2 (p_opt_id in number) is
702: select count(*)
703: from ben_pl_typ_opt_typ_f
704: where pl_typ_opt_typ_cd = 'CWB'
705: and opt_id = p_opt_id
706: and p_effective_date between effective_start_date and effective_end_date;
707: --

Line 713: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;

709: l_count_cwb_pl_typ number;
710: l_opt_OVN number;
711: --
712: l_proc varchar2(72) := g_package||'update_plan_type_option_type';
713: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
714: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
715: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
716: --
717: begin

Line 714: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;

710: l_opt_OVN number;
711: --
712: l_proc varchar2(72) := g_package||'update_plan_type_option_type';
713: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
714: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
715: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
716: --
717: begin
718: --

Line 715: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;

711: --
712: l_proc varchar2(72) := g_package||'update_plan_type_option_type';
713: l_object_version_number ben_pl_typ_opt_typ_f.object_version_number%TYPE;
714: l_effective_start_date ben_pl_typ_opt_typ_f.effective_start_date%TYPE;
715: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
716: --
717: begin
718: --
719: hr_utility.set_location('Entering:'|| l_proc, 10);