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 3518: -- Cursor to select rows from ben_per_in_ler for people that haven't enrolled

3514: -- ----------------------------------------------------------------------------
3515: --
3516: procedure create_enrtrmdr_ranges is
3517: --
3518: -- Cursor to select rows from ben_per_in_ler for people that haven't enrolled
3519: -- in a plan or a program as of the effective date
3520: --
3521: cursor c_pil_enrtrmdr is
3522: select distinct pil.person_id, pil.ler_id

Line 3523: from ben_per_in_ler pil,

3519: -- in a plan or a program as of the effective date
3520: --
3521: cursor c_pil_enrtrmdr is
3522: select distinct pil.person_id, pil.ler_id
3523: from ben_per_in_ler pil,
3524: ben_pil_elctbl_chc_popl pel,
3525: ben_ler_f ler
3526: where (g_parm.person_id is null or
3527: pil.person_id = g_parm.person_id)

Line 3674: ben_per_in_ler pil,

3670: cursor c_per_actnrmdr is
3671: select distinct ppf.person_id
3672: from per_all_people_f ppf,
3673: ben_prtt_enrt_rslt_f pen,
3674: ben_per_in_ler pil,
3675: ben_prtt_enrt_actn_f pea
3676: where (g_parm.person_id is null or
3677: ppf.person_id = g_parm.person_id)
3678: and g_parm.effective_date between ppf.effective_start_date

Line 3907: ben_per_in_ler pil

3903: cursor c_elig(v_person_id number) is
3904: select elig.pgm_id,
3905: elig.pl_id
3906: from ben_elig_per_f elig,
3907: ben_per_in_ler pil
3908: where elig.person_id = v_person_id
3909: and (g_parm.pgm_id is null or
3910: elig.pgm_id = g_parm.pgm_id)
3911: and ((g_parm.pl_nip_id is null

Line 4178: ben_per_in_ler pil

4174: and
4175: -- check if the person is eligible for the comp object
4176: exists (select 's'
4177: from ben_elig_per_f elig,
4178: ben_per_in_ler pil
4179: where elig.person_id = ppf.person_id
4180: and elig.pgm_id = g_parm.pgm_id
4181: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and elig.pgm_id is not null)
4182: and elig.elig_flag = 'Y'

Line 4260: ben_per_in_ler pil

4256: and
4257: -- check if the person is eligible for the comp object
4258: exists (select 's'
4259: from ben_elig_per_f elig,
4260: ben_per_in_ler pil
4261: where elig.person_id = ppf.person_id
4262: and g_parm.pgm_id is null
4263: and (g_parm.pl_nip_id is not null and g_parm.plan_in_pgm_flag = 'N' and elig.pgm_id is null)
4264: and g_parm.pl_nip_id = elig.pl_id