APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 1504: FROM ben_prtt_enrt_ctfn_prvdd_f

1500: CURSOR c8 (
1501: p_prtt_enrt_rslt_id NUMBER
1502: ) IS
1503: SELECT prtt_enrt_ctfn_prvdd_id
1504: FROM ben_prtt_enrt_ctfn_prvdd_f
1505: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1506: FOR UPDATE OF prtt_enrt_ctfn_prvdd_id;
1507:
1508: --

Line 1773: <>

1769: CLOSE c7;
1770: OPEN c8 (
1771: r4.prtt_enrt_rslt_id
1772: );
1773: <>
1774: LOOP
1775: FETCH c8 INTO l_id;
1776: EXIT WHEN c8%NOTFOUND;
1777: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

Line 1777: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

1773: <>
1774: LOOP
1775: FETCH c8 INTO l_id;
1776: EXIT WHEN c8%NOTFOUND;
1777: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
1778: WHERE CURRENT OF c8;
1779: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
1780: CLOSE c8;
1781: OPEN c9 (

Line 1779: END LOOP ben_prtt_enrt_ctfn_prvdd_f;

1775: FETCH c8 INTO l_id;
1776: EXIT WHEN c8%NOTFOUND;
1777: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
1778: WHERE CURRENT OF c8;
1779: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
1780: CLOSE c8;
1781: OPEN c9 (
1782: r4.prtt_enrt_rslt_id
1783: );

Line 2071: FROM ben_prtt_enrt_ctfn_prvdd_f

2067: CURSOR c5 (
2068: p_prtt_enrt_rslt_id NUMBER
2069: ) IS
2070: SELECT prtt_enrt_ctfn_prvdd_id
2071: FROM ben_prtt_enrt_ctfn_prvdd_f
2072: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2073: FOR UPDATE OF prtt_enrt_ctfn_prvdd_id;
2074:
2075: --

Line 2142: <>

2138: CLOSE c4;
2139: OPEN c5 (
2140: r1.prtt_enrt_rslt_id
2141: );
2142: <>
2143: LOOP
2144: FETCH c5 INTO l_id;
2145: EXIT WHEN c5%NOTFOUND;
2146: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

Line 2146: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f

2142: <>
2143: LOOP
2144: FETCH c5 INTO l_id;
2145: EXIT WHEN c5%NOTFOUND;
2146: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
2147: WHERE CURRENT OF c5;
2148: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
2149: CLOSE c5;
2150: OPEN c6 (

Line 2148: END LOOP ben_prtt_enrt_ctfn_prvdd_f;

2144: FETCH c5 INTO l_id;
2145: EXIT WHEN c5%NOTFOUND;
2146: DELETE FROM ben_prtt_enrt_ctfn_prvdd_f
2147: WHERE CURRENT OF c5;
2148: END LOOP ben_prtt_enrt_ctfn_prvdd_f;
2149: CLOSE c5;
2150: OPEN c6 (
2151: r1.prtt_enrt_rslt_id
2152: );