APPS.BEN_DM_DELETE dependencies on BEN_CBR_QUALD_BNF

Line 111: (select cbf.cbr_quald_bnf_id from ben_cbr_quald_bnf cbf where cbf.quald_bnf_person_id = p_person_id);

107:
108: delete from ben_per_bnfts_bal_f where person_id = p_person_id;
109:
110: delete from ben_cbr_per_in_ler cpl where cpl.cbr_quald_bnf_id in
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

Line 113: delete from ben_cbr_quald_bnf where quald_bnf_person_id = p_person_id;

109:
110: delete from ben_cbr_per_in_ler cpl where cpl.cbr_quald_bnf_id in
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