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_RATE_CHG dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 275: ben_pil_elctbl_chc_popl pel

271: pel.enrt_perd_id,
272: pel.lee_rsn_id,
273: pel.enrt_perd_strt_dt
274: from ben_elig_per_elctbl_chc epe,
275: ben_pil_elctbl_chc_popl pel
276: where epe.per_in_ler_id = l_per_in_ler_id
277: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
278: and epe.per_in_ler_id = pel.per_in_ler_id
279: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP');

Line 294: ben_pil_elctbl_chc_popl pel

290: pel.enrt_perd_id,
291: pel.lee_rsn_id,
292: pel.enrt_perd_strt_dt
293: from ben_elig_per_elctbl_chc epe,
294: ben_pil_elctbl_chc_popl pel
295: where epe.per_in_ler_id = l_per_in_ler_id
296: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
297: and epe.per_in_ler_id = pel.per_in_ler_id
298: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 320: ben_pil_elctbl_chc_popl pel

316: pel.enrt_perd_id,
317: pel.lee_rsn_id,
318: pel.enrt_perd_strt_dt
319: from ben_elig_per_elctbl_chc epe,
320: ben_pil_elctbl_chc_popl pel
321: where epe.per_in_ler_id = l_per_in_ler_id
322: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
323: and epe.per_in_ler_id = pel.per_in_ler_id
324: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 691: from ben_pil_elctbl_chc_popl pel

687: --
688: /* Start of Changes for WWBUG: 1646442: added cursor and variable */
689: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
690: select pel.enrt_perd_id,pel.lee_rsn_id
691: from ben_pil_elctbl_chc_popl pel
692: ,ben_elig_per_elctbl_chc epe
693: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
694: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
695: --

Line 702: from ben_pil_elctbl_chc_popl pel,

698: --
699: --Bug 3044116
700: cursor c_prtt_enrt (p_pgm_id number) is
701: select epe.prtt_enrt_rslt_id,pel.enrt_perd_strt_dt
702: from ben_pil_elctbl_chc_popl pel,
703: ben_elig_per_elctbl_chc epe
704: where pel.per_in_ler_id = p_per_in_ler_id
705: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
706: and epe.comp_lvl_cd = 'PLANFC'