APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_OPT_F

Line 6327: l_opt_id ben_opt_f.opt_id%type;

6323: where cop.oipl_id = p_oipl_id
6324: and p_effective_date between cop.effective_start_date
6325: and cop.effective_end_date;
6326:
6327: l_opt_id ben_opt_f.opt_id%type;
6328: l_pl_id ben_pl_f.pl_id%type;
6329: l_oipl_name varchar2(500);
6330:
6331: begin

Line 6350: l_opt_name ben_opt_f.name%type := null;

6346: p_opt_id in number
6347: ,p_effective_date in date
6348: ) return varchar2 is
6349:
6350: l_opt_name ben_opt_f.name%type := null;
6351:
6352: cursor c_opt_name is
6353: select opt.name
6354: from ben_opt_f opt

Line 6354: from ben_opt_f opt

6350: l_opt_name ben_opt_f.name%type := null;
6351:
6352: cursor c_opt_name is
6353: select opt.name
6354: from ben_opt_f opt
6355: where opt.opt_id = p_opt_id
6356: and p_effective_date between opt.effective_start_date
6357: and opt.effective_end_date;
6358:

Line 6594: l_opt_name ben_opt_f.name%type;

6590: ,p_effective_date in date
6591: ) return varchar2 is
6592:
6593: l_pl_typ_name ben_pl_typ_f.name%type;
6594: l_opt_name ben_opt_f.name%type;
6595:
6596: begin
6597: l_opt_name := get_opt_name(p_opt_id,p_effective_date);
6598: l_pl_typ_name := get_pl_typ_name(p_pl_typ_id,p_effective_date);

Line 7307: l_opt_name ben_opt_f.name%type;

7303: and p_effective_date between cop.effective_start_date
7304: and cop.effective_end_date;
7305:
7306: l_pl_typ_name ben_pl_typ_f.name%type;
7307: l_opt_name ben_opt_f.name%type;
7308: l_pl_name ben_pl_f.name%type;
7309: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
7310: l_opt_id ben_opt_f.opt_id%type;
7311: l_pl_id ben_pl_f.pl_id%type;

Line 7310: l_opt_id ben_opt_f.opt_id%type;

7306: l_pl_typ_name ben_pl_typ_f.name%type;
7307: l_opt_name ben_opt_f.name%type;
7308: l_pl_name ben_pl_f.name%type;
7309: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
7310: l_opt_id ben_opt_f.opt_id%type;
7311: l_pl_id ben_pl_f.pl_id%type;
7312:
7313: begin
7314: