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 3951: from ben_prmry_care_prvdr_f ppr

3947: ,ppr.PROGRAM_APPLICATION_ID
3948: ,ppr.PROGRAM_ID
3949: ,ppr.PROGRAM_UPDATE_DATE
3950: ,ppr.OBJECT_VERSION_NUMBER
3951: from ben_prmry_care_prvdr_f ppr
3952: where ppr.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id -- Bug 3709516
3953: and ppr.business_group_id = p_business_group_id
3954: and p_effective_date between ppr.effective_start_date and ppr.effective_end_date; --Added p_effective_date condition for Bug 7497016
3955: --

Line 4008: from ben_prmry_care_prvdr_f ppr

4004: ,ppr.PROGRAM_APPLICATION_ID
4005: ,ppr.PROGRAM_ID
4006: ,ppr.PROGRAM_UPDATE_DATE
4007: ,ppr.OBJECT_VERSION_NUMBER
4008: from ben_prmry_care_prvdr_f ppr
4009: where ppr.elig_cvrd_dpnt_id = p_bckdt_elig_cvrd_dpnt_id -- Bug 3709516
4010: and ppr.business_group_id = p_business_group_id ;
4011:
4012: -- 5123666

Line 4016: FROM ben_prmry_care_prvdr_f ppr

4012: -- 5123666
4013: CURSOR c_curr_ppr(c_prmry_care_prvdr_id in number)
4014: IS
4015: SELECT *
4016: FROM ben_prmry_care_prvdr_f ppr
4017: WHERE ppr.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4018: AND ppr.business_group_id = p_business_group_id
4019: AND ppr.prmry_care_prvdr_id = c_prmry_care_prvdr_id
4020: AND NVL (ppr.elig_cvrd_dpnt_id, -1) = NVL (p_elig_cvrd_dpnt_id, -1)