APPS.BEN_PERSON_DELETE dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 1546: FROM ben_pl_bnf_ctfn_prvdd_f

1542: CURSOR c13 (
1543: p_prtt_enrt_actn_id NUMBER
1544: ) IS
1545: SELECT pl_bnf_ctfn_prvdd_id
1546: FROM ben_pl_bnf_ctfn_prvdd_f
1547: WHERE prtt_enrt_actn_id = p_prtt_enrt_actn_id
1548: FOR UPDATE OF pl_bnf_ctfn_prvdd_id;
1549:
1550: --

Line 1821: <>

1817: ) LOOP
1818: OPEN c13 (
1819: r12.prtt_enrt_actn_id
1820: );
1821: <>
1822: LOOP
1823: FETCH c13 INTO l_id;
1824: EXIT WHEN c13%NOTFOUND;
1825: DELETE FROM ben_pl_bnf_ctfn_prvdd_f

Line 1825: DELETE FROM ben_pl_bnf_ctfn_prvdd_f

1821: <>
1822: LOOP
1823: FETCH c13 INTO l_id;
1824: EXIT WHEN c13%NOTFOUND;
1825: DELETE FROM ben_pl_bnf_ctfn_prvdd_f
1826: WHERE CURRENT OF c13;
1827: END LOOP ben_pl_bnf_ctfn_prvdd_f;
1828: CLOSE c13;
1829: OPEN c14 (

Line 1827: END LOOP ben_pl_bnf_ctfn_prvdd_f;

1823: FETCH c13 INTO l_id;
1824: EXIT WHEN c13%NOTFOUND;
1825: DELETE FROM ben_pl_bnf_ctfn_prvdd_f
1826: WHERE CURRENT OF c13;
1827: END LOOP ben_pl_bnf_ctfn_prvdd_f;
1828: CLOSE c13;
1829: OPEN c14 (
1830: r12.prtt_enrt_actn_id
1831: );