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_PRTT_ENRT_ACTN_F

Line 1177: FROM ben_prtt_enrt_actn_f

1173: CURSOR c1 (
1174: p_elig_cvrd_dpnt_id NUMBER
1175: ) IS
1176: SELECT elig_cvrd_dpnt_id
1177: FROM ben_prtt_enrt_actn_f
1178: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1179: FOR UPDATE OF elig_cvrd_dpnt_id;
1180:
1181: --

Line 1267: <>

1263: hr_utility.set_location(l_proc, 20);
1264: OPEN c1 (
1265: l_ecd.elig_cvrd_dpnt_id
1266: );
1267: <>
1268: LOOP
1269: FETCH c1 INTO l_id;
1270: EXIT WHEN c1%NOTFOUND;
1271: DELETE ben_prtt_enrt_actn_f

Line 1271: DELETE ben_prtt_enrt_actn_f

1267: <>
1268: LOOP
1269: FETCH c1 INTO l_id;
1270: EXIT WHEN c1%NOTFOUND;
1271: DELETE ben_prtt_enrt_actn_f
1272: WHERE CURRENT OF c1;
1273: END LOOP ben_prtt_enrt_actn_f;
1274: CLOSE c1;
1275: hr_utility.set_location(l_proc, 25);

Line 1273: END LOOP ben_prtt_enrt_actn_f;

1269: FETCH c1 INTO l_id;
1270: EXIT WHEN c1%NOTFOUND;
1271: DELETE ben_prtt_enrt_actn_f
1272: WHERE CURRENT OF c1;
1273: END LOOP ben_prtt_enrt_actn_f;
1274: CLOSE c1;
1275: hr_utility.set_location(l_proc, 25);
1276: OPEN c2 (
1277: l_ecd.elig_cvrd_dpnt_id

Line 1531: FROM ben_prtt_enrt_actn_f

1527: CURSOR c11 (
1528: p_prtt_enrt_rslt_id NUMBER
1529: ) IS
1530: SELECT prtt_enrt_actn_id
1531: FROM ben_prtt_enrt_actn_f
1532: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1533: FOR UPDATE OF prtt_enrt_actn_id;
1534: --** C|c12|p_per_in_ler_id in number
1535: --** CN|c12|Fetch the prtt_enrt_actn_id from ben_prtt_enrt_actn_f associated with a per_in_ler_id.

Line 1535: --** CN|c12|Fetch the prtt_enrt_actn_id from ben_prtt_enrt_actn_f associated with a per_in_ler_id.

1531: FROM ben_prtt_enrt_actn_f
1532: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1533: FOR UPDATE OF prtt_enrt_actn_id;
1534: --** C|c12|p_per_in_ler_id in number
1535: --** CN|c12|Fetch the prtt_enrt_actn_id from ben_prtt_enrt_actn_f associated with a per_in_ler_id.
1536: CURSOR c12 (
1537: p_per_in_ler_id IN NUMBER
1538: ) IS
1539: SELECT DISTINCT prtt_enrt_actn_id

Line 1540: FROM ben_prtt_enrt_actn_f

1536: CURSOR c12 (
1537: p_per_in_ler_id IN NUMBER
1538: ) IS
1539: SELECT DISTINCT prtt_enrt_actn_id
1540: FROM ben_prtt_enrt_actn_f
1541: WHERE per_in_ler_id = p_per_in_ler_id;
1542: CURSOR c13 (
1543: p_prtt_enrt_actn_id NUMBER
1544: ) IS

Line 1806: <>

1802: CLOSE c10;
1803: OPEN c11 (
1804: r4.prtt_enrt_rslt_id
1805: );
1806: <>
1807: LOOP
1808: FETCH c11 INTO l_id;
1809: EXIT WHEN c11%NOTFOUND;
1810: DELETE FROM ben_prtt_enrt_actn_f

Line 1810: DELETE FROM ben_prtt_enrt_actn_f

1806: <>
1807: LOOP
1808: FETCH c11 INTO l_id;
1809: EXIT WHEN c11%NOTFOUND;
1810: DELETE FROM ben_prtt_enrt_actn_f
1811: WHERE CURRENT OF c11;
1812: END LOOP ben_prtt_enrt_actn_f;
1813: CLOSE c11;
1814: END LOOP;

Line 1812: END LOOP ben_prtt_enrt_actn_f;

1808: FETCH c11 INTO l_id;
1809: EXIT WHEN c11%NOTFOUND;
1810: DELETE FROM ben_prtt_enrt_actn_f
1811: WHERE CURRENT OF c11;
1812: END LOOP ben_prtt_enrt_actn_f;
1813: CLOSE c11;
1814: END LOOP;
1815: FOR r12 IN c12 (
1816: r1.per_in_ler_id

Line 2097: FROM ben_prtt_enrt_actn_f

2093: CURSOR c8 (
2094: p_prtt_enrt_rslt_id NUMBER
2095: ) IS
2096: SELECT prtt_enrt_actn_id
2097: FROM ben_prtt_enrt_actn_f
2098: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2099: FOR UPDATE OF prtt_enrt_actn_id;
2100: l_id NUMBER;
2101: BEGIN

Line 2175: <>

2171: CLOSE c7;
2172: OPEN c8 (
2173: r1.prtt_enrt_rslt_id
2174: );
2175: <>
2176: LOOP
2177: FETCH c8 INTO l_id;
2178: EXIT WHEN c8%NOTFOUND;
2179: DELETE FROM ben_prtt_enrt_actn_f

Line 2179: DELETE FROM ben_prtt_enrt_actn_f

2175: <>
2176: LOOP
2177: FETCH c8 INTO l_id;
2178: EXIT WHEN c8%NOTFOUND;
2179: DELETE FROM ben_prtt_enrt_actn_f
2180: WHERE CURRENT OF c8;
2181: END LOOP ben_prtt_enrt_actn_f;
2182: CLOSE c8;
2183: END LOOP;

Line 2181: END LOOP ben_prtt_enrt_actn_f;

2177: FETCH c8 INTO l_id;
2178: EXIT WHEN c8%NOTFOUND;
2179: DELETE FROM ben_prtt_enrt_actn_f
2180: WHERE CURRENT OF c8;
2181: END LOOP ben_prtt_enrt_actn_f;
2182: CLOSE c8;
2183: END LOOP;
2184: hr_utility.set_location('Leaving: '||l_proc,999);
2185: END delete_participant_information;