APPS.BENUTILS dependencies on BEN_LER_F

Line 325: ben_ler_f ler

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
329: and pil.per_in_ler_stat_cd = 'STRTD'

Line 377: ben_ler_f ler

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
381: and p_effective_date

Line 417: ben_ler_f ler

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)
421: and pil.ler_id = ler.ler_id

Line 465: ben_ler_f ler

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
469: between ler.effective_start_date

Line 516: ben_ler_f ler

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
520: and ler.business_group_id = pil.business_group_id

Line 561: from ben_ler_f ler

557: cursor c_ler is
558: select ler.ler_id,
559: ler.ler_eval_rl,
560: ler.name
561: from ben_ler_f ler
562: where ler.business_group_id = p_business_group_id
563: and ler.ler_id = p_ler_id
564: and p_effective_date
565: between ler.effective_start_date

Line 594: from ben_ler_f ler

590: cursor c_ler is
591: select ler.ler_id,
592: ler.ler_eval_rl,
593: ler.name
594: from ben_ler_f ler
595: where ler.business_group_id = p_business_group_id
596: and ler.typ_cd = p_typ_cd
597: and p_effective_date
598: between ler.effective_start_date

Line 808: from ben_ler_f ler

804: p_business_group_id in number) return varchar2 is
805: --
806: cursor c1 is
807: select ler.name
808: from ben_ler_f ler
809: where ler.business_group_id = p_business_group_id
810: and ler.typ_cd = p_typ_cd
811: and sysdate
812: between ler.effective_start_date

Line 815: l_name ben_ler_f.name%type; -- UTF8 Change Bug 2254683

811: and sysdate
812: between ler.effective_start_date
813: and ler.effective_end_date;
814: --
815: l_name ben_ler_f.name%type; -- UTF8 Change Bug 2254683
816: begin
817: --
818: open c1;
819: --

Line 5821: from ben_per_in_ler pil , ben_ler_f ler

5817:
5818: cursor c_pil_last_upd_date is
5819: select pil.lf_evt_ocrd_dt lf_evt_ocrd_dt,
5820: pil.last_update_date last_update_date
5821: from ben_per_in_ler pil , ben_ler_f ler
5822: where pil.person_id = p_person_id
5823: and pil.business_group_id = p_business_group_id
5824: and pil.per_in_ler_stat_cd = 'STRTD'
5825: and ler.ler_id = pil.ler_id