APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_PL_PCP

Line 340: FROM ben_pl_pcp pcp

336: )
337: OR EXISTS /* Participant / Dependent Requires Primary Care Physician */
338: (
339: SELECT 1
340: FROM ben_pl_pcp pcp
341: WHERE pcp.pl_id = pln.pl_id
342: AND ( pcp.pcp_dsgn_cd = 'R'
343: OR pcp.pcp_dpnt_dsgn_cd = 'R'
344: ))