APPS.BEN_PERSON_DELETE dependencies on BEN_ENRT_BNFT

Line 1502: --** CN|c15|Fetch the enrt_bnft_id from ben_enrt_bnft associated with a per_in_ler_id and elig_per_elctbl_chc_id.

1498: FROM ben_cvrd_dpnt_ctfn_prvdd_f
1499: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id
1500: FOR UPDATE OF cvrd_dpnt_ctfn_prvdd_id;
1501: --** C|c15|p_per_in_ler_id in number
1502: --** CN|c15|Fetch the enrt_bnft_id from ben_enrt_bnft associated with a per_in_ler_id and elig_per_elctbl_chc_id.
1503: CURSOR c15 (
1504: p_per_in_ler_id IN NUMBER
1505: ) IS
1506: SELECT DISTINCT enrt_bnft_id

Line 1507: FROM ben_elig_per_elctbl_chc b1, ben_enrt_bnft b2

1503: CURSOR c15 (
1504: p_per_in_ler_id IN NUMBER
1505: ) IS
1506: SELECT DISTINCT enrt_bnft_id
1507: FROM ben_elig_per_elctbl_chc b1, ben_enrt_bnft b2
1508: WHERE b1.per_in_ler_id = p_per_in_ler_id
1509: AND b2.elig_per_elctbl_chc_id =
1510: b1.elig_per_elctbl_chc_id;
1511:

Line 1534: FROM ben_enrt_bnft

1530: CURSOR c18 (
1531: p_elig_per_elctbl_chc_id NUMBER
1532: ) IS
1533: SELECT enrt_bnft_id
1534: FROM ben_enrt_bnft
1535: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1536: FOR UPDATE OF enrt_bnft_id;
1537:
1538: --

Line 1807: <>

1803: ) LOOP
1804: OPEN c18 (
1805: r17.elig_per_elctbl_chc_id
1806: );
1807: <>
1808: LOOP
1809: FETCH c18 INTO l_id;
1810: EXIT WHEN c18%NOTFOUND;
1811: DELETE FROM ben_enrt_bnft

Line 1811: DELETE FROM ben_enrt_bnft

1807: <>
1808: LOOP
1809: FETCH c18 INTO l_id;
1810: EXIT WHEN c18%NOTFOUND;
1811: DELETE FROM ben_enrt_bnft
1812: WHERE CURRENT OF c18;
1813: END LOOP ben_enrt_bnft;
1814: CLOSE c18;
1815: --

Line 1813: END LOOP ben_enrt_bnft;

1809: FETCH c18 INTO l_id;
1810: EXIT WHEN c18%NOTFOUND;
1811: DELETE FROM ben_enrt_bnft
1812: WHERE CURRENT OF c18;
1813: END LOOP ben_enrt_bnft;
1814: CLOSE c18;
1815: --
1816: hr_utility.set_location(l_proc,60);
1817: OPEN c19 (