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_DPNT_COMM dependencies on BEN_ELIG_DPNT

Line 153: from ben_elig_dpnt egd1

149: and ctu.cm_typ_id = p_cm_typ_id
150: and ctu.all_r_any_cd = 'ALL'
151: and exists
152: (select null
153: from ben_elig_dpnt egd1
154: where egd1.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
155: and egd1.business_group_id = epe.business_group_id
156: and egd1.dpnt_person_id = p_rcpent_person_id
157: and egd1.per_in_ler_id = pil.per_in_ler_id

Line 171: from ben_elig_dpnt egd1

167: and epe.per_in_ler_id = pil.per_in_ler_id
168: and epe.elctbl_flag = 'Y'
169: and exists
170: (select null
171: from ben_elig_dpnt egd1
172: where egd1.business_group_id = pil.business_group_id
173: and egd1.dpnt_person_id = p_rcpent_person_id
174: and egd1.per_in_ler_id = pil.per_in_ler_id
175: and egd1.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id

Line 4377: from ben_elig_dpnt egd,

4373: -- plan type with a started per in ler.
4374: --
4375: cursor c_epe is
4376: select 'Y'
4377: from ben_elig_dpnt egd,
4378: ben_elig_per_elctbl_chc epe,
4379: ben_per_in_ler pil,
4380: ben_pl_f pln,
4381: ben_oipl_f cop,