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_DETERMINE_COMMUNICATIONS dependencies on BEN_PER_IN_LER

Line 3460: -- Cursor to select rows from ben_per_in_ler for people that haven't enrolled

3456: -- ----------------------------------------------------------------------------
3457: --
3458: procedure create_enrtrmdr_ranges is
3459: --
3460: -- Cursor to select rows from ben_per_in_ler for people that haven't enrolled
3461: -- in a plan or a program as of the effective date
3462: --
3463: cursor c_pil_enrtrmdr is
3464: select distinct pil.person_id, pil.ler_id

Line 3465: from ben_per_in_ler pil,

3461: -- in a plan or a program as of the effective date
3462: --
3463: cursor c_pil_enrtrmdr is
3464: select distinct pil.person_id, pil.ler_id
3465: from ben_per_in_ler pil,
3466: ben_pil_elctbl_chc_popl pel,
3467: ben_ler_f ler
3468: where (g_parm.person_id is null or
3469: pil.person_id = g_parm.person_id)

Line 3616: ben_per_in_ler pil,

3612: cursor c_per_actnrmdr is
3613: select distinct ppf.person_id
3614: from per_all_people_f ppf,
3615: ben_prtt_enrt_rslt_f pen,
3616: ben_per_in_ler pil,
3617: ben_prtt_enrt_actn_f pea
3618: where (g_parm.person_id is null or
3619: ppf.person_id = g_parm.person_id)
3620: and g_parm.effective_date between ppf.effective_start_date

Line 3849: ben_per_in_ler pil

3845: cursor c_elig(v_person_id number) is
3846: select elig.pgm_id,
3847: elig.pl_id
3848: from ben_elig_per_f elig,
3849: ben_per_in_ler pil
3850: where elig.person_id = v_person_id
3851: and (g_parm.pgm_id is null or
3852: elig.pgm_id = g_parm.pgm_id)
3853: and ((g_parm.pl_nip_id is null

Line 4117: ben_per_in_ler pil

4113: and
4114: -- check if the person is eligible for the comp object
4115: exists (select 's'
4116: from ben_elig_per_f elig,
4117: ben_per_in_ler pil
4118: where elig.person_id = ppf.person_id
4119: and elig.pgm_id = g_parm.pgm_id
4120: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and elig.pgm_id is not null)
4121: and elig.elig_flag = 'Y'

Line 4199: ben_per_in_ler pil

4195: and
4196: -- check if the person is eligible for the comp object
4197: exists (select 's'
4198: from ben_elig_per_f elig,
4199: ben_per_in_ler pil
4200: where elig.person_id = ppf.person_id
4201: and g_parm.pgm_id is null
4202: and (g_parm.pl_nip_id is not null and g_parm.plan_in_pgm_flag = 'N' and elig.pgm_id is null)
4203: and g_parm.pl_nip_id = elig.pl_id