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_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PER_IN_LER

Line 694: ben_per_in_ler pil,

690: pel.acty_ref_perd_cd,
691: pil.person_id,
692: pil.ler_id
693: from ben_elig_per_elctbl_chc epe,
694: ben_per_in_ler pil,
695: ben_pil_elctbl_chc_popl pel
696: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
697: and epe.per_in_ler_id = pil.per_in_ler_id
698: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 1013: ben_per_in_ler pil

1009: is
1010: select epo.prtn_strt_dt
1011: from ben_elig_per_f ep,
1012: ben_elig_per_opt_f epo,
1013: ben_per_in_ler pil
1014: where ep.person_id=c_person_id
1015: and nvl(ep.pgm_id,-1)=c_pgm_id
1016: and ep.pl_id=c_pl_id
1017: and epo.opt_id=c_opt_id

Line 1030: ben_per_in_ler pil

1026: pil.per_in_ler_stat_cd is null)
1027: union
1028: select prtn_strt_dt
1029: from ben_elig_per_f ep,
1030: ben_per_in_ler pil
1031: where ep.person_id=c_person_id
1032: and nvl(ep.pgm_id,-1)=c_pgm_id
1033: and ep.pl_id=c_pl_id
1034: and c_effective_date

Line 1045: ben_per_in_ler pil,

1041: cursor c_enrt_prem(p_actl_prem_id in number)
1042: is
1043: select ecr.val
1044: from ben_enrt_prem ecr,
1045: ben_per_in_ler pil,
1046: ben_elig_per_elctbl_chc epe
1047: where ecr.actl_prem_id = p_actl_prem_id
1048: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1049: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id