APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 6664: from ben_prmry_care_prvdr_f pf,

6660:
6661:
6662: cursor c_prmry_care_actn is
6663: select 'x'
6664: from ben_prmry_care_prvdr_f pf,
6665: ben_elig_cvrd_dpnt_f ecd
6666: where pf.elig_cvrd_dpnt_id = ecd.elig_cvrd_dpnt_id
6667: -- and ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id bug 1421978
6668: and ecd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id

Line 6856: from ben_prmry_care_prvdr_f pf

6852: l_suspend_flag varchar2(20);
6853:
6854: cursor c_prmry_care_actn is
6855: select 'x'
6856: from ben_prmry_care_prvdr_f pf
6857: where pf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6858: and pf.business_group_id = p_business_group_id
6859: and p_effective_date between pf.effective_start_date
6860: and pf.effective_end_date;