APPS.BEN_PERSON_DELETE dependencies on BEN_ELCTBL_CHC_CTFN

Line 1618: FROM ben_elctbl_chc_ctfn

1614: CURSOR c21 (
1615: p_elig_per_elctbl_chc_id NUMBER
1616: ) IS
1617: SELECT elctbl_chc_ctfn_id
1618: FROM ben_elctbl_chc_ctfn
1619: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1620: FOR UPDATE OF elctbl_chc_ctfn_id;
1621:
1622: --

Line 1903: <>

1899: hr_utility.set_location(l_proc,70);
1900: OPEN c21 (
1901: r17.elig_per_elctbl_chc_id
1902: );
1903: <>
1904: LOOP
1905: FETCH c21 INTO l_id;
1906: EXIT WHEN c21%NOTFOUND;
1907: DELETE FROM ben_elctbl_chc_ctfn

Line 1907: DELETE FROM ben_elctbl_chc_ctfn

1903: <>
1904: LOOP
1905: FETCH c21 INTO l_id;
1906: EXIT WHEN c21%NOTFOUND;
1907: DELETE FROM ben_elctbl_chc_ctfn
1908: WHERE CURRENT OF c21;
1909: END LOOP ben_elctbl_chc_ctfn;
1910: CLOSE c21;
1911: END LOOP;

Line 1909: END LOOP ben_elctbl_chc_ctfn;

1905: FETCH c21 INTO l_id;
1906: EXIT WHEN c21%NOTFOUND;
1907: DELETE FROM ben_elctbl_chc_ctfn
1908: WHERE CURRENT OF c21;
1909: END LOOP ben_elctbl_chc_ctfn;
1910: CLOSE c21;
1911: END LOOP;
1912: hr_utility.set_location(l_proc,70);
1913: FOR r22 IN c22 (