APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_REIMBMT_RECON

Line 2297: FROM ben_prtt_reimbmt_recon

2293: CURSOR c2 (
2294: p_prtt_reimbmt_rqst_id NUMBER
2295: ) IS
2296: SELECT prtt_reimbmt_recon_id
2297: FROM ben_prtt_reimbmt_recon
2298: WHERE prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
2299: FOR UPDATE OF prtt_reimbmt_recon_id;
2300: l_id NUMBER;
2301: BEGIN

Line 2306: <>

2302: FOR r1 IN c1 LOOP
2303: OPEN c2 (
2304: r1.prtt_reimbmt_rqst_id
2305: );
2306: <>
2307: LOOP
2308: FETCH c2 INTO l_id;
2309: EXIT WHEN c2%NOTFOUND;
2310: DELETE FROM ben_prtt_reimbmt_recon

Line 2310: DELETE FROM ben_prtt_reimbmt_recon

2306: <>
2307: LOOP
2308: FETCH c2 INTO l_id;
2309: EXIT WHEN c2%NOTFOUND;
2310: DELETE FROM ben_prtt_reimbmt_recon
2311: WHERE CURRENT OF c2;
2312: END LOOP ben_prtt_reimbmt_recon;
2313: CLOSE c2;
2314: DELETE FROM ben_prtt_reimbmt_rqst_f

Line 2312: END LOOP ben_prtt_reimbmt_recon;

2308: FETCH c2 INTO l_id;
2309: EXIT WHEN c2%NOTFOUND;
2310: DELETE FROM ben_prtt_reimbmt_recon
2311: WHERE CURRENT OF c2;
2312: END LOOP ben_prtt_reimbmt_recon;
2313: CLOSE c2;
2314: DELETE FROM ben_prtt_reimbmt_rqst_f
2315: WHERE CURRENT OF c1;
2316: END LOOP;