APPS.HR_AUTH_BRIDGE dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 147: FROM ben_prmry_care_prvdr_f pcp

143:
144: CURSOR c_pcp IS
145: SELECT pcp.name ||' '||
146: HR_GENERAL.DECODE_LOOKUP('BEN_PRMRY_CARE_PRVDR_TYP',pcp.prmry_care_prvdr_typ_cd) primary_care_provider
147: FROM ben_prmry_care_prvdr_f pcp
148: WHERE pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
149: AND pcp.business_group_id = p_business_group_id
150: AND p_effective_date BETWEEN pcp.effective_start_date AND pcp.effective_end_date;
151: