APPS.BEN_MNG_PRMRY_CARE_PRVDR dependencies on BEN_OIPL_F

Line 40: from ben_oipl_f cop

36: l_proc varchar2(72) := g_package||'fetch_pcp_dsgn_cd';
37:
38: cursor c_pcp is
39: select 1,decode(p_level,'PRTT',cop.pcp_dsgn_cd,'DPNT',cop.pcp_dpnt_dsgn_cd)
40: from ben_oipl_f cop
41: where oipl_id in (select pen.oipl_id
42: from ben_prtt_enrt_rslt_f pen
43: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
44: and prtt_enrt_rslt_stat_cd is null)