APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PL_F

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

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

Line 6240: from ben_pl_f pln

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

Line 6298: l_pl_id ben_pl_f.pl_id%type;

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

Line 6328: l_pl_id ben_pl_f.pl_id%type;

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

Line 7308: l_pl_name ben_pl_f.name%type;

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

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