APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PER_IN_LER

Line 200: ben_per_in_ler pil

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)
204: and nvl(l_fonm_cvg_strt_dt,p_effective_date) between bep.effective_start_date

Line 214: ben_per_in_ler pil

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
218: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 232: ben_per_in_ler pil

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
236: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 295: ben_per_in_ler pil

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)
299: and p_effective_date

Line 311: ben_per_in_ler pil

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
315: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 329: ben_per_in_ler pil

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
333: and nvl(bep.pgm_id,-1) = nvl(p_pgm_id,-1)

Line 5188: ben_per_in_ler pil

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
5192: between epo.effective_start_date

Line 7358: ,ben_per_in_ler pil

7354: select cqb.quald_bnf_flag
7355: ,cqb.cbr_elig_perd_strt_dt
7356: from ben_cbr_quald_bnf cqb
7357: ,ben_cbr_per_in_ler crp
7358: ,ben_per_in_ler pil
7359: where cqb.quald_bnf_person_id = p_person_id
7360: -- lamc added these next 2 lines
7361: and cqb.pgm_id = nvl(p_pgm_id,cqb.pgm_id)
7362: and nvl(cqb.ptip_id,-1) = nvl(p_ptip_id, -1)

Line 8901: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

8897: l_elig_apls_flag varchar2(30);
8898: l_dpnt_elig_flag varchar2(1) := 'Y';
8899: l_dependent_elig_flag varchar2(1) := 'Y';
8900: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
8901: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8902: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
8903: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
8904: l_dpnt_pl_id ben_pl_f.pl_id%type;
8905: l_exists varchar2(30);

Line 8931: l_pil_row ben_per_in_ler%rowtype;

8927: l_loop_count number;
8928: --
8929: l_empasg_row per_all_assignments_f%rowtype;
8930: l_benasg_row per_all_assignments_f%rowtype;
8931: l_pil_row ben_per_in_ler%rowtype;
8932: --
8933: l_cagrelig_cnt pls_integer;
8934: l_pl_typ_id number;
8935: l_typ_rec ben_person_object.g_cache_typ_table;