APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 1447: FROM ben_prtt_enrt_ctfn_prvdd_f

1443: CURSOR c8 (
1444: p_prtt_enrt_rslt_id NUMBER
1445: ) IS
1446: SELECT prtt_enrt_ctfn_prvdd_id
1447: FROM ben_prtt_enrt_ctfn_prvdd_f
1448: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1449: FOR UPDATE OF prtt_enrt_ctfn_prvdd_id;
1450:
1451: --

Line 1716: <>

1712: CLOSE c7;
1713: OPEN c8 (
1714: r4.prtt_enrt_rslt_id
1715: );
1716: <>
1717: LOOP
1718: FETCH c8 INTO l_id;
1719: EXIT WHEN c8%NOTFOUND;
1720: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

Line 1720: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

1716: <>
1717: LOOP
1718: FETCH c8 INTO l_id;
1719: EXIT WHEN c8%NOTFOUND;
1720: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
1721: WHERE CURRENT OF c8;
1722: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
1723: CLOSE c8;
1724: OPEN c9 (

Line 1722: END LOOP ben_prtt_enrt_ctfn_prvdd_f;

1718: FETCH c8 INTO l_id;
1719: EXIT WHEN c8%NOTFOUND;
1720: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
1721: WHERE CURRENT OF c8;
1722: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
1723: CLOSE c8;
1724: OPEN c9 (
1725: r4.prtt_enrt_rslt_id
1726: );

Line 2012: FROM ben_prtt_enrt_ctfn_prvdd_f

2008: CURSOR c5 (
2009: p_prtt_enrt_rslt_id NUMBER
2010: ) IS
2011: SELECT prtt_enrt_ctfn_prvdd_id
2012: FROM ben_prtt_enrt_ctfn_prvdd_f
2013: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2014: FOR UPDATE OF prtt_enrt_ctfn_prvdd_id;
2015:
2016: --

Line 2083: <>

2079: CLOSE c4;
2080: OPEN c5 (
2081: r1.prtt_enrt_rslt_id
2082: );
2083: <>
2084: LOOP
2085: FETCH c5 INTO l_id;
2086: EXIT WHEN c5%NOTFOUND;
2087: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

Line 2087: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

2083: <>
2084: LOOP
2085: FETCH c5 INTO l_id;
2086: EXIT WHEN c5%NOTFOUND;
2087: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
2088: WHERE CURRENT OF c5;
2089: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
2090: CLOSE c5;
2091: OPEN c6 (

Line 2089: END LOOP ben_prtt_enrt_ctfn_prvdd_f;

2085: FETCH c5 INTO l_id;
2086: EXIT WHEN c5%NOTFOUND;
2087: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
2088: WHERE CURRENT OF c5;
2089: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
2090: CLOSE c5;
2091: OPEN c6 (
2092: r1.prtt_enrt_rslt_id
2093: );