APPS.BEN_PERSON_DELETE dependencies on BEN_ENRT_RT

Line 1574: FROM ben_enrt_rt

1570: CURSOR c16 (
1571: p_enrt_bnft_id NUMBER
1572: ) IS
1573: SELECT enrt_rt_id
1574: FROM ben_enrt_rt
1575: WHERE enrt_bnft_id = p_enrt_bnft_id
1576: FOR UPDATE OF enrt_rt_id;
1577:
1578: --

Line 1609: FROM ben_enrt_rt

1605: CURSOR c20 (
1606: p_elig_per_elctbl_chc_id NUMBER
1607: ) IS
1608: SELECT enrt_rt_id
1609: FROM ben_enrt_rt
1610: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1611: FOR UPDATE OF enrt_rt_id;
1612:
1613: --

Line 1848: <>

1844: ) LOOP
1845: OPEN c16 (
1846: r15.enrt_bnft_id
1847: );
1848: <>
1849: LOOP
1850: FETCH c16 INTO l_id;
1851: EXIT WHEN c16%NOTFOUND;
1852: DELETE FROM ben_enrt_rt

Line 1852: DELETE FROM ben_enrt_rt

1848: <>
1849: LOOP
1850: FETCH c16 INTO l_id;
1851: EXIT WHEN c16%NOTFOUND;
1852: DELETE FROM ben_enrt_rt
1853: WHERE CURRENT OF c16;
1854: END LOOP;
1855: CLOSE c16;
1856: END LOOP;

Line 1890: <>

1886: hr_utility.set_location(l_proc,65);
1887: OPEN c20 (
1888: r17.elig_per_elctbl_chc_id
1889: );
1890: <>
1891: LOOP
1892: FETCH c20 INTO l_id;
1893: EXIT WHEN c20%NOTFOUND;
1894: DELETE FROM ben_enrt_rt

Line 1894: DELETE FROM ben_enrt_rt

1890: <>
1891: LOOP
1892: FETCH c20 INTO l_id;
1893: EXIT WHEN c20%NOTFOUND;
1894: DELETE FROM ben_enrt_rt
1895: WHERE CURRENT OF c20;
1896: END LOOP ben_enrt_rt;
1897: CLOSE c20;
1898: --

Line 1896: END LOOP ben_enrt_rt;

1892: FETCH c20 INTO l_id;
1893: EXIT WHEN c20%NOTFOUND;
1894: DELETE FROM ben_enrt_rt
1895: WHERE CURRENT OF c20;
1896: END LOOP ben_enrt_rt;
1897: CLOSE c20;
1898: --
1899: hr_utility.set_location(l_proc,70);
1900: OPEN c21 (