APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_OPT_F

Line 6326: l_opt_id ben_opt_f.opt_id%type;

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

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

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

Line 6353: from ben_opt_f opt

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

Line 6593: l_opt_name ben_opt_f.name%type;

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

Line 7306: l_opt_name ben_opt_f.name%type;

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

Line 7309: l_opt_id ben_opt_f.opt_id%type;

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