APPS.BEN_PLAN_IN_PROGRAM_API dependencies on BEN_OIPLIP_F

Line 154: l_oiplip_id ben_oiplip_f.oiplip_id%type;

150: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
151: l_proc varchar2(72) := g_package||'create_Plan_in_Program';
152: l_object_version_number ben_plip_f.object_version_number%TYPE;
153: --
154: l_oiplip_id ben_oiplip_f.oiplip_id%type;
155: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
156: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
157: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
158: --

Line 155: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;

151: l_proc varchar2(72) := g_package||'create_Plan_in_Program';
152: l_object_version_number ben_plip_f.object_version_number%TYPE;
153: --
154: l_oiplip_id ben_oiplip_f.oiplip_id%type;
155: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
156: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
157: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
158: --
159: -- ben_optip_f

Line 156: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;

152: l_object_version_number ben_plip_f.object_version_number%TYPE;
153: --
154: l_oiplip_id ben_oiplip_f.oiplip_id%type;
155: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
156: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
157: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
158: --
159: -- ben_optip_f
160: l_optip_id ben_optip_f.optip_id%type;

Line 157: l_opp_object_version_number ben_oiplip_f.object_version_number%type;

153: --
154: l_oiplip_id ben_oiplip_f.oiplip_id%type;
155: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
156: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
157: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
158: --
159: -- ben_optip_f
160: l_optip_id ben_optip_f.optip_id%type;
161: l_otp_effective_start_date ben_optip_f.effective_start_date%type;

Line 1094: from ben_oiplip_f opp

1090: --
1091:
1092: cursor c_opp is select opp.oiplip_id,
1093: opp.object_version_number
1094: from ben_oiplip_f opp
1095: where opp.plip_id = p_plip_id
1096: and p_effective_date between
1097: opp.effective_start_date and opp.effective_end_date;
1098: --

Line 1104: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;

1100: l_object_version_number ben_plip_f.object_version_number%TYPE;
1101: l_effective_start_date ben_plip_f.effective_start_date%TYPE;
1102: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
1103: --
1104: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
1105: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
1106: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
1107:
1108: --

Line 1105: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;

1101: l_effective_start_date ben_plip_f.effective_start_date%TYPE;
1102: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
1103: --
1104: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
1105: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
1106: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
1107:
1108: --
1109: begin

Line 1106: l_opp_object_version_number ben_oiplip_f.object_version_number%type;

1102: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
1103: --
1104: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
1105: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
1106: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
1107:
1108: --
1109: begin
1110: --