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_COBRA_REQUIREMENTS dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 357: from ben_elig_to_prte_rsn_f peo

353:
354: --
355: cursor c_get_dsblty_max_poe is
356: select peo.*
357: from ben_elig_to_prte_rsn_f peo
358: where peo.ler_id = l_dsblty_ler_id
359: and peo.business_group_id = p_business_group_id
360: and nvl(p_lf_evt_ocrd_dt, p_effective_date)
361: between peo.effective_start_date and peo.effective_end_date

Line 450: from ben_elig_to_prte_rsn_f peo

446: cursor c_get_max_poe is
447: select peo.*
448: ,ler.typ_cd
449: ,pil.lf_evt_ocrd_dt
450: from ben_elig_to_prte_rsn_f peo
451: ,ben_per_in_ler pil
452: ,ben_ler_f ler
453: where pil.ler_id = peo.ler_id
454: and pil.per_in_ler_id = p_per_in_ler_id

Line 570: ,ben_elig_to_prte_rsn_f peo

566: ,pil.lf_evt_ocrd_dt
567: from ben_ler_f ler
568: ,ben_per_in_ler pil
569: ,ben_cbr_per_in_ler crp
570: ,ben_elig_to_prte_rsn_f peo
571: where ler.ler_id = pil.ler_id
572: and pil.per_in_ler_id = crp.per_in_ler_id
573: and crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
574: and pil.business_group_id = p_business_group_id