APPS.BEN_PERSON_DELETE dependencies on BEN_PER_CM_PRVDD_F

Line 1373: FROM ben_per_cm_prvdd_f

1369: CURSOR c2 (
1370: p_per_cm_id NUMBER
1371: ) IS
1372: SELECT per_cm_prvdd_id
1373: FROM ben_per_cm_prvdd_f
1374: WHERE per_cm_id = p_per_cm_id
1375: FOR UPDATE OF per_cm_prvdd_id;
1376:
1377: --

Line 1401: <>

1397: FOR r1 IN c1 LOOP
1398: OPEN c2 (
1399: r1.per_cm_id
1400: );
1401: <>
1402: LOOP
1403: FETCH c2 INTO l_id;
1404: EXIT WHEN c2%NOTFOUND;
1405: DELETE FROM ben_per_cm_prvdd_f

Line 1405: DELETE FROM ben_per_cm_prvdd_f

1401: <>
1402: LOOP
1403: FETCH c2 INTO l_id;
1404: EXIT WHEN c2%NOTFOUND;
1405: DELETE FROM ben_per_cm_prvdd_f
1406: WHERE CURRENT OF c2;
1407: END LOOP ben_per_cm_prvdd_f;
1408: CLOSE c2;
1409: OPEN c3 (

Line 1407: END LOOP ben_per_cm_prvdd_f;

1403: FETCH c2 INTO l_id;
1404: EXIT WHEN c2%NOTFOUND;
1405: DELETE FROM ben_per_cm_prvdd_f
1406: WHERE CURRENT OF c2;
1407: END LOOP ben_per_cm_prvdd_f;
1408: CLOSE c2;
1409: OPEN c3 (
1410: r1.per_cm_id
1411: );