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

774: CURSOR ben_ext_chg_log (
775: p_person_id NUMBER
776: ) IS
777: SELECT ext_chg_evt_log_id
778: FROM ben_ext_chg_evt_log
779: WHERE person_id = p_person_id
780: FOR UPDATE OF ext_chg_evt_log_id;
781: --
782: l_id NUMBER;

Line 1379: DELETE FROM ben_ext_chg_evt_log

1375: --
1376: FETCH ben_ext_chg_log INTO l_id;
1377: EXIT WHEN ben_ext_chg_log%NOTFOUND;
1378: --
1379: DELETE FROM ben_ext_chg_evt_log
1380: WHERE CURRENT OF ben_ext_chg_log;
1381: --
1382: END LOOP;
1383: --