APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PL_F

Line 6235: l_pl_name ben_pl_f.name%type := null;

6231: p_pl_id in number
6232: ,p_effective_date in date
6233: ) return varchar2 is
6234:
6235: l_pl_name ben_pl_f.name%type := null;
6236:
6237: cursor c_pl_name is
6238: select pln.name
6239: from ben_pl_f pln

Line 6239: from ben_pl_f pln

6235: l_pl_name ben_pl_f.name%type := null;
6236:
6237: cursor c_pl_name is
6238: select pln.name
6239: from ben_pl_f pln
6240: where pln.pl_id = p_pl_id
6241: and p_effective_date between pln.effective_start_date
6242: and pln.effective_end_date;
6243:

Line 6297: l_pl_id ben_pl_f.pl_id%type;

6293: and p_effective_date between cpp.effective_start_date
6294: and cpp.effective_end_date;
6295:
6296: l_pgm_id ben_pgm_f.pgm_id%type;
6297: l_pl_id ben_pl_f.pl_id%type;
6298: l_plip_name varchar2(500);
6299:
6300: begin
6301:

Line 6327: l_pl_id ben_pl_f.pl_id%type;

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
6331:

Line 7307: l_pl_name ben_pl_f.name%type;

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;
7311:

Line 7310: l_pl_id ben_pl_f.pl_id%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:
7314: open c_pl_typ_opt_typ;