APPS.BEN_PERSON_DELETE dependencies on BEN_PER_CM_USG_F

Line 1391: FROM ben_per_cm_usg_f

1387: CURSOR c4 (
1388: p_per_cm_id NUMBER
1389: ) IS
1390: SELECT per_cm_usg_id
1391: FROM ben_per_cm_usg_f
1392: WHERE per_cm_id = p_per_cm_id
1393: FOR UPDATE OF per_cm_usg_id;
1394: l_id NUMBER;
1395: BEGIN

Line 1423: <>

1419: CLOSE c3;
1420: OPEN c4 (
1421: r1.per_cm_id
1422: );
1423: <>
1424: LOOP
1425: FETCH c4 INTO l_id;
1426: EXIT WHEN c4%NOTFOUND;
1427: DELETE FROM ben_per_cm_usg_f

Line 1427: DELETE FROM ben_per_cm_usg_f

1423: <>
1424: LOOP
1425: FETCH c4 INTO l_id;
1426: EXIT WHEN c4%NOTFOUND;
1427: DELETE FROM ben_per_cm_usg_f
1428: WHERE CURRENT OF c4;
1429: END LOOP ben_per_cm_usg_f;
1430: CLOSE c4;
1431: END LOOP;

Line 1429: END LOOP ben_per_cm_usg_f;

1425: FETCH c4 INTO l_id;
1426: EXIT WHEN c4%NOTFOUND;
1427: DELETE FROM ben_per_cm_usg_f
1428: WHERE CURRENT OF c4;
1429: END LOOP ben_per_cm_usg_f;
1430: CLOSE c4;
1431: END LOOP;
1432: hr_utility.set_location('Leaving: '||l_proc,999);
1433: END delete_communications;