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

Line 1881: ben_pil_elctbl_chc_popl pel

1877: select ctu.cm_typ_usg_id,
1878: ctu.cm_usg_rl
1879: from ben_cm_typ_usg_f ctu,
1880: ben_prtt_enrt_rslt_f pen,
1881: ben_pil_elctbl_chc_popl pel
1882: where ctu.business_group_id = p_business_group_id
1883: and pen.prtt_enrt_rslt_stat_cd is null
1884: /* First join comp objects */
1885: and pen.business_group_id = ctu.business_group_id

Line 1947: ben_pil_elctbl_chc_popl pel

1943: select ctu.cm_typ_usg_id,
1944: ctu.cm_usg_rl
1945: from ben_cm_typ_usg_f ctu,
1946: ben_prtt_enrt_rslt_f pen,
1947: ben_pil_elctbl_chc_popl pel
1948: where ctu.business_group_id = p_business_group_id
1949: and pen.prtt_enrt_rslt_stat_cd is null
1950: /* First join comp objects */
1951: and pen.business_group_id = ctu.business_group_id

Line 2232: ben_pil_elctbl_chc_popl pel

2228: cursor c_dpnt_usage is
2229: select ctu.cm_typ_usg_id,
2230: ctu.cm_usg_rl
2231: from ben_cm_typ_usg_f ctu,
2232: ben_pil_elctbl_chc_popl pel
2233: where ctu.business_group_id = p_business_group_id
2234: and pel.business_group_id = ctu.business_group_id
2235: and pel.per_in_ler_id = p_per_in_ler_id
2236: /* Use nvl here as only pgm or pl can be populated */

Line 2275: ben_pil_elctbl_chc_popl pel

2271: cursor c_bnf_usage is
2272: select ctu.cm_typ_usg_id,
2273: ctu.cm_usg_rl
2274: from ben_cm_typ_usg_f ctu,
2275: ben_pil_elctbl_chc_popl pel
2276: where ctu.business_group_id = p_business_group_id
2277: and pel.business_group_id = ctu.business_group_id
2278: and pel.per_in_ler_id = p_per_in_ler_id
2279: /* Use nvl here as only pgm or pl can be populated */

Line 3448: ben_pil_elctbl_chc_popl pel

3444: cursor c_dpnt_usage is
3445: select ctu.cm_typ_usg_id,
3446: ctu.cm_usg_rl
3447: from ben_cm_typ_usg_f ctu,
3448: ben_pil_elctbl_chc_popl pel
3449: where ctu.business_group_id = p_business_group_id
3450: and pel.business_group_id = ctu.business_group_id
3451: and (p_ler_id is null or
3452: nvl(ctu.ler_id,p_ler_id) = p_ler_id)

Line 3505: ben_pil_elctbl_chc_popl pel

3501: cursor c_bnf_usage is
3502: select ctu.cm_typ_usg_id,
3503: ctu.cm_usg_rl
3504: from ben_cm_typ_usg_f ctu,
3505: ben_pil_elctbl_chc_popl pel
3506: where ctu.business_group_id = p_business_group_id
3507: and pel.business_group_id = ctu.business_group_id
3508: and (p_ler_id is null or
3509: nvl(ctu.ler_id,p_ler_id) = p_ler_id)