APPS.BEN_PERSON_DELETE dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 1486: FROM ben_bnft_prvdd_ldgr_f

1482: CURSOR c6 (
1483: p_prtt_enrt_rslt_id NUMBER
1484: ) IS
1485: SELECT bnft_prvdd_ldgr_id
1486: FROM ben_bnft_prvdd_ldgr_f
1487: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1488: FOR UPDATE OF bnft_prvdd_ldgr_id;
1489:
1490: --

Line 1751: <>

1747: CLOSE c5;
1748: OPEN c6 (
1749: r4.prtt_enrt_rslt_id
1750: );
1751: <>
1752: LOOP
1753: FETCH c6 INTO l_id;
1754: EXIT WHEN c6%NOTFOUND;
1755: DELETE FROM ben_bnft_prvdd_ldgr_f

Line 1755: DELETE FROM ben_bnft_prvdd_ldgr_f

1751: <>
1752: LOOP
1753: FETCH c6 INTO l_id;
1754: EXIT WHEN c6%NOTFOUND;
1755: DELETE FROM ben_bnft_prvdd_ldgr_f
1756: WHERE CURRENT OF c6;
1757: END LOOP ben_bnft_prvdd_ldgr_f;
1758: CLOSE c6;
1759: OPEN c7 (

Line 1757: END LOOP ben_bnft_prvdd_ldgr_f;

1753: FETCH c6 INTO l_id;
1754: EXIT WHEN c6%NOTFOUND;
1755: DELETE FROM ben_bnft_prvdd_ldgr_f
1756: WHERE CURRENT OF c6;
1757: END LOOP ben_bnft_prvdd_ldgr_f;
1758: CLOSE c6;
1759: OPEN c7 (
1760: r4.prtt_enrt_rslt_id
1761: );

Line 2053: FROM ben_bnft_prvdd_ldgr_f

2049: CURSOR c3 (
2050: p_prtt_enrt_rslt_id NUMBER
2051: ) IS
2052: SELECT bnft_prvdd_ldgr_id
2053: FROM ben_bnft_prvdd_ldgr_f
2054: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2055: FOR UPDATE OF bnft_prvdd_ldgr_id;
2056:
2057: --

Line 2120: <>

2116: CLOSE c2;
2117: OPEN c3 (
2118: r1.prtt_enrt_rslt_id
2119: );
2120: <>
2121: LOOP
2122: FETCH c3 INTO l_id;
2123: EXIT WHEN c3%NOTFOUND;
2124: DELETE FROM ben_bnft_prvdd_ldgr_f

Line 2124: DELETE FROM ben_bnft_prvdd_ldgr_f

2120: <>
2121: LOOP
2122: FETCH c3 INTO l_id;
2123: EXIT WHEN c3%NOTFOUND;
2124: DELETE FROM ben_bnft_prvdd_ldgr_f
2125: WHERE CURRENT OF c3;
2126: END LOOP ben_bnft_prvdd_ldgr_f;
2127: CLOSE c3;
2128: OPEN c4 (

Line 2126: END LOOP ben_bnft_prvdd_ldgr_f;

2122: FETCH c3 INTO l_id;
2123: EXIT WHEN c3%NOTFOUND;
2124: DELETE FROM ben_bnft_prvdd_ldgr_f
2125: WHERE CURRENT OF c3;
2126: END LOOP ben_bnft_prvdd_ldgr_f;
2127: CLOSE c3;
2128: OPEN c4 (
2129: r1.prtt_enrt_rslt_id
2130: );