APPS.BEN_PERSON_DELETE dependencies on BEN_PER_CM_USG_F

Line 1336: FROM ben_per_cm_usg_f

1332: CURSOR c4 (
1333: p_per_cm_id NUMBER
1334: ) IS
1335: SELECT per_cm_usg_id
1336: FROM ben_per_cm_usg_f
1337: WHERE per_cm_id = p_per_cm_id
1338: FOR UPDATE OF per_cm_usg_id;
1339: l_id NUMBER;
1340: BEGIN

Line 1368: <>

1364: CLOSE c3;
1365: OPEN c4 (
1366: r1.per_cm_id
1367: );
1368: <>
1369: LOOP
1370: FETCH c4 INTO l_id;
1371: EXIT WHEN c4%NOTFOUND;
1372: DELETE FROM ben_per_cm_usg_f

Line 1372: DELETE FROM ben_per_cm_usg_f

1368: <>
1369: LOOP
1370: FETCH c4 INTO l_id;
1371: EXIT WHEN c4%NOTFOUND;
1372: DELETE FROM ben_per_cm_usg_f
1373: WHERE CURRENT OF c4;
1374: END LOOP ben_per_cm_usg_f;
1375: CLOSE c4;
1376: END LOOP;

Line 1374: END LOOP ben_per_cm_usg_f;

1370: FETCH c4 INTO l_id;
1371: EXIT WHEN c4%NOTFOUND;
1372: DELETE FROM ben_per_cm_usg_f
1373: WHERE CURRENT OF c4;
1374: END LOOP ben_per_cm_usg_f;
1375: CLOSE c4;
1376: END LOOP;
1377: hr_utility.set_location('Leaving: '||l_proc,999);
1378: END delete_communications;