APPS.BENUTILS dependencies on BEN_PER_IN_LER

Line 286: from ben_per_in_ler pil

282: l_lf_evt_ocrd_dt date;
283: --
284: cursor c_lf_evt_ocrd_dt is
285: select pil.lf_evt_ocrd_dt
286: from ben_per_in_ler pil
287: where pil.person_id = p_person_id
288: and pil.business_group_id + 0 = p_business_group_id
289: and pil.ler_id = nvl(p_ler_id,pil.ler_id)
290: and pil.per_in_ler_stat_cd = 'STRTD';

Line 324: from ben_per_in_ler pil,

320: l_per_in_ler_id number;
321: --
322: cursor c_per_in_ler_id is
323: select pil.per_in_ler_id
324: from ben_per_in_ler pil,
325: ben_ler_f ler
326: where pil.person_id = p_person_id
327: and pil.ler_id = nvl(p_ler_id,pil.ler_id)
328: and pil.ler_id = ler.ler_id

Line 376: from ben_per_in_ler pil,

372: ler.ptnl_ler_trtmt_cd,
373: pil.object_version_number,
374: pil.ptnl_ler_for_per_id,
375: ler.qualg_evt_flag
376: from ben_per_in_ler pil,
377: ben_ler_f ler
378: where pil.person_id = p_person_id
379: and ler.ler_id = pil.ler_id
380: and ler.ler_id = p_ler_id

Line 416: from ben_per_in_ler pil,

412: l_per_in_ler_id number;
413: --
414: cursor c_per_in_ler_id is
415: select pil.per_in_ler_id
416: from ben_per_in_ler pil,
417: ben_ler_f ler
418: where pil.person_id = p_person_id
419: and pil.business_group_id = p_business_group_id
420: and pil.ler_id = nvl(p_ler_id,pil.ler_id)

Line 464: from ben_per_in_ler pil,

460: ler.ptnl_ler_trtmt_cd,
461: pil.object_version_number,
462: pil.ptnl_ler_for_per_id,
463: ler.qualg_evt_flag
464: from ben_per_in_ler pil,
465: ben_ler_f ler
466: where pil.person_id = p_person_id
467: and ler.ler_id = pil.ler_id
468: and p_effective_date

Line 515: from ben_per_in_ler pil,

511: ler.ptnl_ler_trtmt_cd,
512: pil.object_version_number,
513: pil.ptnl_ler_for_per_id,
514: ler.qualg_evt_flag
515: from ben_per_in_ler pil,
516: ben_ler_f ler
517: where pil.person_id = p_person_id
518: and pil.business_group_id = p_business_group_id
519: and ler.ler_id = pil.ler_id

Line 5856: from ben_per_in_ler pil

5852: return date is
5853: --
5854: cursor c_per_in_ler is
5855: select pil.lf_evt_ocrd_dt
5856: from ben_per_in_ler pil
5857: where per_in_ler_id = p_per_in_ler_id;
5858: --
5859: l_lf_evt_ocrd_dt date;
5860: l_comp_obj_disp_dt date;

Line 5946: from ben_per_in_ler pil , ben_ler_f ler

5942:
5943: cursor c_pil_last_upd_date is
5944: select pil.lf_evt_ocrd_dt lf_evt_ocrd_dt,
5945: pil.last_update_date last_update_date
5946: from ben_per_in_ler pil , ben_ler_f ler
5947: where pil.person_id = p_person_id
5948: and pil.business_group_id = p_business_group_id
5949: and pil.per_in_ler_stat_cd = 'STRTD'
5950: and ler.ler_id = pil.ler_id

Line 6123: ben_per_in_ler pil

6119: --
6120: cursor c_exists_prev is
6121: select 'Y'
6122: from ben_elig_cvrd_dpnt_f pdp,
6123: ben_per_in_ler pil
6124: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6125: and pdp.cvg_thru_dt = hr_api.g_eot
6126: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why
6127: -- and pdp.per_in_ler_id = p_per_in_ler_id

Line 6137: ben_per_in_ler pil,

6133: cursor c_exists_prev_other_option is
6134: select 'Y'
6135: from dual where exists( select null
6136: from ben_elig_cvrd_dpnt_f pdp,
6137: ben_per_in_ler pil,
6138: ben_prtt_enrt_rslt_f pnr,
6139: ben_prtt_enrt_rslt_f pen
6140: where pdp.dpnt_person_id = p_dpnt_person_id
6141: --and pdp.cvg_thru_dt = hr_api.g_eot