APPS.BEN_PERSON_DELETE dependencies on BEN_PER_CM_TRGR_F

Line 1327: FROM ben_per_cm_trgr_f

1323: CURSOR c3 (
1324: p_per_cm_id NUMBER
1325: ) IS
1326: SELECT per_cm_trgr_id
1327: FROM ben_per_cm_trgr_f
1328: WHERE per_cm_id = p_per_cm_id
1329: FOR UPDATE OF per_cm_trgr_id;
1330:
1331: --

Line 1357: <>

1353: CLOSE c2;
1354: OPEN c3 (
1355: r1.per_cm_id
1356: );
1357: <>
1358: LOOP
1359: FETCH c3 INTO l_id;
1360: EXIT WHEN c3%NOTFOUND;
1361: DELETE FROM ben_per_cm_trgr_f

Line 1361: DELETE FROM ben_per_cm_trgr_f

1357: <>
1358: LOOP
1359: FETCH c3 INTO l_id;
1360: EXIT WHEN c3%NOTFOUND;
1361: DELETE FROM ben_per_cm_trgr_f
1362: WHERE CURRENT OF c3;
1363: END LOOP ben_per_cm_trgr_f;
1364: CLOSE c3;
1365: OPEN c4 (

Line 1363: END LOOP ben_per_cm_trgr_f;

1359: FETCH c3 INTO l_id;
1360: EXIT WHEN c3%NOTFOUND;
1361: DELETE FROM ben_per_cm_trgr_f
1362: WHERE CURRENT OF c3;
1363: END LOOP ben_per_cm_trgr_f;
1364: CLOSE c3;
1365: OPEN c4 (
1366: r1.per_cm_id
1367: );