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 1126: FROM ben_prtt_enrt_actn_f

1122: CURSOR c1 (
1123: p_elig_cvrd_dpnt_id NUMBER
1124: ) IS
1125: SELECT elig_cvrd_dpnt_id
1126: FROM ben_prtt_enrt_actn_f
1127: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1128: FOR UPDATE OF elig_cvrd_dpnt_id;
1129:
1130: --

Line 1214: <>

1210: hr_utility.set_location(l_proc, 20);
1211: OPEN c1 (
1212: l_ecd.elig_cvrd_dpnt_id
1213: );
1214: <>
1215: LOOP
1216: FETCH c1 INTO l_id;
1217: EXIT WHEN c1%NOTFOUND;
1218: DELETE ben_prtt_enrt_actn_f

Line 1218: DELETE ben_prtt_enrt_actn_f

1214: <>
1215: LOOP
1216: FETCH c1 INTO l_id;
1217: EXIT WHEN c1%NOTFOUND;
1218: DELETE ben_prtt_enrt_actn_f
1219: WHERE CURRENT OF c1;
1220: END LOOP ben_prtt_enrt_actn_f;
1221: CLOSE c1;
1222: hr_utility.set_location(l_proc, 25);

Line 1220: END LOOP ben_prtt_enrt_actn_f;

1216: FETCH c1 INTO l_id;
1217: EXIT WHEN c1%NOTFOUND;
1218: DELETE ben_prtt_enrt_actn_f
1219: WHERE CURRENT OF c1;
1220: END LOOP ben_prtt_enrt_actn_f;
1221: CLOSE c1;
1222: hr_utility.set_location(l_proc, 25);
1223: OPEN c2 (
1224: l_ecd.elig_cvrd_dpnt_id

Line 1474: FROM ben_prtt_enrt_actn_f

1470: CURSOR c11 (
1471: p_prtt_enrt_rslt_id NUMBER
1472: ) IS
1473: SELECT prtt_enrt_actn_id
1474: FROM ben_prtt_enrt_actn_f
1475: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1476: FOR UPDATE OF prtt_enrt_actn_id;
1477: --** C|c12|p_per_in_ler_id in number
1478: --** CN|c12|Fetch the prtt_enrt_actn_id from ben_prtt_enrt_actn_f associated with a per_in_ler_id.

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

1474: FROM ben_prtt_enrt_actn_f
1475: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1476: FOR UPDATE OF prtt_enrt_actn_id;
1477: --** C|c12|p_per_in_ler_id in number
1478: --** CN|c12|Fetch the prtt_enrt_actn_id from ben_prtt_enrt_actn_f associated with a per_in_ler_id.
1479: CURSOR c12 (
1480: p_per_in_ler_id IN NUMBER
1481: ) IS
1482: SELECT DISTINCT prtt_enrt_actn_id

Line 1483: FROM ben_prtt_enrt_actn_f

1479: CURSOR c12 (
1480: p_per_in_ler_id IN NUMBER
1481: ) IS
1482: SELECT DISTINCT prtt_enrt_actn_id
1483: FROM ben_prtt_enrt_actn_f
1484: WHERE per_in_ler_id = p_per_in_ler_id;
1485: CURSOR c13 (
1486: p_prtt_enrt_actn_id NUMBER
1487: ) IS

Line 1749: <>

1745: CLOSE c10;
1746: OPEN c11 (
1747: r4.prtt_enrt_rslt_id
1748: );
1749: <>
1750: LOOP
1751: FETCH c11 INTO l_id;
1752: EXIT WHEN c11%NOTFOUND;
1753: DELETE FROM ben_prtt_enrt_actn_f

Line 1753: DELETE FROM ben_prtt_enrt_actn_f

1749: <>
1750: LOOP
1751: FETCH c11 INTO l_id;
1752: EXIT WHEN c11%NOTFOUND;
1753: DELETE FROM ben_prtt_enrt_actn_f
1754: WHERE CURRENT OF c11;
1755: END LOOP ben_prtt_enrt_actn_f;
1756: CLOSE c11;
1757: END LOOP;

Line 1755: END LOOP ben_prtt_enrt_actn_f;

1751: FETCH c11 INTO l_id;
1752: EXIT WHEN c11%NOTFOUND;
1753: DELETE FROM ben_prtt_enrt_actn_f
1754: WHERE CURRENT OF c11;
1755: END LOOP ben_prtt_enrt_actn_f;
1756: CLOSE c11;
1757: END LOOP;
1758: FOR r12 IN c12 (
1759: r1.per_in_ler_id

Line 2038: FROM ben_prtt_enrt_actn_f

2034: CURSOR c8 (
2035: p_prtt_enrt_rslt_id NUMBER
2036: ) IS
2037: SELECT prtt_enrt_actn_id
2038: FROM ben_prtt_enrt_actn_f
2039: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2040: FOR UPDATE OF prtt_enrt_actn_id;
2041: l_id NUMBER;
2042: BEGIN

Line 2116: <>

2112: CLOSE c7;
2113: OPEN c8 (
2114: r1.prtt_enrt_rslt_id
2115: );
2116: <>
2117: LOOP
2118: FETCH c8 INTO l_id;
2119: EXIT WHEN c8%NOTFOUND;
2120: DELETE FROM ben_prtt_enrt_actn_f

Line 2120: DELETE FROM ben_prtt_enrt_actn_f

2116: <>
2117: LOOP
2118: FETCH c8 INTO l_id;
2119: EXIT WHEN c8%NOTFOUND;
2120: DELETE FROM ben_prtt_enrt_actn_f
2121: WHERE CURRENT OF c8;
2122: END LOOP ben_prtt_enrt_actn_f;
2123: CLOSE c8;
2124: END LOOP;

Line 2122: END LOOP ben_prtt_enrt_actn_f;

2118: FETCH c8 INTO l_id;
2119: EXIT WHEN c8%NOTFOUND;
2120: DELETE FROM ben_prtt_enrt_actn_f
2121: WHERE CURRENT OF c8;
2122: END LOOP ben_prtt_enrt_actn_f;
2123: CLOSE c8;
2124: END LOOP;
2125: hr_utility.set_location('Leaving: '||l_proc,999);
2126: END delete_participant_information;