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_COMMUNICATIONS dependencies on BEN_CM_TYP_USG_F

Line 1118: from ben_cm_typ_usg_f ctu,

1114: pil.per_in_ler_id,
1115: pep.elig_per_id,
1116: pep.pgm_id ppgm_id,
1117: pep.pl_id ppl_id
1118: from ben_cm_typ_usg_f ctu,
1119: ben_elig_per_f pep,
1120: ben_per_in_ler pil
1121: where ctu.business_group_id = p_business_group_id
1122: and pep.business_group_id = ctu.business_group_id

Line 1548: from ben_cm_typ_usg_f ctu,

1544: ctu.cm_usg_rl,
1545: ctu.pl_id, -- Bug 1555557
1546: ctu.pgm_id,
1547: ctu.pl_typ_id
1548: from ben_cm_typ_usg_f ctu,
1549: ben_prtt_enrt_rslt_f pen
1550: where ctu.business_group_id = p_business_group_id
1551: /* First join comp objects */
1552: and pen.business_group_id = ctu.business_group_id

Line 1742: FROM ben_cm_typ_usg_f ctu, ben_per_in_ler pil

1738: )
1739: IS
1740: SELECT ctu.cm_typ_usg_id, ctu.cm_usg_rl, ctu.pl_id, ctu.pgm_id,
1741: ctu.pl_typ_id
1742: FROM ben_cm_typ_usg_f ctu, ben_per_in_ler pil
1743: WHERE ctu.business_group_id = c_bgp_id
1744: AND ctu.cm_typ_id = c_cm_typ_id
1745: AND ctu.all_r_any_cd = 'ALL'
1746: AND ( c_asnd_lf_evt_dt IS NULL

Line 1785: from ben_cm_typ_usg_f ctu,

1781: ctu.cm_usg_rl,
1782: ctu.pl_id,
1783: ctu.pgm_id,
1784: ctu.pl_typ_id
1785: from ben_cm_typ_usg_f ctu,
1786: ben_per_in_ler pil,
1787: ben_elig_per_elctbl_chc epe
1788: where pil.per_in_ler_id = c_pil_id
1789: and pil.business_group_id = c_bgp_id

Line 2004: from ben_cm_typ_usg_f ctu

2000: --
2001: cursor c1 is
2002: select ctu.cm_typ_usg_id,
2003: ctu.cm_usg_rl
2004: from ben_cm_typ_usg_f ctu
2005: where ctu.business_group_id = p_business_group_id
2006: and ctu.cm_typ_id = p_cm_typ_id
2007: and ctu.ler_id = p_ler_id
2008: and ctu.pgm_id is null

Line 2152: from ben_cm_typ_usg_f ctu,

2148: ctu.cm_usg_rl,
2149: ctu.pl_id, -- Bug 1555557
2150: ctu.pgm_id,
2151: ctu.pl_typ_id
2152: from ben_cm_typ_usg_f ctu,
2153: ben_prtt_enrt_rslt_f pen,
2154: ben_per_in_ler pil
2155: where ctu.business_group_id = p_business_group_id
2156: /* First join comp objects */

Line 2339: from ben_cm_typ_usg_f ctu,

2335: ctu.cm_usg_rl,
2336: ctu.pl_id, -- Bug 1555557
2337: ctu.pgm_id,
2338: ctu.pl_typ_id
2339: from ben_cm_typ_usg_f ctu,
2340: ben_prtt_enrt_rslt_f pen,
2341: ben_pil_elctbl_chc_popl pel
2342: where ctu.business_group_id = p_business_group_id
2343: /* First join comp objects */

Line 2506: from ben_cm_typ_usg_f ctu,

2502: ctu.cm_usg_rl,
2503: ctu.pl_id, -- Bug 1555557
2504: ctu.pgm_id,
2505: ctu.pl_typ_id
2506: from ben_cm_typ_usg_f ctu,
2507: ben_prtt_enrt_rslt_f pen,
2508: ben_pil_elctbl_chc_popl pel
2509: where ctu.business_group_id = p_business_group_id
2510: /* First join comp objects */

Line 2657: from ben_cm_typ_usg_f ctu

2653: --
2654: cursor c1 is
2655: select ctu.cm_typ_usg_id,
2656: ctu.cm_usg_rl
2657: from ben_cm_typ_usg_f ctu
2658: where ctu.business_group_id = p_business_group_id
2659: and (p_ler_id is null or
2660: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
2661: and (p_pgm_id is null or

Line 2776: from ben_cm_typ_usg_f ctu

2772: --
2773: cursor c1 is
2774: select ctu.cm_typ_usg_id,
2775: ctu.cm_usg_rl
2776: from ben_cm_typ_usg_f ctu
2777: where ctu.business_group_id = p_business_group_id
2778: and (p_ler_id is null or
2779: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
2780: and (p_pgm_id is null or

Line 2899: from ben_cm_typ_usg_f ctu

2895: --
2896: cursor c1 is
2897: select ctu.cm_typ_usg_id,
2898: ctu.cm_usg_rl
2899: from ben_cm_typ_usg_f ctu
2900: where ctu.business_group_id = p_business_group_id
2901: and (p_pgm_id is null or
2902: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
2903: and (p_pl_id is null or

Line 3013: from ben_cm_typ_usg_f ctu

3009: --
3010: cursor c_mssmlg is
3011: select ctu.cm_typ_usg_id,
3012: ctu.cm_usg_rl
3013: from ben_cm_typ_usg_f ctu
3014: where ctu.business_group_id = p_business_group_id
3015: and (p_pgm_id is null or
3016: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
3017: and (p_pl_id is null or

Line 3131: from ben_cm_typ_usg_f ctu,

3127: --
3128: cursor c1 is
3129: select ctu.cm_typ_usg_id,
3130: ctu.cm_usg_rl
3131: from ben_cm_typ_usg_f ctu,
3132: ben_pil_elctbl_chc_popl pel
3133: where ctu.business_group_id = p_business_group_id
3134: and pel.business_group_id = ctu.business_group_id
3135: and (p_ler_id is null or

Line 3286: from ben_cm_typ_usg_f ctu

3282: --
3283: cursor c1 is
3284: select ctu.cm_typ_usg_id,
3285: ctu.cm_usg_rl
3286: from ben_cm_typ_usg_f ctu
3287: where ctu.business_group_id = p_business_group_id
3288: and (p_pl_id is null or
3289: nvl(ctu.pl_id,p_pl_id) = p_pl_id)
3290: and (p_pgm_id is null or

Line 3409: from ben_cm_typ_usg_f ctu,

3405: ctu.cm_usg_rl,
3406: ctu.pl_id, -- Bug 1555557
3407: ctu.pgm_id,
3408: ctu.pl_typ_id
3409: from ben_cm_typ_usg_f ctu,
3410: ben_prtt_enrt_rslt_f pen,
3411: ben_prtt_rt_val prv
3412: where ctu.business_group_id = p_business_group_id
3413: /* First join comp objects */

Line 3585: from ben_cm_typ_usg_f ctu

3581: --
3582: cursor c1 is
3583: select ctu.cm_typ_usg_id,
3584: ctu.cm_usg_rl
3585: from ben_cm_typ_usg_f ctu
3586: where ctu.business_group_id = p_business_group_id
3587: and (p_ler_id is null or
3588: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
3589: and (p_pgm_id is null or

Line 3875: from ben_cm_typ_usg_f ctu

3871: cursor c_cm_typ_pl_typ is
3872: select ctu.pl_typ_id,
3873: ctu.cm_typ_usg_id,
3874: ctu.cm_usg_rl
3875: from ben_cm_typ_usg_f ctu
3876: where ctu.business_group_id = p_business_group_id
3877: and (p_ler_id is null or
3878: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
3879: and (p_pgm_id is null or