APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PER_IN_LER

Line 189: ben_per_in_ler pil

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

Line 203: ben_per_in_ler pil

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

Line 221: ben_per_in_ler pil

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

Line 284: ben_per_in_ler pil

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

Line 300: ben_per_in_ler pil

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

Line 318: ben_per_in_ler pil

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

Line 5177: ben_per_in_ler pil

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

Line 7343: ,ben_per_in_ler pil

7339: ,p_ptip_id in number) is
7340: select cqb.quald_bnf_flag
7341: from ben_cbr_quald_bnf cqb
7342: ,ben_cbr_per_in_ler crp
7343: ,ben_per_in_ler pil
7344: where cqb.quald_bnf_person_id = p_person_id
7345: -- lamc added these next 2 lines
7346: and cqb.pgm_id = nvl(p_pgm_id,cqb.pgm_id)
7347: and nvl(cqb.ptip_id,-1) = nvl(p_ptip_id, -1)

Line 8882: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;

8878: l_elig_apls_flag varchar2(30);
8879: l_dpnt_elig_flag varchar2(1) := 'Y';
8880: l_dependent_elig_flag varchar2(1) := 'Y';
8881: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
8882: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8883: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
8884: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
8885: l_dpnt_pl_id ben_pl_f.pl_id%type;
8886: l_exists varchar2(30);

Line 8912: l_pil_row ben_per_in_ler%rowtype;

8908: l_loop_count number;
8909: --
8910: l_empasg_row per_all_assignments_f%rowtype;
8911: l_benasg_row per_all_assignments_f%rowtype;
8912: l_pil_row ben_per_in_ler%rowtype;
8913: --
8914: l_cagrelig_cnt pls_integer;
8915: l_pl_typ_id number;
8916: l_typ_rec ben_person_object.g_cache_typ_table;