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_ELIG_PER_ELCTBL_CHC

Line 999: ben_elig_per_elctbl_chc epe

995: --
996: cursor c_epe_pgm(p_pgm_id number,p_pl_id number) IS
997: select epe.fonm_cvg_strt_dt
998: from ben_pil_elctbl_chc_popl popl,
999: ben_elig_per_elctbl_chc epe
1000: where popl.per_in_ler_id = p_per_in_ler_id
1001: and popl.pgm_id = p_pgm_id
1002: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id
1003: and NVL(epe.pl_id,-1) = nvl(p_pl_id, nvl(epe.pl_id,-1)) -- 5633934 : Added this condition

Line 1004: and not exists (select 'x' from ben_pil_elctbl_chc_popl popl1, ben_elig_per_elctbl_chc epe1

1000: where popl.per_in_ler_id = p_per_in_ler_id
1001: and popl.pgm_id = p_pgm_id
1002: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id
1003: and NVL(epe.pl_id,-1) = nvl(p_pl_id, nvl(epe.pl_id,-1)) -- 5633934 : Added this condition
1004: and not exists (select 'x' from ben_pil_elctbl_chc_popl popl1, ben_elig_per_elctbl_chc epe1
1005: where popl1.per_in_ler_id = p_per_in_ler_id
1006: and popl1.pgm_id = p_pgm_id
1007: and epe1.pil_elctbl_chc_popl_id = popl1.pil_elctbl_chc_popl_id
1008: and NVL(epe1.pl_id,-1) = nvl(p_pl_id, nvl(epe1.pl_id,-1))

Line 1014: ben_elig_per_elctbl_chc epe

1010: --
1011: cursor c_epe_pl(p_pl_id number) IS
1012: select epe.fonm_cvg_strt_dt
1013: from ben_pil_elctbl_chc_popl popl,
1014: ben_elig_per_elctbl_chc epe
1015: where popl.per_in_ler_id = p_per_in_ler_id
1016: and popl.pl_id = p_pl_id
1017: and epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id;
1018: --

Line 1765: FROM ben_elig_per_elctbl_chc epe

1761: AND ctu.business_group_id = pil.business_group_id
1762: AND NVL (ctu.ler_id, pil.ler_id) = pil.ler_id
1763: AND EXISTS (
1764: SELECT NULL
1765: FROM ben_elig_per_elctbl_chc epe
1766: WHERE epe.per_in_ler_id = pil.per_in_ler_id
1767: AND epe.business_group_id = pil.business_group_id
1768: AND epe.elctbl_flag = 'Y'
1769: AND NVL (ctu.pgm_id, NVL (epe.pgm_id, -1)) =

Line 1787: ben_elig_per_elctbl_chc epe

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
1790: and ctu.business_group_id = pil.business_group_id
1791:

Line 1817: from ben_elig_per_elctbl_chc epe,

1813: and ctu.all_r_any_cd = 'ALL'; */
1814: --
1815: cursor c2 is
1816: select null
1817: from ben_elig_per_elctbl_chc epe,
1818: ben_per_in_ler pil
1819: where pil.per_in_ler_id = p_per_in_ler_id
1820: and pil.business_group_id = p_business_group_id
1821: and epe.per_in_ler_id = pil.per_in_ler_id

Line 2014: from ben_elig_per_elctbl_chc epe

2010: and ctu.pl_typ_id is null
2011: and ctu.enrt_perd_id is null
2012: and ctu.actn_typ_id is null
2013: and not exists (select null
2014: from ben_elig_per_elctbl_chc epe
2015: where epe.business_group_id = p_business_group_id
2016: and epe.elctbl_flag = 'Y'
2017: and epe.per_in_ler_id = p_per_in_ler_id)
2018: and ben_generate_communications.g_comm_start_date

Line 2029: from ben_elig_per_elctbl_chc epe

2025: cursor c2 is
2026: select null
2027: from sys.dual
2028: where not exists (select null
2029: from ben_elig_per_elctbl_chc epe
2030: where epe.business_group_id = p_business_group_id
2031: and epe.elctbl_flag = 'Y'
2032: and epe.per_in_ler_id = p_per_in_ler_id);
2033: --

Line 2386: from ben_elig_per_elctbl_chc epe,

2382: l_c1 c1%rowtype;
2383: --
2384: cursor c2 is
2385: select null
2386: from ben_elig_per_elctbl_chc epe,
2387: ben_per_in_ler pil
2388: where pil.per_in_ler_id = p_per_in_ler_id
2389: and pil.business_group_id = p_business_group_id
2390: and epe.per_in_ler_id = pil.per_in_ler_id;

Line 2540: from ben_elig_per_elctbl_chc epe,

2536: l_c1 c1%rowtype;
2537: --
2538: cursor c2 is
2539: select null
2540: from ben_elig_per_elctbl_chc epe,
2541: ben_per_in_ler pil
2542: where pil.per_in_ler_id = p_per_in_ler_id
2543: and pil.business_group_id = p_business_group_id
2544: and epe.per_in_ler_id = pil.per_in_ler_id;

Line 3166: from ben_elig_per_elctbl_chc epe1

3162: and ctu.cm_typ_id = p_cm_typ_id
3163: and ctu.all_r_any_cd = 'ALL'
3164: and exists
3165: (select null
3166: from ben_elig_per_elctbl_chc epe1
3167: where epe1.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
3168: and epe1.elctbl_flag = 'Y');
3169: --
3170: cursor c2 is

Line 3172: from ben_elig_per_elctbl_chc epe

3168: and epe1.elctbl_flag = 'Y');
3169: --
3170: cursor c2 is
3171: select null
3172: from ben_elig_per_elctbl_chc epe
3173: where epe.per_in_ler_id = p_per_in_ler_id
3174: and epe.elctbl_flag = 'Y'
3175: and epe.business_group_id = p_business_group_id;
3176: --

Line 3780: from ben_elig_per_elctbl_chc epe,

3776: --
3777: cursor c_epe(v_pgm_id in number,
3778: v_pl_typ_id in number) is
3779: select 'Y'
3780: from ben_elig_per_elctbl_chc epe,
3781: ben_per_in_ler pil,
3782: ben_pl_f pln,
3783: ben_oipl_f cop,
3784: ben_opt_f opt