DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_PCP

Line 6977: ben_pl_pcp pcp

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

Line 7154: ben_pl_pcp pcp

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