APPS.BEN_PERSON_DELETE dependencies on BEN_CWB_HRCHY

Line 2997: DELETE FROM BEN_CWB_HRCHY WHERE EMP_PIL_ELCTBL_CHC_POPL_ID = l_pil_elctbl_chc_popl_id;

2993: <>
2994: LOOP
2995: FETCH c49 INTO l_pil_elctbl_chc_popl_id;
2996: EXIT WHEN c49%NOTFOUND;
2997: DELETE FROM BEN_CWB_HRCHY WHERE EMP_PIL_ELCTBL_CHC_POPL_ID = l_pil_elctbl_chc_popl_id;
2998: END LOOP ben_pil_elctbl_chc_popl;
2999: CLOSE c49;
3000:
3001: OPEN c50(l_id);