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 937: from ben_cm_typ_usg_f ctu,

933: ctu.pl_id, -- Bug 1555557
934: ctu.pgm_id,
935: ctu.ler_id,
936: ctu.pl_typ_id
937: from ben_cm_typ_usg_f ctu,
938: ben_elig_per_f pep,
939: ben_per_in_ler pil
940: where ctu.business_group_id = p_business_group_id
941: and pep.business_group_id = ctu.business_group_id

Line 1309: from ben_cm_typ_usg_f ctu,

1305: ctu.cm_usg_rl,
1306: ctu.pl_id, -- Bug 1555557
1307: ctu.pgm_id,
1308: ctu.pl_typ_id
1309: from ben_cm_typ_usg_f ctu,
1310: ben_prtt_enrt_rslt_f pen
1311: where ctu.business_group_id = p_business_group_id
1312: /* First join comp objects */
1313: and pen.business_group_id = ctu.business_group_id

Line 1503: FROM ben_cm_typ_usg_f ctu, ben_per_in_ler pil

1499: )
1500: IS
1501: SELECT ctu.cm_typ_usg_id, ctu.cm_usg_rl, ctu.pl_id, ctu.pgm_id,
1502: ctu.pl_typ_id
1503: FROM ben_cm_typ_usg_f ctu, ben_per_in_ler pil
1504: WHERE ctu.business_group_id = c_bgp_id
1505: AND ctu.cm_typ_id = c_cm_typ_id
1506: AND ctu.all_r_any_cd = 'ALL'
1507: AND ( c_asnd_lf_evt_dt IS NULL

Line 1546: from ben_cm_typ_usg_f ctu,

1542: ctu.cm_usg_rl,
1543: ctu.pl_id,
1544: ctu.pgm_id,
1545: ctu.pl_typ_id
1546: from ben_cm_typ_usg_f ctu,
1547: ben_per_in_ler pil,
1548: ben_elig_per_elctbl_chc epe
1549: where pil.per_in_ler_id = c_pil_id
1550: and pil.business_group_id = c_bgp_id

Line 1765: from ben_cm_typ_usg_f ctu

1761: --
1762: cursor c1 is
1763: select ctu.cm_typ_usg_id,
1764: ctu.cm_usg_rl
1765: from ben_cm_typ_usg_f ctu
1766: where ctu.business_group_id = p_business_group_id
1767: and ctu.cm_typ_id = p_cm_typ_id
1768: and ctu.ler_id = p_ler_id
1769: and ctu.pgm_id is null

Line 1913: from ben_cm_typ_usg_f ctu,

1909: ctu.cm_usg_rl,
1910: ctu.pl_id, -- Bug 1555557
1911: ctu.pgm_id,
1912: ctu.pl_typ_id
1913: from ben_cm_typ_usg_f ctu,
1914: ben_prtt_enrt_rslt_f pen,
1915: ben_per_in_ler pil
1916: where ctu.business_group_id = p_business_group_id
1917: /* First join comp objects */

Line 2100: from ben_cm_typ_usg_f ctu,

2096: ctu.cm_usg_rl,
2097: ctu.pl_id, -- Bug 1555557
2098: ctu.pgm_id,
2099: ctu.pl_typ_id
2100: from ben_cm_typ_usg_f ctu,
2101: ben_prtt_enrt_rslt_f pen,
2102: ben_pil_elctbl_chc_popl pel
2103: where ctu.business_group_id = p_business_group_id
2104: /* First join comp objects */

Line 2267: from ben_cm_typ_usg_f ctu,

2263: ctu.cm_usg_rl,
2264: ctu.pl_id, -- Bug 1555557
2265: ctu.pgm_id,
2266: ctu.pl_typ_id
2267: from ben_cm_typ_usg_f ctu,
2268: ben_prtt_enrt_rslt_f pen,
2269: ben_pil_elctbl_chc_popl pel
2270: where ctu.business_group_id = p_business_group_id
2271: /* First join comp objects */

Line 2418: from ben_cm_typ_usg_f ctu

2414: --
2415: cursor c1 is
2416: select ctu.cm_typ_usg_id,
2417: ctu.cm_usg_rl
2418: from ben_cm_typ_usg_f ctu
2419: where ctu.business_group_id = p_business_group_id
2420: and (p_ler_id is null or
2421: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
2422: and (p_pgm_id is null or

Line 2537: from ben_cm_typ_usg_f ctu

2533: --
2534: cursor c1 is
2535: select ctu.cm_typ_usg_id,
2536: ctu.cm_usg_rl
2537: from ben_cm_typ_usg_f ctu
2538: where ctu.business_group_id = p_business_group_id
2539: and (p_ler_id is null or
2540: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
2541: and (p_pgm_id is null or

Line 2660: from ben_cm_typ_usg_f ctu

2656: --
2657: cursor c1 is
2658: select ctu.cm_typ_usg_id,
2659: ctu.cm_usg_rl
2660: from ben_cm_typ_usg_f ctu
2661: where ctu.business_group_id = p_business_group_id
2662: and (p_pgm_id is null or
2663: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
2664: and (p_pl_id is null or

Line 2774: from ben_cm_typ_usg_f ctu

2770: --
2771: cursor c_mssmlg is
2772: select ctu.cm_typ_usg_id,
2773: ctu.cm_usg_rl
2774: from ben_cm_typ_usg_f ctu
2775: where ctu.business_group_id = p_business_group_id
2776: and (p_pgm_id is null or
2777: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
2778: and (p_pl_id is null or

Line 2892: from ben_cm_typ_usg_f ctu,

2888: --
2889: cursor c1 is
2890: select ctu.cm_typ_usg_id,
2891: ctu.cm_usg_rl
2892: from ben_cm_typ_usg_f ctu,
2893: ben_pil_elctbl_chc_popl pel
2894: where ctu.business_group_id = p_business_group_id
2895: and pel.business_group_id = ctu.business_group_id
2896: and (p_ler_id is null or

Line 3047: from ben_cm_typ_usg_f ctu

3043: --
3044: cursor c1 is
3045: select ctu.cm_typ_usg_id,
3046: ctu.cm_usg_rl
3047: from ben_cm_typ_usg_f ctu
3048: where ctu.business_group_id = p_business_group_id
3049: and (p_pl_id is null or
3050: nvl(ctu.pl_id,p_pl_id) = p_pl_id)
3051: and (p_pgm_id is null or

Line 3170: from ben_cm_typ_usg_f ctu,

3166: ctu.cm_usg_rl,
3167: ctu.pl_id, -- Bug 1555557
3168: ctu.pgm_id,
3169: ctu.pl_typ_id
3170: from ben_cm_typ_usg_f ctu,
3171: ben_prtt_enrt_rslt_f pen,
3172: ben_prtt_rt_val prv
3173: where ctu.business_group_id = p_business_group_id
3174: /* First join comp objects */

Line 3346: from ben_cm_typ_usg_f ctu

3342: --
3343: cursor c1 is
3344: select ctu.cm_typ_usg_id,
3345: ctu.cm_usg_rl
3346: from ben_cm_typ_usg_f ctu
3347: where ctu.business_group_id = p_business_group_id
3348: and (p_ler_id is null or
3349: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
3350: and (p_pgm_id is null or