APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_ELIG_PER_F

Line 183: l_rt_hrs_wkd_val ben_elig_per_f.rt_hrs_wkd_val%type;

179: ,p_pl_id in number default null
180: ,p_pgm_id in number default null)
181: return number is
182: --
183: l_rt_hrs_wkd_val ben_elig_per_f.rt_hrs_wkd_val%type;
184: --
185:
186: cursor c_hrs_wkd is
187: select bep.rt_hrs_wkd_val

Line 188: from ben_elig_per_f bep,

184: --
185:
186: cursor c_hrs_wkd is
187: select bep.rt_hrs_wkd_val
188: from ben_elig_per_f bep,
189: ben_per_in_ler pil
190: where bep.person_id = p_person_id
191: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)
192: and nvl(bep.pl_id,-1) = nvl(p_pl_id,-1)

Line 202: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

198: or pil.per_in_ler_stat_cd is null); -- outer join condition
199:
200: cursor c_hrs_wkd_opt is
201: select epo.rt_hrs_wkd_val
202: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
203: ben_per_in_ler pil
204: where bep.person_id = p_person_id
205: and bep.elig_per_id = epo.elig_per_id
206: and epo.opt_id = p_opt_id

Line 220: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

216: or pil.per_in_ler_stat_cd is null); -- outer join condition
217:
218: cursor c_hrs_wkd_plip is
219: select epo.rt_hrs_wkd_val
220: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
221: ben_per_in_ler pil
222: where bep.person_id = p_person_id
223: and bep.elig_per_id = epo.elig_per_id
224: and epo.opt_id = p_opt_id

Line 283: from ben_elig_per_f bep,

279: return number is
280: --
281: cursor c_pct_ft is
282: select bep.rt_pct_fl_tm_val
283: from ben_elig_per_f bep,
284: ben_per_in_ler pil
285: where bep.person_id = p_person_id
286: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)
287: and nvl(bep.pl_id,-1) = nvl(p_pl_id,-1)

Line 299: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

295: );
296:
297: cursor c_pct_ft_opt is
298: select epo.rt_pct_fl_tm_val
299: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
300: ben_per_in_ler pil
301: where bep.person_id = p_person_id
302: and bep.elig_per_id = epo.elig_per_id
303: and epo.opt_id = p_opt_id

Line 317: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

313: or pil.per_in_ler_stat_cd is null); -- outer join condition
314:
315: cursor c_pct_ft_plip is
316: select epo.rt_pct_fl_tm_val
317: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
318: ben_per_in_ler pil
319: where bep.person_id = p_person_id
320: and bep.elig_per_id = epo.elig_per_id
321: and epo.opt_id = p_opt_id

Line 5176: from ben_elig_per_f epo,

5172: l_prtt_is_cvrd_flag ben_prtt_enrt_rslt_f.prtt_is_cvrd_flag%type;
5173: --
5174: cursor c1(p_pl_id in number) is
5175: select null
5176: from ben_elig_per_f epo,
5177: ben_per_in_ler pil
5178: where epo.person_id = p_person_id
5179: and epo.pl_id = p_pl_id
5180: and p_effective_date

Line 8871: l_prtn_ovridn_flag ben_elig_per_f.prtn_ovridn_flag%type;

8867: l_elig_flag boolean := false;
8868: l_elig_per_id number;
8869: l_prtn_ovridn_thru_dt date;
8870: l_effective_date date;
8871: l_prtn_ovridn_flag ben_elig_per_f.prtn_ovridn_flag%type;
8872: l_rl_count number;
8873: l_match_one boolean := false;
8874: l_match_one_rl varchar2(15) := 'FALSE';
8875: l_outputs ff_exec.outputs_t;