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 653: FROM ben_ext_chg_evt_log

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

Line 1153: DELETE FROM ben_ext_chg_evt_log

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