APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_RT_VAL

Line 1465: FROM ben_prtt_rt_val

1461: CURSOR c10 (
1462: p_prtt_enrt_rslt_id NUMBER
1463: ) IS
1464: SELECT prtt_rt_val_id
1465: FROM ben_prtt_rt_val
1466: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1467: FOR UPDATE OF prtt_rt_val_id;
1468:
1469: --

Line 1738: <>

1734: CLOSE c9;
1735: OPEN c10 (
1736: r4.prtt_enrt_rslt_id
1737: );
1738: <>
1739: LOOP
1740: FETCH c10 INTO l_id;
1741: EXIT WHEN c10%NOTFOUND;
1742: DELETE FROM ben_prtt_rt_val

Line 1742: DELETE FROM ben_prtt_rt_val

1738: <>
1739: LOOP
1740: FETCH c10 INTO l_id;
1741: EXIT WHEN c10%NOTFOUND;
1742: DELETE FROM ben_prtt_rt_val
1743: WHERE CURRENT OF c10;
1744: END LOOP ben_prtt_rt_val;
1745: CLOSE c10;
1746: OPEN c11 (

Line 1744: END LOOP ben_prtt_rt_val;

1740: FETCH c10 INTO l_id;
1741: EXIT WHEN c10%NOTFOUND;
1742: DELETE FROM ben_prtt_rt_val
1743: WHERE CURRENT OF c10;
1744: END LOOP ben_prtt_rt_val;
1745: CLOSE c10;
1746: OPEN c11 (
1747: r4.prtt_enrt_rslt_id
1748: );

Line 2031: FROM ben_prtt_rt_val

2027: CURSOR c7 (
2028: p_prtt_enrt_rslt_id NUMBER
2029: ) IS
2030: SELECT prtt_rt_val_id
2031: FROM ben_prtt_rt_val
2032: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2033: FOR UPDATE OF prtt_rt_val_id;
2034: CURSOR c8 (
2035: p_prtt_enrt_rslt_id NUMBER

Line 2105: <>

2101: CLOSE c6;
2102: OPEN c7 (
2103: r1.prtt_enrt_rslt_id
2104: );
2105: <>
2106: LOOP
2107: FETCH c7 INTO l_id;
2108: EXIT WHEN c7%NOTFOUND;
2109: DELETE FROM ben_prtt_rt_val

Line 2109: DELETE FROM ben_prtt_rt_val

2105: <>
2106: LOOP
2107: FETCH c7 INTO l_id;
2108: EXIT WHEN c7%NOTFOUND;
2109: DELETE FROM ben_prtt_rt_val
2110: WHERE CURRENT OF c7;
2111: END LOOP ben_prtt_rt_val;
2112: CLOSE c7;
2113: OPEN c8 (

Line 2111: END LOOP ben_prtt_rt_val;

2107: FETCH c7 INTO l_id;
2108: EXIT WHEN c7%NOTFOUND;
2109: DELETE FROM ben_prtt_rt_val
2110: WHERE CURRENT OF c7;
2111: END LOOP ben_prtt_rt_val;
2112: CLOSE c7;
2113: OPEN c8 (
2114: r1.prtt_enrt_rslt_id
2115: );

Line 3034: FROM ben_prtt_rt_val prv,

3030: CURSOR c_prv( p_person_id number ,
3031: p_effective_date date
3032: ) is
3033: SELECT 'Y'
3034: FROM ben_prtt_rt_val prv,
3035: ben_prtt_enrt_rslt_f pen,
3036: ben_ler_f ler
3037: WHERE
3038: pen.person_id=p_person_id and