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_PL_TYP_F

Line 2319: From ben_pl_typ_f pt,

2315: --------------------------Plan type not in program------------------
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

Line 2335: ben_pl_typ_f pt

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'
2339: and p_effective_date between pt.effective_start_date and pt.effective_end_date;*/

Line 2344: From ben_pl_typ_f pt,

2340: CURSOR csr_pl_types_in_program(p_pil_elctbl_chc_popl_id NUMBER) IS
2341: Select pt.pl_typ_id,
2342: pt.name,
2343: ptip.ptip_id
2344: From ben_pl_typ_f pt,
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

Line 2974: From ben_pl_typ_f pt

2970: --------------------------Plan type not in program------------------
2971: CURSOR csr_pl_types_not_in_program(p_per_in_ler_id NUMBER) IS
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

Line 2991: ben_pl_typ_f pt

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'
2995: and p_effective_date between pt.effective_start_date and pt.effective_end_date;*/

Line 3000: From ben_pl_typ_f pt,

2996: CURSOR csr_pl_types_in_program(p_pil_elctbl_chc_popl_id NUMBER) IS
2997: Select pt.pl_typ_id,
2998: pt.name,
2999: ptip.ptip_id
3000: From ben_pl_typ_f pt,
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