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 1119: FROM ben_cvrd_dpnt_ctfn_prvdd_f

1115: CURSOR c_cvrd_dpnt (
1116: p_elig_cvrd_dpnt_id IN NUMBER
1117: ) IS
1118: SELECT cvrd_dpnt_ctfn_prvdd_id
1119: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1120: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1121: FOR UPDATE OF elig_cvrd_dpnt_id;
1122: CURSOR c1 (
1123: p_elig_cvrd_dpnt_id NUMBER

Line 1144: FROM ben_cvrd_dpnt_ctfn_prvdd_f

1140: CURSOR c3 (
1141: p_elig_cvrd_dpnt_id NUMBER
1142: ) IS
1143: SELECT elig_cvrd_dpnt_id
1144: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1145: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1146: FOR UPDATE OF elig_cvrd_dpnt_id;
1147:
1148: --

Line 1207: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

1203: hr_utility.set_location(l_proc, 15);
1204: FOR l_cvrd_dpnt IN c_cvrd_dpnt (
1205: l_ecd.elig_cvrd_dpnt_id
1206: ) LOOP
1207: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1208: WHERE CURRENT OF c_cvrd_dpnt;
1209: END LOOP;
1210: hr_utility.set_location(l_proc, 20);
1211: OPEN c1 (

Line 1238: <>

1234: hr_utility.set_location(l_proc, 30);
1235: OPEN c3 (
1236: l_ecd.elig_cvrd_dpnt_id
1237: );
1238: <>
1239: LOOP
1240: FETCH c3 INTO l_id;
1241: EXIT WHEN c3%NOTFOUND;
1242: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

Line 1242: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

1238: <>
1239: LOOP
1240: FETCH c3 INTO l_id;
1241: EXIT WHEN c3%NOTFOUND;
1242: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1243: WHERE CURRENT OF c3;
1244: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1245: CLOSE c3;
1246: hr_utility.set_location(l_proc, 35);

Line 1244: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;

1240: FETCH c3 INTO l_id;
1241: EXIT WHEN c3%NOTFOUND;
1242: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1243: WHERE CURRENT OF c3;
1244: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1245: CLOSE c3;
1246: hr_utility.set_location(l_proc, 35);
1247: /* OPEN c4 (
1248: l_ecd.elig_cvrd_dpnt_id

Line 1498: FROM ben_cvrd_dpnt_ctfn_prvdd_f

1494: CURSOR c14 (
1495: p_prtt_enrt_actn_id NUMBER
1496: ) IS
1497: SELECT cvrd_dpnt_ctfn_prvdd_id
1498: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1499: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id
1500: FOR UPDATE OF cvrd_dpnt_ctfn_prvdd_id;
1501: --** C|c15|p_per_in_ler_id in number
1502: --** 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 1775: <>

1771: CLOSE c13;
1772: OPEN c14 (
1773: r12.prtt_enrt_actn_id
1774: );
1775: <>
1776: LOOP
1777: FETCH c14 INTO l_id;
1778: EXIT WHEN c14%NOTFOUND;
1779: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f

Line 1779: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f

1775: <>
1776: LOOP
1777: FETCH c14 INTO l_id;
1778: EXIT WHEN c14%NOTFOUND;
1779: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
1780: WHERE CURRENT OF c14;
1781: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1782: CLOSE c14;
1783: END LOOP;

Line 1781: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;

1777: FETCH c14 INTO l_id;
1778: EXIT WHEN c14%NOTFOUND;
1779: DELETE FROM ben_cvrd_dpnt_ctfn_prvdd_f
1780: WHERE CURRENT OF c14;
1781: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1782: CLOSE c14;
1783: END LOOP;
1784: hr_utility.set_location(l_proc,50);
1785: FOR r15 IN c15 (