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.PQH_PA_WHATIF_PROCESS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 2320: ben_elig_per_elctbl_chc epe,

2316: CURSOR csr_pl_types_not_in_program(p_per_in_ler_id NUMBER) IS
2317: Select distinct pt.pl_typ_id,
2318: pt.name
2319: From ben_pl_typ_f pt,
2320: ben_elig_per_elctbl_chc epe,
2321: ben_pil_elctbl_chc_popl popl
2322: Where pt.pl_typ_id = epe.pl_typ_id
2323: and popl.per_in_ler_id = p_per_in_ler_id
2324: and popl.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id

Line 2334: From ben_elig_per_elctbl_chc epe,

2330: /*CURSOR csr_pl_types_in_program(p_pil_elctbl_chc_popl_id NUMBER) IS
2331: Select pt.pl_typ_id
2332: ,pt.name
2333: ,epe.ptip_id
2334: From ben_elig_per_elctbl_chc epe,
2335: ben_pl_typ_f pt
2336: Where epe.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
2337: and epe.pl_typ_id = pt.pl_typ_id
2338: and epe.comp_lvl_cd = 'PLAN'

Line 2349: From ben_elig_per_elctbl_chc epe

2345: ben_ptip_f ptip
2346: Where
2347: ptip.pl_typ_id=pt.pl_typ_id
2348: and pt.pl_typ_id in ( Select epe.pl_typ_id
2349: From ben_elig_per_elctbl_chc epe
2350: Where epe.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
2351: and epe.comp_lvl_cd = 'PLAN'
2352: and epe.pgm_id=ptip.pgm_id
2353: )

Line 2369: ben_elig_per_elctbl_chc epe

2365: pl.nip_acty_ref_perd_cd acty_ref_perd_cd,
2366: epe.elctbl_flag,
2367: epe.elig_per_elctbl_chc_id
2368: From ben_pl_f pl,
2369: ben_elig_per_elctbl_chc epe
2370: Where
2371: epe.per_in_ler_id = p_per_in_ler_id
2372: and epe.comp_lvl_cd = 'PLAN'
2373: and epe.pl_id = pl.pl_id

Line 2384: From ben_elig_per_elctbl_chc epe,

2380: oipl.oipl_id,
2381: opt.name,
2382: epe.elctbl_flag,
2383: epe.elig_per_elctbl_chc_id
2384: From ben_elig_per_elctbl_chc epe,
2385: ben_oipl_f oipl,
2386: ben_opt_f opt
2387: Where epe.per_in_ler_id = p_per_in_ler_id
2388: AND epe.plip_id = p_plip_id

Line 2401: From ben_elig_per_elctbl_chc epe,

2397: oipl.oipl_id,
2398: opt.name,
2399: epe.elctbl_flag,
2400: epe.elig_per_elctbl_chc_id
2401: From ben_elig_per_elctbl_chc epe,
2402: ben_oipl_f oipl,
2403: ben_opt_f opt
2404: Where epe.per_in_ler_id = p_per_in_ler_id
2405: AND epe.plip_id is NULL and epe.pl_id=p_pl_id

Line 2976: From ben_elig_per_elctbl_chc epe,

2972: Select pt.pl_typ_id,
2973: pt.name
2974: From ben_pl_typ_f pt
2975: Where pt.pl_typ_id IN ( Select epe.pl_typ_id
2976: From ben_elig_per_elctbl_chc epe,
2977: ben_pil_elctbl_chc_popl popl
2978: Where popl.per_in_ler_id = p_per_in_ler_id
2979: and popl.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
2980: and epe.comp_lvl_cd = 'PLAN'

Line 2990: From ben_elig_per_elctbl_chc epe,

2986: /*CURSOR csr_pl_types_in_program(p_pil_elctbl_chc_popl_id NUMBER) IS
2987: Select pt.pl_typ_id
2988: ,pt.name
2989: ,epe.ptip_id
2990: From ben_elig_per_elctbl_chc epe,
2991: ben_pl_typ_f pt
2992: Where epe.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
2993: and epe.pl_typ_id = pt.pl_typ_id
2994: and epe.comp_lvl_cd = 'PLAN'

Line 3005: From ben_elig_per_elctbl_chc epe

3001: ben_ptip_f ptip
3002: Where
3003: ptip.pl_typ_id=pt.pl_typ_id
3004: and pt.pl_typ_id in ( Select epe.pl_typ_id
3005: From ben_elig_per_elctbl_chc epe
3006: Where epe.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
3007: and epe.comp_lvl_cd = 'PLAN'
3008: and epe.pgm_id=ptip.pgm_id
3009: )

Line 3025: ben_elig_per_elctbl_chc epe

3021: pl.nip_acty_ref_perd_cd acty_ref_perd_cd,
3022: epe.elctbl_flag,
3023: epe.elig_per_elctbl_chc_id
3024: From ben_pl_f pl,
3025: ben_elig_per_elctbl_chc epe
3026: Where
3027: epe.per_in_ler_id = p_per_in_ler_id
3028: and epe.comp_lvl_cd = 'PLAN'
3029: and epe.pl_id = pl.pl_id

Line 3040: From ben_elig_per_elctbl_chc epe,

3036: oipl.oipl_id,
3037: opt.name,
3038: epe.elctbl_flag,
3039: epe.elig_per_elctbl_chc_id
3040: From ben_elig_per_elctbl_chc epe,
3041: ben_oipl_f oipl,
3042: ben_opt_f opt
3043: Where epe.per_in_ler_id = p_per_in_ler_id
3044: AND epe.plip_id = p_plip_id

Line 3057: From ben_elig_per_elctbl_chc epe,

3053: oipl.oipl_id,
3054: opt.name,
3055: epe.elctbl_flag,
3056: epe.elig_per_elctbl_chc_id
3057: From ben_elig_per_elctbl_chc epe,
3058: ben_oipl_f oipl,
3059: ben_opt_f opt
3060: Where epe.per_in_ler_id = p_per_in_ler_id
3061: AND epe.plip_id is NULL and epe.pl_id=p_pl_id