APPS.BEN_ELIGIBILITY_OVERRIDE dependencies on BEN_ELIG_PER_F

Line 124: (p_elig_per_rec in ben_elig_per_f%rowtype,

120:
121: --
122: -- Updates the elig_flag on a single elig_per_opt record
123: procedure upd_elig_per_opt_flag
124: (p_elig_per_rec in ben_elig_per_f%rowtype,
125: p_business_group_id in number,
126: p_elig_flag in varchar2,
127: p_effective_date in date,
128: p_dt_mode in varchar2,

Line 134: ben_elig_per_f pep,

130:
131: cursor c_epo is
132: select oipl.oipl_id,epo.*
133: from ben_elig_per_opt_f epo,
134: ben_elig_per_f pep,
135: ben_oipl_f oipl
136: where epo.elig_per_id = p_elig_per_rec.elig_per_id
137: and pep.elig_per_id = epo.elig_per_id
138: and oipl.pl_id = pep.pl_id

Line 197: (p_elig_rec in ben_elig_per_f%rowtype,

193:
194: --
195: -- Updates the elig_flag on a single elig_per record
196: procedure upd_elig_per_flag
197: (p_elig_rec in ben_elig_per_f%rowtype,
198: p_business_group_id in number,
199: p_elig_flag in varchar2,
200: p_effective_date in date,
201: p_dt_mode in varchar2,

Line 261: from ben_elig_per_f pep

257: l_up boolean := false;
258:
259: cursor c_elig is
260: select pep.*
261: from ben_elig_per_f pep
262: where pep.person_id = p_person_id
263: and nvl(pep.pgm_id,-1) = nvl(p_pgm_id,-1)
264: and p_effective_date between pep.effective_start_date and
265: pep.effective_end_date

Line 307: from ben_elig_per_f pep

303: l_elig_rec c_elig%rowtype;
304:
305: cursor c_inelig is
306: select pep.*
307: from ben_elig_per_f pep
308: where pep.person_id = p_person_id
309: and nvl(pep.pgm_id,-1) = nvl(p_pgm_id,-1)
310: and p_effective_date between pep.effective_start_date and
311: pep.effective_end_date

Line 480: (p_elig_per in ben_elig_per_f%rowtype,

476: -- Inserts elig_per records starting from the current level of
477: -- the comp object upto PGM level
478: --
479: procedure create_elig_hierarchy
480: (p_elig_per in ben_elig_per_f%rowtype,
481: p_cobj_level in varchar2,
482: p_dt_mode in varchar2,
483: p_business_group_id in number,
484: p_effective_date in date,

Line 487: l_elig_per ben_elig_per_f%rowtype := p_elig_per;

483: p_business_group_id in number,
484: p_effective_date in date,
485: p_out_mesg out nocopy varchar2) is
486:
487: l_elig_per ben_elig_per_f%rowtype := p_elig_per;
488: l_eff_dt date := p_effective_date;
489: l_bg_id number := p_business_group_id;
490: l_cobj_level varchar2(30) := p_cobj_level;
491: l_elig_per_id number;

Line 523: from ben_elig_per_f pep

519: and pl.effective_end_date;
520:
521: cursor c_elig_cobj is
522: select null
523: from ben_elig_per_f pep
524: where pep.pgm_id = l_elig_per.pgm_id
525: and nvl(pep.plip_id,-1) = nvl(l_elig_per.plip_id,-1)
526: and nvl(pep.ptip_id,-1) = nvl(l_elig_per.ptip_id,-1)
527: and nvl(pep.pl_id,-1) = nvl(l_elig_per.pl_id,-1)