APPS.BEN_PERSON_DELETE dependencies on BEN_CBR_PER_IN_LER

Line 1647: FROM ben_cbr_per_in_ler

1643: CURSOR c24 (
1644: p_per_in_ler_id IN NUMBER
1645: ) IS
1646: SELECT cbr_per_in_ler_id
1647: FROM ben_cbr_per_in_ler
1648: WHERE per_in_ler_id = p_per_in_ler_id
1649: FOR UPDATE OF cbr_per_in_ler_id;
1650:
1651: --

Line 1931: <>

1927: END LOOP;
1928: OPEN c24 (
1929: r1.per_in_ler_id
1930: );
1931: <>
1932: LOOP
1933: FETCH c24 INTO l_id;
1934: EXIT WHEN c24%NOTFOUND;
1935: DELETE FROM ben_cbr_per_in_ler

Line 1935: DELETE FROM ben_cbr_per_in_ler

1931: <>
1932: LOOP
1933: FETCH c24 INTO l_id;
1934: EXIT WHEN c24%NOTFOUND;
1935: DELETE FROM ben_cbr_per_in_ler
1936: WHERE CURRENT OF c24;
1937: END LOOP ben_cbr_per_in_ler;
1938: CLOSE c24;
1939: OPEN c25 (

Line 1937: END LOOP ben_cbr_per_in_ler;

1933: FETCH c24 INTO l_id;
1934: EXIT WHEN c24%NOTFOUND;
1935: DELETE FROM ben_cbr_per_in_ler
1936: WHERE CURRENT OF c24;
1937: END LOOP ben_cbr_per_in_ler;
1938: CLOSE c24;
1939: OPEN c25 (
1940: r1.per_in_ler_id
1941: );