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_MNG_PRMRY_CARE_PRVDR dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 186: from ben_prmry_care_prvdr_f pcp

182: PPR_ATTRIBUTE27,
183: PPR_ATTRIBUTE28,
184: PPR_ATTRIBUTE29,
185: PPR_ATTRIBUTE30
186: from ben_prmry_care_prvdr_f pcp
187: where pcp.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
188: and pcp.elig_cvrd_dpnt_id is null
189: and pcp.business_group_id = p_business_group_id
190: and p_effective_date between pcp.effective_start_date

Line 240: ben_prmry_care_prvdr_f pcp,

236: from ben_prtt_enrt_rslt_f r,
237: ben_prtt_enrt_rslt_f r2,
238: ben_elig_cvrd_dpnt_f d,
239: ben_elig_cvrd_dpnt_f d2,
240: ben_prmry_care_prvdr_f pcp,
241: ben_per_in_ler pil,
242: ben_per_in_ler pil2
243: where r.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
244: and r2.prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id