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_CVRD_DPNT_CTFN_PRVDD_F

Line 1170: FROM ben_cvrd_dpnt_ctfn_prvdd_f

1166: CURSOR c_cvrd_dpnt (
1167: p_elig_cvrd_dpnt_id IN NUMBER
1168: ) IS
1169: SELECT cvrd_dpnt_ctfn_prvdd_id
1170: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1171: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1172: FOR UPDATE OF elig_cvrd_dpnt_id;
1173: CURSOR c1 (
1174: p_elig_cvrd_dpnt_id NUMBER

Line 1195: FROM ben_cvrd_dpnt_ctfn_prvdd_f

1191: CURSOR c3 (
1192: p_elig_cvrd_dpnt_id NUMBER
1193: ) IS
1194: SELECT elig_cvrd_dpnt_id
1195: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1196: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1197: FOR UPDATE OF elig_cvrd_dpnt_id;
1198:
1199: --

Line 1260: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

1256: hr_utility.set_location(l_proc, 15);
1257: FOR l_cvrd_dpnt IN c_cvrd_dpnt (
1258: l_ecd.elig_cvrd_dpnt_id
1259: ) LOOP
1260: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1261: WHERE CURRENT OF c_cvrd_dpnt;
1262: END LOOP;
1263: hr_utility.set_location(l_proc, 20);
1264: OPEN c1 (

Line 1291: <>

1287: hr_utility.set_location(l_proc, 30);
1288: OPEN c3 (
1289: l_ecd.elig_cvrd_dpnt_id
1290: );
1291: <>
1292: LOOP
1293: FETCH c3 INTO l_id;
1294: EXIT WHEN c3%NOTFOUND;
1295: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

Line 1295: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

1291: <>
1292: LOOP
1293: FETCH c3 INTO l_id;
1294: EXIT WHEN c3%NOTFOUND;
1295: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1296: WHERE CURRENT OF c3;
1297: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1298: CLOSE c3;
1299: hr_utility.set_location(l_proc, 35);

Line 1297: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;

1293: FETCH c3 INTO l_id;
1294: EXIT WHEN c3%NOTFOUND;
1295: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1296: WHERE CURRENT OF c3;
1297: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1298: CLOSE c3;
1299: hr_utility.set_location(l_proc, 35);
1300: /* OPEN c4 (
1301: l_ecd.elig_cvrd_dpnt_id

Line 1555: FROM ben_cvrd_dpnt_ctfn_prvdd_f

1551: CURSOR c14 (
1552: p_prtt_enrt_actn_id NUMBER
1553: ) IS
1554: SELECT cvrd_dpnt_ctfn_prvdd_id
1555: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1556: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id
1557: FOR UPDATE OF cvrd_dpnt_ctfn_prvdd_id;
1558: --** C|c15|p_per_in_ler_id in number
1559: --** CN|c15|Fetch the enrt_bnft_id from ben_enrt_bnft associated with a per_in_ler_id and elig_per_elctbl_chc_id.

Line 1832: <>

1828: CLOSE c13;
1829: OPEN c14 (
1830: r12.prtt_enrt_actn_id
1831: );
1832: <>
1833: LOOP
1834: FETCH c14 INTO l_id;
1835: EXIT WHEN c14%NOTFOUND;
1836: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f

Line 1836: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f

1832: <>
1833: LOOP
1834: FETCH c14 INTO l_id;
1835: EXIT WHEN c14%NOTFOUND;
1836: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
1837: WHERE CURRENT OF c14;
1838: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1839: CLOSE c14;
1840: END LOOP;

Line 1838: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;

1834: FETCH c14 INTO l_id;
1835: EXIT WHEN c14%NOTFOUND;
1836: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
1837: WHERE CURRENT OF c14;
1838: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1839: CLOSE c14;
1840: END LOOP;
1841: hr_utility.set_location(l_proc,50);
1842: FOR r15 IN c15 (