[Home] [Help]
173:
174: cursor c_opt_name
175: is
176: select name
177: from ben_opt_f opt
178: where opt_id=p_opt_id
179: and p_effective_Date between effective_start_date and effective_end_date;
180:
181: cursor c_mode
203: l_formula_type_id ff_formulas_f.formula_type_id%type;
204: l_formula_type_name ff_formula_types.formula_type_name%type;
205: l_pgm_name ben_pgm_f.name%type;
206: l_pl_name ben_pl_f.name%type;
207: l_opt_name ben_opt_f.name%type;
208: l_dummy number;
209: l_national_identifier per_all_people_f.national_identifier%type;
210:
211: begin
6941: -- Bug No 3965571
6942: --
6943: l_pln_name ben_pl_f.name%type;
6944: l_pgm_name ben_pgm_f.name%type;
6945: l_opt_name ben_opt_f.name%type;
6946: --
6947: -- Cursor declaration.
6948: --
6949: -- Scheduled enrolment for plans in programs
7476: (c_oipl_id in number
7477: ,c_effective_date in date)
7478: is
7479: select opt.name
7480: from ben_oipl_f oipl, ben_opt_f opt
7481: where oipl.business_group_id=p_business_group_id
7482: and oipl.opt_id = opt.opt_id and oipl.oipl_id = c_oipl_id
7483: and c_effective_date between oipl.effective_start_date and oipl.effective_end_date
7484: and c_effective_date between opt.effective_start_date and opt.effective_end_date;