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

Line 4181: from ben_prmry_care_prvdr_f ppr

4177: ,ppr.PROGRAM_APPLICATION_ID
4178: ,ppr.PROGRAM_ID
4179: ,ppr.PROGRAM_UPDATE_DATE
4180: ,ppr.OBJECT_VERSION_NUMBER
4181: from ben_prmry_care_prvdr_f ppr
4182: where ppr.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id -- Bug 3709516
4183: and ppr.business_group_id = p_business_group_id
4184: and p_effective_date between ppr.effective_start_date and ppr.effective_end_date; --Added p_effective_date condition for Bug 7497016
4185: --

Line 4238: from ben_prmry_care_prvdr_f ppr

4234: ,ppr.PROGRAM_APPLICATION_ID
4235: ,ppr.PROGRAM_ID
4236: ,ppr.PROGRAM_UPDATE_DATE
4237: ,ppr.OBJECT_VERSION_NUMBER
4238: from ben_prmry_care_prvdr_f ppr
4239: where ppr.elig_cvrd_dpnt_id = p_bckdt_elig_cvrd_dpnt_id -- Bug 3709516
4240: and ppr.business_group_id = p_business_group_id
4241: and p_effective_date between ppr.effective_start_date and ppr.effective_end_date; -- Bug 11667555
4242:

Line 4247: FROM ben_prmry_care_prvdr_f ppr

4243: -- 5123666
4244: CURSOR c_curr_ppr(c_prmry_care_prvdr_id in number)
4245: IS
4246: SELECT *
4247: FROM ben_prmry_care_prvdr_f ppr
4248: WHERE ppr.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4249: AND ppr.business_group_id = p_business_group_id
4250: AND ppr.prmry_care_prvdr_id = c_prmry_care_prvdr_id
4251: AND NVL (ppr.elig_cvrd_dpnt_id, -1) = NVL (p_elig_cvrd_dpnt_id, -1)