APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 6579: from ben_prmry_care_prvdr_f pf,

6575:
6576:
6577: cursor c_prmry_care_actn is
6578: select 'x'
6579: from ben_prmry_care_prvdr_f pf,
6580: ben_elig_cvrd_dpnt_f ecd
6581: where pf.elig_cvrd_dpnt_id = ecd.elig_cvrd_dpnt_id
6582: -- and ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id bug 1421978
6583: and ecd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id

Line 6771: from ben_prmry_care_prvdr_f pf

6767: l_suspend_flag varchar2(20);
6768:
6769: cursor c_prmry_care_actn is
6770: select 'x'
6771: from ben_prmry_care_prvdr_f pf
6772: where pf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6773: and pf.business_group_id = p_business_group_id
6774: and p_effective_date between pf.effective_start_date
6775: and pf.effective_end_date;