eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_PREM_F

Line 1449: --** CN|c2|Fetch the prtt_prem_id from ben_prtt_prem_f associated with a per_in_ler_id.

1445: FROM ben_per_in_ler
1446: WHERE person_id = p_person_id
1447: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id);
1448: --** C|c2|p_per_in_ler_id in number
1449: --** CN|c2|Fetch the prtt_prem_id from ben_prtt_prem_f associated with a per_in_ler_id.
1450: CURSOR c2 (
1451: p_per_in_ler_id IN NUMBER
1452: ) IS
1453: SELECT DISTINCT prtt_prem_id

Line 1454: FROM ben_prtt_prem_f

1450: CURSOR c2 (
1451: p_per_in_ler_id IN NUMBER
1452: ) IS
1453: SELECT DISTINCT prtt_prem_id
1454: FROM ben_prtt_prem_f
1455: WHERE per_in_ler_id = p_per_in_ler_id;
1456: CURSOR c3 (
1457: p_prtt_prem_id NUMBER
1458: ) IS

Line 1513: FROM ben_prtt_prem_f

1509: CURSOR c9 (
1510: p_prtt_enrt_rslt_id NUMBER
1511: ) IS
1512: SELECT prtt_prem_id
1513: FROM ben_prtt_prem_f
1514: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1515: FOR UPDATE OF prtt_prem_id;
1516:
1517: --

Line 1784: <>

1780: CLOSE c8;
1781: OPEN c9 (
1782: r4.prtt_enrt_rslt_id
1783: );
1784: <>
1785: LOOP
1786: FETCH c9 INTO l_id;
1787: EXIT WHEN c9%NOTFOUND;
1788: DELETE FROM ben_prtt_prem_f

Line 1788: DELETE FROM ben_prtt_prem_f

1784: <>
1785: LOOP
1786: FETCH c9 INTO l_id;
1787: EXIT WHEN c9%NOTFOUND;
1788: DELETE FROM ben_prtt_prem_f
1789: WHERE CURRENT OF c9;
1790: END LOOP ben_prtt_prem_f;
1791: CLOSE c9;
1792: OPEN c10 (

Line 1790: END LOOP ben_prtt_prem_f;

1786: FETCH c9 INTO l_id;
1787: EXIT WHEN c9%NOTFOUND;
1788: DELETE FROM ben_prtt_prem_f
1789: WHERE CURRENT OF c9;
1790: END LOOP ben_prtt_prem_f;
1791: CLOSE c9;
1792: OPEN c10 (
1793: r4.prtt_enrt_rslt_id
1794: );

Line 2081: FROM ben_prtt_prem_f

2077: CURSOR c6 (
2078: p_prtt_enrt_rslt_id NUMBER
2079: ) IS
2080: SELECT prtt_prem_id
2081: FROM ben_prtt_prem_f
2082: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2083: FOR UPDATE OF prtt_prem_id;
2084:
2085: --

Line 2153: <>

2149: CLOSE c5;
2150: OPEN c6 (
2151: r1.prtt_enrt_rslt_id
2152: );
2153: <>
2154: LOOP
2155: FETCH c6 INTO l_id;
2156: EXIT WHEN c6%NOTFOUND;
2157: DELETE FROM ben_prtt_prem_f

Line 2157: DELETE FROM ben_prtt_prem_f

2153: <>
2154: LOOP
2155: FETCH c6 INTO l_id;
2156: EXIT WHEN c6%NOTFOUND;
2157: DELETE FROM ben_prtt_prem_f
2158: WHERE CURRENT OF c6;
2159: END LOOP ben_prtt_prem_f;
2160: CLOSE c6;
2161: OPEN c7 (

Line 2159: END LOOP ben_prtt_prem_f;

2155: FETCH c6 INTO l_id;
2156: EXIT WHEN c6%NOTFOUND;
2157: DELETE FROM ben_prtt_prem_f
2158: WHERE CURRENT OF c6;
2159: END LOOP ben_prtt_prem_f;
2160: CLOSE c6;
2161: OPEN c7 (
2162: r1.prtt_enrt_rslt_id
2163: );