eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PERSON_DELETE dependencies on BEN_ELIG_DPNT

Line 1213: FROM ben_elig_dpnt

1209: CURSOR c5 (
1210: p_elig_cvrd_dpnt_id NUMBER
1211: ) IS
1212: SELECT elig_cvrd_dpnt_id
1213: FROM ben_elig_dpnt
1214: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1215: FOR UPDATE OF elig_cvrd_dpnt_id;
1216:
1217: --

Line 1239: FROM ben_elig_dpnt

1235: CURSOR c7 (
1236: p_elig_cvrd_dpnt_id NUMBER
1237: ) IS
1238: SELECT elig_cvrd_dpnt_id
1239: FROM ben_elig_dpnt
1240: WHERE dpnt_person_id = p_elig_cvrd_dpnt_id
1241: FOR UPDATE OF elig_cvrd_dpnt_id;
1242:
1243: --

Line 1315: <>

1311: hr_utility.set_location(l_proc, 40);
1312: OPEN c5 (
1313: l_ecd.elig_cvrd_dpnt_id
1314: );
1315: <>
1316: LOOP
1317: FETCH c5 INTO l_id;
1318: EXIT WHEN c5%NOTFOUND;
1319: DELETE ben_elig_dpnt

Line 1319: DELETE ben_elig_dpnt

1315: <>
1316: LOOP
1317: FETCH c5 INTO l_id;
1318: EXIT WHEN c5%NOTFOUND;
1319: DELETE ben_elig_dpnt
1320: WHERE CURRENT OF c5;
1321: END LOOP ben_elig_dpnt;
1322: CLOSE c5;
1323: hr_utility.set_location(l_proc, 45);

Line 1321: END LOOP ben_elig_dpnt;

1317: FETCH c5 INTO l_id;
1318: EXIT WHEN c5%NOTFOUND;
1319: DELETE ben_elig_dpnt
1320: WHERE CURRENT OF c5;
1321: END LOOP ben_elig_dpnt;
1322: CLOSE c5;
1323: hr_utility.set_location(l_proc, 45);
1324: OPEN c6 (
1325: l_ecd.elig_cvrd_dpnt_id

Line 1339: <>

1335: hr_utility.set_location(l_proc, 50);
1336: OPEN c7 (
1337: l_ecd.elig_cvrd_dpnt_id
1338: );
1339: <>
1340: LOOP
1341: FETCH c7 INTO l_id;
1342: EXIT WHEN c7%NOTFOUND;
1343: DELETE ben_elig_dpnt

Line 1343: DELETE ben_elig_dpnt

1339: <>
1340: LOOP
1341: FETCH c7 INTO l_id;
1342: EXIT WHEN c7%NOTFOUND;
1343: DELETE ben_elig_dpnt
1344: WHERE CURRENT OF c7;
1345: END LOOP ben_elig_dpnt;
1346: CLOSE c7;
1347: DELETE ben_elig_cvrd_dpnt_f

Line 1345: END LOOP ben_elig_dpnt;

1341: FETCH c7 INTO l_id;
1342: EXIT WHEN c7%NOTFOUND;
1343: DELETE ben_elig_dpnt
1344: WHERE CURRENT OF c7;
1345: END LOOP ben_elig_dpnt;
1346: CLOSE c7;
1347: DELETE ben_elig_cvrd_dpnt_f
1348: WHERE CURRENT OF c_ecd;
1349: END LOOP;

Line 1656: FROM ben_elig_dpnt

1652: CURSOR c25 (
1653: p_per_in_ler_id IN NUMBER
1654: ) IS
1655: SELECT elig_dpnt_id
1656: FROM ben_elig_dpnt
1657: WHERE per_in_ler_id = p_per_in_ler_id
1658: FOR UPDATE OF elig_dpnt_id;
1659:
1660: --

Line 1942: <>

1938: CLOSE c24;
1939: OPEN c25 (
1940: r1.per_in_ler_id
1941: );
1942: <>
1943: LOOP
1944: FETCH c25 INTO l_id;
1945: EXIT WHEN c25%NOTFOUND;
1946: DELETE FROM ben_elig_dpnt

Line 1946: DELETE FROM ben_elig_dpnt

1942: <>
1943: LOOP
1944: FETCH c25 INTO l_id;
1945: EXIT WHEN c25%NOTFOUND;
1946: DELETE FROM ben_elig_dpnt
1947: WHERE CURRENT OF c25;
1948: END LOOP ben_elig_dpnt;
1949: CLOSE c25;
1950: OPEN c26 (

Line 1948: END LOOP ben_elig_dpnt;

1944: FETCH c25 INTO l_id;
1945: EXIT WHEN c25%NOTFOUND;
1946: DELETE FROM ben_elig_dpnt
1947: WHERE CURRENT OF c25;
1948: END LOOP ben_elig_dpnt;
1949: CLOSE c25;
1950: OPEN c26 (
1951: r1.per_in_ler_id
1952: );