APPS.BEN_PERSON_DELETE dependencies on BEN_ENRT_RT

Line 1517: FROM ben_enrt_rt

1513: CURSOR c16 (
1514: p_enrt_bnft_id NUMBER
1515: ) IS
1516: SELECT enrt_rt_id
1517: FROM ben_enrt_rt
1518: WHERE enrt_bnft_id = p_enrt_bnft_id
1519: FOR UPDATE OF enrt_rt_id;
1520:
1521: --

Line 1552: FROM ben_enrt_rt

1548: CURSOR c20 (
1549: p_elig_per_elctbl_chc_id NUMBER
1550: ) IS
1551: SELECT enrt_rt_id
1552: FROM ben_enrt_rt
1553: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1554: FOR UPDATE OF enrt_rt_id;
1555:
1556: --

Line 1791: <>

1787: ) LOOP
1788: OPEN c16 (
1789: r15.enrt_bnft_id
1790: );
1791: <>
1792: LOOP
1793: FETCH c16 INTO l_id;
1794: EXIT WHEN c16%NOTFOUND;
1795: DELETE FROM ben_enrt_rt

Line 1795: DELETE FROM ben_enrt_rt

1791: <>
1792: LOOP
1793: FETCH c16 INTO l_id;
1794: EXIT WHEN c16%NOTFOUND;
1795: DELETE FROM ben_enrt_rt
1796: WHERE CURRENT OF c16;
1797: END LOOP;
1798: CLOSE c16;
1799: END LOOP;

Line 1833: <>

1829: hr_utility.set_location(l_proc,65);
1830: OPEN c20 (
1831: r17.elig_per_elctbl_chc_id
1832: );
1833: <>
1834: LOOP
1835: FETCH c20 INTO l_id;
1836: EXIT WHEN c20%NOTFOUND;
1837: DELETE FROM ben_enrt_rt

Line 1837: DELETE FROM ben_enrt_rt

1833: <>
1834: LOOP
1835: FETCH c20 INTO l_id;
1836: EXIT WHEN c20%NOTFOUND;
1837: DELETE FROM ben_enrt_rt
1838: WHERE CURRENT OF c20;
1839: END LOOP ben_enrt_rt;
1840: CLOSE c20;
1841: --

Line 1839: END LOOP ben_enrt_rt;

1835: FETCH c20 INTO l_id;
1836: EXIT WHEN c20%NOTFOUND;
1837: DELETE FROM ben_enrt_rt
1838: WHERE CURRENT OF c20;
1839: END LOOP ben_enrt_rt;
1840: CLOSE c20;
1841: --
1842: hr_utility.set_location(l_proc,70);
1843: OPEN c21 (