126: l_oiplip_id ben_oiplip_f.oiplip_id%type;
127: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
128: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
129: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
130: -- ben_optip_f
131: l_optip_id ben_optip_f.optip_id%type;
132: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
133: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
134: l_otp_object_version_number ben_optip_f.object_version_number%type;
127: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
128: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
129: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
130: -- ben_optip_f
131: l_optip_id ben_optip_f.optip_id%type;
132: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
133: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
134: l_otp_object_version_number ben_optip_f.object_version_number%type;
135: --
128: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
129: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
130: -- ben_optip_f
131: l_optip_id ben_optip_f.optip_id%type;
132: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
133: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
134: l_otp_object_version_number ben_optip_f.object_version_number%type;
135: --
136: begin
129: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
130: -- ben_optip_f
131: l_optip_id ben_optip_f.optip_id%type;
132: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
133: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
134: l_otp_object_version_number ben_optip_f.object_version_number%type;
135: --
136: begin
137: --
130: -- ben_optip_f
131: l_optip_id ben_optip_f.optip_id%type;
132: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
133: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
134: l_otp_object_version_number ben_optip_f.object_version_number%type;
135: --
136: begin
137: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);
948: select
949: otp.optip_id,
950: otp.object_version_number
951: from
952: ben_optip_f otp
953: where
954: otp.pgm_id = p_pgm_id
955: and otp.pl_typ_id = p_pl_typ_id
956: and otp.opt_id = p_opt_id
983: l_opp_effective_start_date ben_oiplip_f.effective_start_date%type;
984: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
985: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
986: --
987: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
988: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
989: l_otp_object_version_number ben_optip_f.object_version_number%type;
990: --
991:
984: l_opp_effective_end_date ben_oiplip_f.effective_end_date%type;
985: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
986: --
987: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
988: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
989: l_otp_object_version_number ben_optip_f.object_version_number%type;
990: --
991:
992: begin
985: l_opp_object_version_number ben_oiplip_f.object_version_number%type;
986: --
987: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
988: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
989: l_otp_object_version_number ben_optip_f.object_version_number%type;
990: --
991:
992: begin
993: --