APPS.BEN_COMP_OBJECT dependencies on BEN_PL_F

Line 90: procedure set_object(p_rec in out nocopy ben_pl_f%rowtype) is

86: g_cache_pgm_rec(l_index):=p_rec;
87: --
88: end set_object;
89: --
90: procedure set_object(p_rec in out nocopy ben_pl_f%rowtype) is
91: --
92: l_proc varchar2(80) := g_package||'set_object pln ';
93: l_index pls_integer;
94: --

Line 355: p_rec in out NOCOPY ben_pl_f%rowtype) is

351: --
352: procedure set_object(p_pl_id in number,
353: p_business_group_id in number,
354: p_effective_date in date,
355: p_rec in out NOCOPY ben_pl_f%rowtype) is
356: --
357: l_proc varchar2(80) := g_package||'set_object alt pln';
358: --
359: cursor c1 is

Line 361: from ben_pl_f pln

357: l_proc varchar2(80) := g_package||'set_object alt pln';
358: --
359: cursor c1 is
360: select pln.*
361: from ben_pl_f pln
362: where pln.pl_id = p_pl_id
363: and pln.business_group_id = p_business_group_id
364: and p_effective_date
365: between pln.effective_start_date

Line 368: --l_rec ben_pl_f%rowtype;

364: and p_effective_date
365: between pln.effective_start_date
366: and pln.effective_end_date;
367: --
368: --l_rec ben_pl_f%rowtype;
369: --
370: begin
371: --
372: -- hr_utility.set_location('Entering '||l_proc,10);

Line 814: p_rec in out NOCOPY ben_pl_f%rowtype) is

810: --
811: end get_object;
812: --
813: procedure get_object(p_pl_id in number,
814: p_rec in out NOCOPY ben_pl_f%rowtype) is
815: --
816: l_proc varchar2(80) := g_package||'get_object pln';
817: l_index pls_integer;
818: --l_not_hash_found boolean;

Line 820: --l_rec ben_pl_f%rowtype;

816: l_proc varchar2(80) := g_package||'get_object pln';
817: l_index pls_integer;
818: --l_not_hash_found boolean;
819: l_env ben_env_object.g_global_env_rec_type;
820: --l_rec ben_pl_f%rowtype;
821: --
822: begin
823: --
824: -- hr_utility.set_location('Entering '||l_proc,10);

Line 1242: from ben_pl_f pln,

1238: l_lf_evt_ocrd_dt date;
1239: --
1240: cursor c1 is -- changed the sql for performance bug 3662774
1241: select distinct pln.*
1242: from ben_pl_f pln,
1243: ben_plip_f cpp,
1244: ben_pl_regn_f prg,
1245: ben_regn_f reg
1246: where pln.pl_id = cpp.pl_id

Line 1292: from ben_pl_f pln,

1288:
1289:
1290:
1291: /* select pln.*
1292: from ben_pl_f pln,
1293: ben_plip_f cpp,
1294: ben_pl_regn_f prg,
1295: ben_regn_f reg,
1296: ben_elig_per_f epo

Line 1462: l_pl_rec ben_pl_f%rowtype;

1458: --
1459: l_opt_rec ben_opt_f%rowtype;
1460: l_oiplip_rec ben_oiplip_f%rowtype;
1461: l_pgm_rec ben_pgm_f%rowtype;
1462: l_pl_rec ben_pl_f%rowtype;
1463: l_plip_rec ben_plip_f%rowtype;
1464: l_ptip_rec ben_ptip_f%rowtype;
1465: l_oipl_rec ben_oipl_f%rowtype;
1466: --