DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_PCP

Line 7062: ben_pl_pcp pcp

7058: select pcp.pcp_dpnt_dsgn_cd ,
7059: ecd.elig_cvrd_dpnt_id
7060: from ben_prtt_enrt_rslt_f pen,
7061: ben_elig_cvrd_dpnt_f ecd,
7062: ben_pl_pcp pcp
7063: where pcp.pl_id = pen.pl_id
7064: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7065: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
7066: and ecd.cvg_strt_dt is not null

Line 7239: ben_pl_pcp pcp

7235: -- added the cop.pcp_dsgn_cd is not null condition bug 1421978
7236: cursor c_pcp_cd is
7237: select pcp.pcp_dsgn_cd
7238: from ben_prtt_enrt_rslt_f perf,
7239: ben_pl_pcp pcp
7240: where pcp.pl_id = perf.pl_id
7241: and perf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7242: and perf.business_group_id = p_business_group_id
7243: and pcp.business_group_id = p_business_group_id