eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_PER_IN_LER

Line 713: ben_per_in_ler pil

709: ppe.effective_start_date,
710: ppe.effective_end_date,
711: ppe.actl_prem_id
712: from ben_prtt_prem_f ppe,
713: ben_per_in_ler pil
714: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
715: and pil.per_in_ler_id=ppe.per_in_ler_id
716: and pil.business_group_id=ppe.business_group_id
717: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 726: ben_per_in_ler pil

722: ppe1.effective_start_date,
723: ppe1.effective_end_date,
724: ppe1.actl_prem_id
725: from ben_prtt_prem_f ppe1,
726: ben_per_in_ler pil
727: where ppe1.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
728: and pil.per_in_ler_id=ppe1.per_in_ler_id
729: and pil.business_group_id=ppe1.business_group_id
730: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 735: ben_per_in_ler pil

731: and ppe1.effective_start_date > p_ppe_dt_to_use
732: and not exists
733: (select 1
734: from ben_prtt_prem_f ppe2,
735: ben_per_in_ler pil
736: where ppe2.prtt_prem_id = ppe1.prtt_prem_id
737: and ppe2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
738: and pil.per_in_ler_id=ppe2.per_in_ler_id
739: and pil.business_group_id=ppe2.business_group_id

Line 939: ben_per_in_ler pil

935: ppe.effective_end_date,
936: ppe.actl_prem_id,
937: ppe.business_group_id
938: from ben_prtt_prem_f ppe,
939: ben_per_in_ler pil
940: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
941: and pil.per_in_ler_id=ppe.per_in_ler_id
942: and pil.business_group_id=ppe.business_group_id
943: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 954: ben_per_in_ler pil

950: ppe1.effective_end_date,
951: ppe1.actl_prem_id,
952: ppe1.business_group_id
953: from ben_prtt_prem_f ppe1,
954: ben_per_in_ler pil
955: where ppe1.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
956: and pil.per_in_ler_id=ppe1.per_in_ler_id
957: and pil.business_group_id=ppe1.business_group_id
958: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 964: ben_per_in_ler pil

960: and ppe1.effective_end_date <> hr_api.g_eot
961: and not exists
962: (select 1
963: from ben_prtt_prem_f ppe2,
964: ben_per_in_ler pil
965: where ppe2.prtt_prem_id = ppe1.prtt_prem_id
966: and ppe2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
967: and pil.per_in_ler_id=ppe2.per_in_ler_id
968: and pil.business_group_id=ppe2.business_group_id

Line 1111: ben_per_in_ler pil,

1107: pil.lf_evt_ocrd_dt,
1108: pil.ler_id,
1109: epe.elig_per_elctbl_chc_id
1110: from ben_enrt_prem ecr,
1111: ben_per_in_ler pil,
1112: ben_elig_per_elctbl_chc epe
1113: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1114: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1115: and pil.per_in_ler_id = epe.per_in_ler_id

Line 1130: ben_per_in_ler pil

1126: ppe.actl_prem_id,
1127: ppe.object_version_number,
1128: ppe.effective_start_date
1129: from ben_prtt_prem_f ppe,
1130: ben_per_in_ler pil
1131: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1132: and ppe.actl_prem_id = p_actl_prem_id
1133: and p_ppe_dt_to_use between
1134: ppe.effective_start_date and ppe.effective_end_date

Line 1452: ben_per_in_ler pil

1448: bpl.used_val,
1449: bpl.object_version_number,
1450: bpl.effective_start_date
1451: from ben_bnft_prvdd_ldgr_f bpl,
1452: ben_per_in_ler pil
1453: where bpl.bnft_prvdr_pool_id=l_ecr_rec.decr_bnft_prvdr_pool_id
1454: and bpl.business_group_id=l_epe_rec.business_group_id
1455: and bpl.acty_base_rt_id=l_ecr_rec.acty_base_rt_id
1456: and bpl.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id