APPS.BEN_PERSON_DELETE dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 1489: FROM ben_pl_bnf_ctfn_prvdd_f

1485: CURSOR c13 (
1486: p_prtt_enrt_actn_id NUMBER
1487: ) IS
1488: SELECT pl_bnf_ctfn_prvdd_id
1489: FROM ben_pl_bnf_ctfn_prvdd_f
1490: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id
1491: FOR UPDATE OF pl_bnf_ctfn_prvdd_id;
1492:
1493: --

Line 1764: <>

1760: ) LOOP
1761: OPEN c13 (
1762: r12.prtt_enrt_actn_id
1763: );
1764: <>
1765: LOOP
1766: FETCH c13 INTO l_id;
1767: EXIT WHEN c13%NOTFOUND;
1768: DELETE FROM ben_pl_bnf_ctfn_prvdd_f

Line 1768: DELETE FROM ben_pl_bnf_ctfn_prvdd_f

1764: <>
1765: LOOP
1766: FETCH c13 INTO l_id;
1767: EXIT WHEN c13%NOTFOUND;
1768: DELETE FROM ben_pl_bnf_ctfn_prvdd_f
1769: WHERE CURRENT OF c13;
1770: END LOOP ben_pl_bnf_ctfn_prvdd_f;
1771: CLOSE c13;
1772: OPEN c14 (

Line 1770: END LOOP ben_pl_bnf_ctfn_prvdd_f;

1766: FETCH c13 INTO l_id;
1767: EXIT WHEN c13%NOTFOUND;
1768: DELETE FROM ben_pl_bnf_ctfn_prvdd_f
1769: WHERE CURRENT OF c13;
1770: END LOOP ben_pl_bnf_ctfn_prvdd_f;
1771: CLOSE c13;
1772: OPEN c14 (
1773: r12.prtt_enrt_actn_id
1774: );