APPS.PQH_GSP_DEL_GRADE_LADDER_OBJ dependencies on BEN_OIPL_F

Line 141: From Ben_oipl_F

137: Cursor csr_ben_oipl (p_oipl_id in Number) Is
138: Select oipl_id,
139: Effective_Start_Date, Effective_End_Date,
140: Object_version_number
141: From Ben_oipl_F
142: Where oipl_id = p_oipl_id
143: and p_effective_date
144: between Effective_Start_Date and Effective_End_Date;
145: --

Line 146: l_oipl_start_date ben_oipl_f.effective_start_date%type;

142: Where oipl_id = p_oipl_id
143: and p_effective_date
144: between Effective_Start_Date and Effective_End_Date;
145: --
146: l_oipl_start_date ben_oipl_f.effective_start_date%type;
147: l_oipl_end_date ben_oipl_f.effective_end_date%type;
148: l_oipl_id ben_oipl_f.oipl_id%type;
149: l_oipl_ovn ben_oipl_f.object_version_number%type;
150: --

Line 147: l_oipl_end_date ben_oipl_f.effective_end_date%type;

143: and p_effective_date
144: between Effective_Start_Date and Effective_End_Date;
145: --
146: l_oipl_start_date ben_oipl_f.effective_start_date%type;
147: l_oipl_end_date ben_oipl_f.effective_end_date%type;
148: l_oipl_id ben_oipl_f.oipl_id%type;
149: l_oipl_ovn ben_oipl_f.object_version_number%type;
150: --
151: l_eot date;

Line 148: l_oipl_id ben_oipl_f.oipl_id%type;

144: between Effective_Start_Date and Effective_End_Date;
145: --
146: l_oipl_start_date ben_oipl_f.effective_start_date%type;
147: l_oipl_end_date ben_oipl_f.effective_end_date%type;
148: l_oipl_id ben_oipl_f.oipl_id%type;
149: l_oipl_ovn ben_oipl_f.object_version_number%type;
150: --
151: l_eot date;
152: l_datetrack_mode varchar2(30);

Line 149: l_oipl_ovn ben_oipl_f.object_version_number%type;

145: --
146: l_oipl_start_date ben_oipl_f.effective_start_date%type;
147: l_oipl_end_date ben_oipl_f.effective_end_date%type;
148: l_oipl_id ben_oipl_f.oipl_id%type;
149: l_oipl_ovn ben_oipl_f.object_version_number%type;
150: --
151: l_eot date;
152: l_datetrack_mode varchar2(30);
153: --

Line 514: From Ben_Oipl_F

510: and Pl_Typ_Opt_Typ_Cd = 'GSP';
511:
512: Cursor Csr_OIpl (P_Opt_id IN Number) Is
513: Select Oipl_id
514: From Ben_Oipl_F
515: Where Opt_id = p_Opt_id;
516:
517: --
518: l_opt_start_date ben_opt_f.effective_start_date%type;

Line 522: l_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;

518: l_opt_start_date ben_opt_f.effective_start_date%type;
519: l_opt_end_date ben_opt_f.effective_end_date%type;
520: l_opt_id ben_opt_f.opt_id%type;
521: l_opt_ovn ben_opt_f.object_version_number%type;
522: l_Oipl_Id Ben_Oipl_F.Oipl_Id%TYPE;
523:
524: --
525: --
526: l_Pl_Typ_Opt_Typ_Id Ben_Pl_Typ_Opt_Typ_F.Pl_Typ_Opt_Typ_Id%TYPE;