APPS.BEN_MNG_PRMRY_CARE_PRVDR dependencies on BEN_PL_PCP

Line 48: from ben_pl_pcp cop

44: and prtt_enrt_rslt_stat_cd is null)
45: and p_effective_date between cop.effective_Start_date and cop.effective_end_date
46: UNION
47: select 2,decode(p_level,'PRTT',cop.pcp_dsgn_cd,'DPNT',cop.pcp_dpnt_dsgn_cd)
48: from ben_pl_pcp cop
49: where pl_id in ( select pen.pl_id
50: from ben_prtt_enrt_rslt_f pen
51: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
52: and prtt_enrt_rslt_stat_cd is null)