APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_REIMBMT_RECON

Line 2231: FROM ben_prtt_reimbmt_recon

2227: CURSOR c2 (
2228: p_prtt_reimbmt_rqst_id NUMBER
2229: ) IS
2230: SELECT prtt_reimbmt_recon_id
2231: FROM ben_prtt_reimbmt_recon
2232: WHERE prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
2233: FOR UPDATE OF prtt_reimbmt_recon_id;
2234: l_id NUMBER;
2235: BEGIN

Line 2240: <>

2236: FOR r1 IN c1 LOOP
2237: OPEN c2 (
2238: r1.prtt_reimbmt_rqst_id
2239: );
2240: <>
2241: LOOP
2242: FETCH c2 INTO l_id;
2243: EXIT WHEN c2%NOTFOUND;
2244: DELETE FROM ben_prtt_reimbmt_recon

Line 2244: DELETE FROM ben_prtt_reimbmt_recon

2240: <>
2241: LOOP
2242: FETCH c2 INTO l_id;
2243: EXIT WHEN c2%NOTFOUND;
2244: DELETE FROM ben_prtt_reimbmt_recon
2245: WHERE CURRENT OF c2;
2246: END LOOP ben_prtt_reimbmt_recon;
2247: CLOSE c2;
2248: DELETE FROM ben_prtt_reimbmt_rqst_f

Line 2246: END LOOP ben_prtt_reimbmt_recon;

2242: FETCH c2 INTO l_id;
2243: EXIT WHEN c2%NOTFOUND;
2244: DELETE FROM ben_prtt_reimbmt_recon
2245: WHERE CURRENT OF c2;
2246: END LOOP ben_prtt_reimbmt_recon;
2247: CLOSE c2;
2248: DELETE FROM ben_prtt_reimbmt_rqst_f
2249: WHERE CURRENT OF c1;
2250: END LOOP;