DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT dependencies on BEN_PLIP_F

Line 175: procedure set_object(p_rec in out nocopy ben_plip_f%rowtype) is

171: g_cache_oipl_rec(l_index):=p_rec;
172: --
173: end set_object;
174: --
175: procedure set_object(p_rec in out nocopy ben_plip_f%rowtype) is
176: --
177: l_proc varchar2(80) := g_package||'set_object plip ';
178: l_index pls_integer;
179: l_not_hash_found boolean;

Line 526: p_rec in out NOCOPY ben_plip_f%rowtype) is

522: --
523: procedure set_object(p_plip_id in number,
524: p_business_group_id in number,
525: p_effective_date in date,
526: p_rec in out NOCOPY ben_plip_f%rowtype) is
527: --
528: l_proc varchar2(80) := g_package||'set_object alt plip ';
529: --
530: cursor c1 is

Line 532: from ben_plip_f cpp

528: l_proc varchar2(80) := g_package||'set_object alt plip ';
529: --
530: cursor c1 is
531: select cpp.*
532: from ben_plip_f cpp
533: where cpp.plip_id = p_plip_id
534: and cpp.business_group_id = p_business_group_id
535: and p_effective_date
536: between cpp.effective_start_date

Line 539: --l_rec ben_plip_f%rowtype;

535: and p_effective_date
536: between cpp.effective_start_date
537: and cpp.effective_end_date;
538: --
539: --l_rec ben_plip_f%rowtype;
540: --
541: begin
542: --
543: -- hr_utility.set_location('Entering '||l_proc,10);

Line 952: p_rec in out NOCOPY ben_plip_f%rowtype) is

948: --
949: end get_object;
950: --
951: procedure get_object(p_plip_id in number,
952: p_rec in out NOCOPY ben_plip_f%rowtype) is
953: --
954: l_proc varchar2(80) := g_package||'get_object plip';
955: l_index pls_integer;
956: --l_not_hash_found boolean;

Line 958: --l_rec ben_plip_f%rowtype;

954: l_proc varchar2(80) := g_package||'get_object plip';
955: l_index pls_integer;
956: --l_not_hash_found boolean;
957: l_env ben_env_object.g_global_env_rec_type;
958: --l_rec ben_plip_f%rowtype;
959: --
960: begin
961: --
962: -- hr_utility.set_location('Entering '||l_proc,10);

Line 1243: ben_plip_f cpp,

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
1247: and pln.business_group_id = l_env.business_group_id

Line 1293: ben_plip_f cpp,

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
1297: , ben_per_in_ler pil

Line 1463: l_plip_rec ben_plip_f%rowtype;

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: --
1467: begin