APPS.BEN_PLAN_IN_PROGRAM_API dependencies on BEN_OIPLIP_F

Line 155: l_oiplip_id ben_oiplip_f.oiplip_id%type;

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

Line 156: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;

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

Line 157: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;

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

Line 158: l_opp_object_version_number ben_oiplip_f.object_version_number%type;

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

Line 1102: from ben_oiplip_f opp

1098: --
1099:
1100: cursor c_opp is select opp.oiplip_id,
1101: opp.object_version_number
1102: from ben_oiplip_f opp
1103: where opp.plip_id = p_plip_id
1104: and p_effective_date between
1105: opp.effective_start_date and opp.effective_end_date;
1106: --

Line 1112: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;

1108: l_object_version_number ben_plip_f.object_version_number%TYPE;
1109: l_effective_start_date ben_plip_f.effective_start_date%TYPE;
1110: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
1111: --
1112: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
1113: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
1114: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
1115:
1116: --

Line 1113: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;

1109: l_effective_start_date ben_plip_f.effective_start_date%TYPE;
1110: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
1111: --
1112: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
1113: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
1114: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
1115:
1116: --
1117: begin

Line 1114: l_opp_object_version_number ben_oiplip_f.object_version_number%type;

1110: l_effective_end_date ben_plip_f.effective_end_date%TYPE;
1111: --
1112: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
1113: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
1114: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
1115:
1116: --
1117: begin
1118: --