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_IN_PROGRAM_API dependencies on BEN_PTIP_F

Line 130: ben_ptip_f ptip,

126: ptip.ptip_id,
127: oipl.opt_id
128: from
129: ben_oipl_f oipl,
130: ben_ptip_f ptip,
131: ben_plip_f plip,
132: ben_pl_f pl
133: where
134: ptip.ptip_id = p_otp_ptip_id

Line 149: l_ptip_id ben_ptip_f.ptip_id%TYPE;

145: and p_effective_date between pl.effective_start_date and pl.effective_end_date
146: and p_effective_date between ptip.effective_start_date and ptip.effective_end_date
147: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
148:
149: l_ptip_id ben_ptip_f.ptip_id%TYPE;
150: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
151: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
152: l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;

Line 150: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;

146: and p_effective_date between ptip.effective_start_date and ptip.effective_end_date
147: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
148:
149: l_ptip_id ben_ptip_f.ptip_id%TYPE;
150: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
151: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
152: l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;
154: --

Line 151: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;

147: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
148:
149: l_ptip_id ben_ptip_f.ptip_id%TYPE;
150: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
151: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
152: l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;
154: --
155: -- ben_optip_f

Line 153: l_object_version_number ben_ptip_f.object_version_number%TYPE;

149: l_ptip_id ben_ptip_f.ptip_id%TYPE;
150: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
151: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
152: l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;
154: --
155: -- ben_optip_f
156: l_optip_id ben_optip_f.optip_id%type;
157: l_otp_effective_start_date ben_optip_f.effective_start_date%type;

Line 715: l_object_version_number ben_ptip_f.object_version_number%TYPE;

711: --
712: -- Declare cursors and local variables
713: --
714: l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
715: l_object_version_number ben_ptip_f.object_version_number%TYPE;
716: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
717: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
718: --
719: begin

Line 716: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;

712: -- Declare cursors and local variables
713: --
714: l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
715: l_object_version_number ben_ptip_f.object_version_number%TYPE;
716: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
717: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
718: --
719: begin
720: --

Line 717: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;

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

Line 1146: l_object_version_number ben_ptip_f.object_version_number%TYPE;

1142: --
1143: -- Declare cursors and local variables
1144: --
1145: l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
1146: l_object_version_number ben_ptip_f.object_version_number%TYPE;
1147: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
1148: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
1149: --
1150: begin

Line 1147: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;

1143: -- Declare cursors and local variables
1144: --
1145: l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
1146: l_object_version_number ben_ptip_f.object_version_number%TYPE;
1147: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
1148: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
1149: --
1150: begin
1151: --

Line 1148: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;

1144: --
1145: l_proc varchar2(72) := g_package||'update_Plan_Type_In_Program';
1146: l_object_version_number ben_ptip_f.object_version_number%TYPE;
1147: l_effective_start_date ben_ptip_f.effective_start_date%TYPE;
1148: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
1149: --
1150: begin
1151: --
1152: hr_utility.set_location('Entering:'|| l_proc, 10);