APPS.BEN_PERSON_DELETE dependencies on BEN_CWB_GROUP_HRCHY

Line 2855: DELETE FROM BEN_CWB_GROUP_HRCHY WHERE emp_per_in_ler_id=l_id;

2851: EXIT WHEN c41%NOTFOUND;
2852: --Bug 4653271 Deletion of BEn - CWB information
2853: DELETE FROM BEN_CWB_AUDIT WHERE group_per_in_ler_id=l_id;
2854:
2855: DELETE FROM BEN_CWB_GROUP_HRCHY WHERE emp_per_in_ler_id=l_id;
2856:
2857: DELETE FROM BEN_CWB_PERSON_GROUPS WHERE group_per_in_ler_id=l_id;
2858:
2859: DELETE FROM BEN_CWB_PERSON_TASKS WHERE group_per_in_ler_id=l_id;