DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on BEN_EXT_CHG_EVT_LOG

Line 649: FROM ben_ext_chg_evt_log

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

Line 706: DELETE FROM ben_ext_chg_evt_log

702: --
703: LOOP
704: FETCH ben_ext_chg_log INTO l_id;
705: EXIT WHEN ben_ext_chg_log%NOTFOUND;
706: DELETE FROM ben_ext_chg_evt_log
707: WHERE CURRENT OF ben_ext_chg_log;
708: END LOOP;
709: --
710: CLOSE ben_ext_chg_log;

Line 772: FROM ben_ext_chg_evt_log

768: CURSOR ben_ext_chg_log (
769: p_person_id NUMBER
770: ) IS
771: SELECT ext_chg_evt_log_id
772: FROM ben_ext_chg_evt_log
773: WHERE person_id = p_person_id
774: FOR UPDATE OF ext_chg_evt_log_id;
775: --
776: l_id NUMBER;

Line 1350: DELETE FROM ben_ext_chg_evt_log

1346: --
1347: FETCH ben_ext_chg_log INTO l_id;
1348: EXIT WHEN ben_ext_chg_log%NOTFOUND;
1349: --
1350: DELETE FROM ben_ext_chg_evt_log
1351: WHERE CURRENT OF ben_ext_chg_log;
1352: --
1353: END LOOP;
1354: --