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 340: from ben_elig_to_prte_rsn_f peo

336:
337: --
338: cursor c_get_dsblty_max_poe is
339: select peo.*
340: from ben_elig_to_prte_rsn_f peo
341: where peo.ler_id = l_dsblty_ler_id
342: and peo.business_group_id = p_business_group_id
343: and nvl(p_lf_evt_ocrd_dt, p_effective_date)
344: between peo.effective_start_date and peo.effective_end_date

Line 433: from ben_elig_to_prte_rsn_f peo

429: cursor c_get_max_poe is
430: select peo.*
431: ,ler.typ_cd
432: ,pil.lf_evt_ocrd_dt
433: from ben_elig_to_prte_rsn_f peo
434: ,ben_per_in_ler pil
435: ,ben_ler_f ler
436: where pil.ler_id = peo.ler_id
437: and pil.per_in_ler_id = p_per_in_ler_id

Line 552: ,ben_elig_to_prte_rsn_f peo

548: ,pil.lf_evt_ocrd_dt
549: from ben_ler_f ler
550: ,ben_per_in_ler pil
551: ,ben_cbr_per_in_ler crp
552: ,ben_elig_to_prte_rsn_f peo
553: where ler.ler_id = pil.ler_id
554: and pil.per_in_ler_id = crp.per_in_ler_id
555: and crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
556: and pil.business_group_id = p_business_group_id