APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_ELIG_PER_F

Line 194: l_rt_hrs_wkd_val ben_elig_per_f.rt_hrs_wkd_val%type;

190: ,p_pl_id in number default null
191: ,p_pgm_id in number default null)
192: return number is
193: --
194: l_rt_hrs_wkd_val ben_elig_per_f.rt_hrs_wkd_val%type;
195: --
196:
197: cursor c_hrs_wkd is
198: select bep.rt_hrs_wkd_val

Line 199: from ben_elig_per_f bep,

195: --
196:
197: cursor c_hrs_wkd is
198: select bep.rt_hrs_wkd_val
199: from ben_elig_per_f bep,
200: ben_per_in_ler pil
201: where bep.person_id = p_person_id
202: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)
203: and nvl(bep.pl_id,-1) = nvl(p_pl_id,-1)

Line 213: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

209: or pil.per_in_ler_stat_cd is null); -- outer join condition
210:
211: cursor c_hrs_wkd_opt is
212: select epo.rt_hrs_wkd_val
213: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
214: ben_per_in_ler pil
215: where bep.person_id = p_person_id
216: and bep.elig_per_id = epo.elig_per_id
217: and epo.opt_id = p_opt_id

Line 231: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

227: or pil.per_in_ler_stat_cd is null); -- outer join condition
228:
229: cursor c_hrs_wkd_plip is
230: select epo.rt_hrs_wkd_val
231: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
232: ben_per_in_ler pil
233: where bep.person_id = p_person_id
234: and bep.elig_per_id = epo.elig_per_id
235: and epo.opt_id = p_opt_id

Line 294: from ben_elig_per_f bep,

290: return number is
291: --
292: cursor c_pct_ft is
293: select bep.rt_pct_fl_tm_val
294: from ben_elig_per_f bep,
295: ben_per_in_ler pil
296: where bep.person_id = p_person_id
297: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)
298: and nvl(bep.pl_id,-1) = nvl(p_pl_id,-1)

Line 310: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

306: );
307:
308: cursor c_pct_ft_opt is
309: select epo.rt_pct_fl_tm_val
310: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
311: ben_per_in_ler pil
312: where bep.person_id = p_person_id
313: and bep.elig_per_id = epo.elig_per_id
314: and epo.opt_id = p_opt_id

Line 328: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

324: or pil.per_in_ler_stat_cd is null); -- outer join condition
325:
326: cursor c_pct_ft_plip is
327: select epo.rt_pct_fl_tm_val
328: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
329: ben_per_in_ler pil
330: where bep.person_id = p_person_id
331: and bep.elig_per_id = epo.elig_per_id
332: and epo.opt_id = p_opt_id

Line 5187: from ben_elig_per_f epo,

5183: l_prtt_is_cvrd_flag ben_prtt_enrt_rslt_f.prtt_is_cvrd_flag%type;
5184: --
5185: cursor c1(p_pl_id in number) is
5186: select null
5187: from ben_elig_per_f epo,
5188: ben_per_in_ler pil
5189: where epo.person_id = p_person_id
5190: and epo.pl_id = p_pl_id
5191: and p_effective_date

Line 8890: l_prtn_ovridn_flag ben_elig_per_f.prtn_ovridn_flag%type;

8886: l_elig_flag boolean := false;
8887: l_elig_per_id number;
8888: l_prtn_ovridn_thru_dt date;
8889: l_effective_date date;
8890: l_prtn_ovridn_flag ben_elig_per_f.prtn_ovridn_flag%type;
8891: l_rl_count number;
8892: l_match_one boolean := false;
8893: l_match_one_rl varchar2(15) := 'FALSE';
8894: l_outputs ff_exec.outputs_t;