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 1543: FROM ben_enrt_prem

1539: CURSOR c19 (
1540: p_elig_per_elctbl_chc_id NUMBER
1541: ) IS
1542: SELECT enrt_prem_id
1543: FROM ben_enrt_prem
1544: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1545: FOR UPDATE OF enrt_prem_id;
1546:
1547: --

Line 1820: <>

1816: hr_utility.set_location(l_proc,60);
1817: OPEN c19 (
1818: r17.elig_per_elctbl_chc_id
1819: );
1820: <>
1821: LOOP
1822: FETCH c19 INTO l_id;
1823: EXIT WHEN c19%NOTFOUND;
1824: DELETE FROM ben_enrt_prem

Line 1824: DELETE FROM ben_enrt_prem

1820: <>
1821: LOOP
1822: FETCH c19 INTO l_id;
1823: EXIT WHEN c19%NOTFOUND;
1824: DELETE FROM ben_enrt_prem
1825: WHERE CURRENT OF c19;
1826: END LOOP;
1827: CLOSE c19;
1828: --