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_ENRT_PREM

Line 1600: FROM ben_enrt_prem

1596: CURSOR c19 (
1597: p_elig_per_elctbl_chc_id NUMBER
1598: ) IS
1599: SELECT enrt_prem_id
1600: FROM ben_enrt_prem
1601: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1602: FOR UPDATE OF enrt_prem_id;
1603:
1604: --

Line 1877: <>

1873: hr_utility.set_location(l_proc,60);
1874: OPEN c19 (
1875: r17.elig_per_elctbl_chc_id
1876: );
1877: <>
1878: LOOP
1879: FETCH c19 INTO l_id;
1880: EXIT WHEN c19%NOTFOUND;
1881: DELETE FROM ben_enrt_prem

Line 1881: DELETE FROM ben_enrt_prem

1877: <>
1878: LOOP
1879: FETCH c19 INTO l_id;
1880: EXIT WHEN c19%NOTFOUND;
1881: DELETE FROM ben_enrt_prem
1882: WHERE CURRENT OF c19;
1883: END LOOP;
1884: CLOSE c19;
1885: --