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 297: ben_pil_elctbl_chc_popl pel

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

Line 317: ben_pil_elctbl_chc_popl pel

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

Line 344: ben_pil_elctbl_chc_popl pel

340: pel.enrt_perd_id,
341: pel.lee_rsn_id,
342: pel.enrt_perd_strt_dt
343: from ben_elig_per_elctbl_chc epe,
344: ben_pil_elctbl_chc_popl pel
345: where epe.per_in_ler_id = l_per_in_ler_id
346: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
347: and epe.per_in_ler_id = pel.per_in_ler_id
348: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 739: from ben_pil_elctbl_chc_popl pel

735: --
736: /* Start of Changes for WWBUG: 1646442: added cursor and variable */
737: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
738: select pel.enrt_perd_id,pel.lee_rsn_id
739: from ben_pil_elctbl_chc_popl pel
740: ,ben_elig_per_elctbl_chc epe
741: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
742: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
743: --

Line 750: from ben_pil_elctbl_chc_popl pel,

746: --
747: --Bug 3044116
748: cursor c_prtt_enrt (p_pgm_id number) is
749: select epe.prtt_enrt_rslt_id,pel.enrt_perd_strt_dt
750: from ben_pil_elctbl_chc_popl pel,
751: ben_elig_per_elctbl_chc epe
752: where pel.per_in_ler_id = p_per_in_ler_id
753: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
754: and epe.comp_lvl_cd = 'PLANFC'