APPS.BEN_PERSON_DELETE dependencies on BEN_CWB_HRCHY

Line 2866: DELETE FROM BEN_CWB_HRCHY WHERE EMP_PIL_ELCTBL_CHC_POPL_ID = l_pil_elctbl_chc_popl_id;

2862: <>
2863: LOOP
2864: FETCH c49 INTO l_pil_elctbl_chc_popl_id;
2865: EXIT WHEN c49%NOTFOUND;
2866: DELETE FROM BEN_CWB_HRCHY WHERE EMP_PIL_ELCTBL_CHC_POPL_ID = l_pil_elctbl_chc_popl_id;
2867: END LOOP ben_pil_elctbl_chc_popl;
2868: CLOSE c49;
2869:
2870: OPEN c50(l_id);