6973: select pcp.pcp_dpnt_dsgn_cd ,
6974: ecd.elig_cvrd_dpnt_id
6975: from ben_prtt_enrt_rslt_f pen,
6976: ben_elig_cvrd_dpnt_f ecd,
6977: ben_pl_pcp pcp
6978: where pcp.pl_id = pen.pl_id
6979: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6980: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
6981: and ecd.cvg_strt_dt is not null
7150: -- added the cop.pcp_dsgn_cd is not null condition bug 1421978
7151: cursor c_pcp_cd is
7152: select pcp.pcp_dsgn_cd
7153: from ben_prtt_enrt_rslt_f perf,
7154: ben_pl_pcp pcp
7155: where pcp.pl_id = perf.pl_id
7156: and perf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7157: and perf.business_group_id = p_business_group_id
7158: and pcp.business_group_id = p_business_group_id