APPS.BEN_PERSON_DELETE dependencies on BEN_ELIG_DPNT

Line 1162: FROM ben_elig_dpnt

1158: CURSOR c5 (
1159: p_elig_cvrd_dpnt_id NUMBER
1160: ) IS
1161: SELECT elig_cvrd_dpnt_id
1162: FROM ben_elig_dpnt
1163: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1164: FOR UPDATE OF elig_cvrd_dpnt_id;
1165:
1166: --

Line 1188: FROM ben_elig_dpnt

1184: CURSOR c7 (
1185: p_elig_cvrd_dpnt_id NUMBER
1186: ) IS
1187: SELECT elig_cvrd_dpnt_id
1188: FROM ben_elig_dpnt
1189: WHERE dpnt_person_id = p_elig_cvrd_dpnt_id
1190: FOR UPDATE OF elig_cvrd_dpnt_id;
1191:
1192: --

Line 1262: <>

1258: hr_utility.set_location(l_proc, 40);
1259: OPEN c5 (
1260: l_ecd.elig_cvrd_dpnt_id
1261: );
1262: <>
1263: LOOP
1264: FETCH c5 INTO l_id;
1265: EXIT WHEN c5%NOTFOUND;
1266: DELETE ben_elig_dpnt

Line 1266: DELETE ben_elig_dpnt

1262: <>
1263: LOOP
1264: FETCH c5 INTO l_id;
1265: EXIT WHEN c5%NOTFOUND;
1266: DELETE ben_elig_dpnt
1267: WHERE CURRENT OF c5;
1268: END LOOP ben_elig_dpnt;
1269: CLOSE c5;
1270: hr_utility.set_location(l_proc, 45);

Line 1268: END LOOP ben_elig_dpnt;

1264: FETCH c5 INTO l_id;
1265: EXIT WHEN c5%NOTFOUND;
1266: DELETE ben_elig_dpnt
1267: WHERE CURRENT OF c5;
1268: END LOOP ben_elig_dpnt;
1269: CLOSE c5;
1270: hr_utility.set_location(l_proc, 45);
1271: OPEN c6 (
1272: l_ecd.elig_cvrd_dpnt_id

Line 1286: <>

1282: hr_utility.set_location(l_proc, 50);
1283: OPEN c7 (
1284: l_ecd.elig_cvrd_dpnt_id
1285: );
1286: <>
1287: LOOP
1288: FETCH c7 INTO l_id;
1289: EXIT WHEN c7%NOTFOUND;
1290: DELETE ben_elig_dpnt

Line 1290: DELETE ben_elig_dpnt

1286: <>
1287: LOOP
1288: FETCH c7 INTO l_id;
1289: EXIT WHEN c7%NOTFOUND;
1290: DELETE ben_elig_dpnt
1291: WHERE CURRENT OF c7;
1292: END LOOP ben_elig_dpnt;
1293: CLOSE c7;
1294: DELETE ben_elig_cvrd_dpnt_f

Line 1292: END LOOP ben_elig_dpnt;

1288: FETCH c7 INTO l_id;
1289: EXIT WHEN c7%NOTFOUND;
1290: DELETE ben_elig_dpnt
1291: WHERE CURRENT OF c7;
1292: END LOOP ben_elig_dpnt;
1293: CLOSE c7;
1294: DELETE ben_elig_cvrd_dpnt_f
1295: WHERE CURRENT OF c_ecd;
1296: END LOOP;

Line 1599: FROM ben_elig_dpnt

1595: CURSOR c25 (
1596: p_per_in_ler_id IN NUMBER
1597: ) IS
1598: SELECT elig_dpnt_id
1599: FROM ben_elig_dpnt
1600: WHERE per_in_ler_id = p_per_in_ler_id
1601: FOR UPDATE OF elig_dpnt_id;
1602:
1603: --

Line 1885: <>

1881: CLOSE c24;
1882: OPEN c25 (
1883: r1.per_in_ler_id
1884: );
1885: <>
1886: LOOP
1887: FETCH c25 INTO l_id;
1888: EXIT WHEN c25%NOTFOUND;
1889: DELETE FROM ben_elig_dpnt

Line 1889: DELETE FROM ben_elig_dpnt

1885: <>
1886: LOOP
1887: FETCH c25 INTO l_id;
1888: EXIT WHEN c25%NOTFOUND;
1889: DELETE FROM ben_elig_dpnt
1890: WHERE CURRENT OF c25;
1891: END LOOP ben_elig_dpnt;
1892: CLOSE c25;
1893: OPEN c26 (

Line 1891: END LOOP ben_elig_dpnt;

1887: FETCH c25 INTO l_id;
1888: EXIT WHEN c25%NOTFOUND;
1889: DELETE FROM ben_elig_dpnt
1890: WHERE CURRENT OF c25;
1891: END LOOP ben_elig_dpnt;
1892: CLOSE c25;
1893: OPEN c26 (
1894: r1.per_in_ler_id
1895: );