APPS.HR_PERSON_DELETE dependencies on BEN_EXT_CHG_EVT_LOG

Line 194: table BEN_EXT_CHG_EVT_LOG for the selected person.

190: forthe person_id passed fetched into a pl/sql table
191: to improve performance.
192: 115.35 10-Aug-2004 jpthomas 3524713 Modified the procedure moderate_predel_validation in the
193: package HR_PERSON_DELETE to delete the child items from the
194: table BEN_EXT_CHG_EVT_LOG for the selected person.
195: 115.36 14-Mar-2004 njaladi 4169275 Modified procedures strong_pre_del_validation,
196: moderate_pre_del_validion and weak_pre_del_validation
197: to add parameter of date track mode.
198: 115.37 04-Aug-2005 pchowdav 4508139 Modified procedure strong_pre_del_validation to call

Line 652: FROM ben_ext_chg_evt_log

648: CURSOR ben_ext_chg_log (
649: p_person_id NUMBER
650: ) IS
651: SELECT ext_chg_evt_log_id
652: FROM ben_ext_chg_evt_log
653: WHERE person_id = p_person_id
654: FOR UPDATE OF ext_chg_evt_log_id;
655: --
656: l_id NUMBER;

Line 1152: DELETE FROM ben_ext_chg_evt_log

1148: --
1149: LOOP
1150: FETCH ben_ext_chg_log INTO l_id;
1151: EXIT WHEN ben_ext_chg_log%NOTFOUND;
1152: DELETE FROM ben_ext_chg_evt_log
1153: WHERE CURRENT OF ben_ext_chg_log;
1154: END LOOP;
1155: CLOSE ben_ext_chg_log;
1156: -- Bug 3524713 Ends Here