APPS.BEN_DM_DELETE dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 115: delete from ben_prmry_care_prvdr_f pcp

111: (select cbf.cbr_quald_bnf_id from ben_cbr_quald_bnf cbf where cbf.quald_bnf_person_id = p_person_id);
112:
113: delete from ben_cbr_quald_bnf where quald_bnf_person_id = p_person_id;
114:
115: delete from ben_prmry_care_prvdr_f pcp
116: where pcp.prtt_enrt_rslt_id in
117: (select pen.prtt_enrt_rslt_id
118: from ben_prtt_enrt_rslt_f pen
119: where pen.person_id = p_person_id);

Line 121: delete from ben_prmry_care_prvdr_f pcp

117: (select pen.prtt_enrt_rslt_id
118: from ben_prtt_enrt_rslt_f pen
119: where pen.person_id = p_person_id);
120:
121: delete from ben_prmry_care_prvdr_f pcp
122: where pcp.elig_cvrd_dpnt_id in
123: (select egd.elig_cvrd_dpnt_id
124: from ben_elig_cvrd_dpnt_f egd,
125: ben_prtt_enrt_rslt_f pen