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_PL_BNF_F

Line 220: FROM ben_pl_bnf_f

216: CURSOR c35 (
217: p_person_id NUMBER
218: ) IS
219: SELECT 1
220: FROM ben_pl_bnf_f
221: WHERE bnf_person_id = p_person_id;
222:
223: l_temp VARCHAR2 (2);
224: BEGIN

Line 1644: FROM ben_pl_bnf_f

1640: CURSOR c30 (
1641: p_per_in_ler_id IN NUMBER
1642: ) IS
1643: SELECT pl_bnf_id
1644: FROM ben_pl_bnf_f
1645: WHERE per_in_ler_id = p_per_in_ler_id
1646: FOR UPDATE OF pl_bnf_id;
1647:
1648: --

Line 1941: <>

1937: CLOSE c29;
1938: OPEN c30 (
1939: r1.per_in_ler_id
1940: );
1941: <>
1942: LOOP
1943: FETCH c30 INTO l_id;
1944: EXIT WHEN c30%NOTFOUND;
1945: DELETE FROM ben_pl_bnf_f

Line 1945: DELETE FROM ben_pl_bnf_f

1941: <>
1942: LOOP
1943: FETCH c30 INTO l_id;
1944: EXIT WHEN c30%NOTFOUND;
1945: DELETE FROM ben_pl_bnf_f
1946: WHERE CURRENT OF c30;
1947: END LOOP ben_pl_bnf_f;
1948: CLOSE c30;
1949: OPEN c31 (

Line 1947: END LOOP ben_pl_bnf_f;

1943: FETCH c30 INTO l_id;
1944: EXIT WHEN c30%NOTFOUND;
1945: DELETE FROM ben_pl_bnf_f
1946: WHERE CURRENT OF c30;
1947: END LOOP ben_pl_bnf_f;
1948: CLOSE c30;
1949: OPEN c31 (
1950: r1.per_in_ler_id
1951: );

Line 2547: FROM ben_pl_bnf_f

2543: CURSOR c48 (
2544: p_person_id NUMBER
2545: ) IS
2546: SELECT pl_bnf_id
2547: FROM ben_pl_bnf_f
2548: WHERE bnf_person_id = p_person_id
2549: FOR UPDATE OF pl_bnf_id;
2550:
2551: --

Line 2965: <>

2961:
2962: OPEN c48 (
2963: p_person_id
2964: );
2965: <>
2966: LOOP
2967: FETCH c48 INTO l_id;
2968: EXIT WHEN c48%NOTFOUND;
2969: DELETE FROM ben_pl_bnf_f

Line 2969: DELETE FROM ben_pl_bnf_f

2965: <>
2966: LOOP
2967: FETCH c48 INTO l_id;
2968: EXIT WHEN c48%NOTFOUND;
2969: DELETE FROM ben_pl_bnf_f
2970: WHERE CURRENT OF c48;
2971: END LOOP ben_pl_bnf_f;
2972: CLOSE c48;
2973:

Line 2971: END LOOP ben_pl_bnf_f;

2967: FETCH c48 INTO l_id;
2968: EXIT WHEN c48%NOTFOUND;
2969: DELETE FROM ben_pl_bnf_f
2970: WHERE CURRENT OF c48;
2971: END LOOP ben_pl_bnf_f;
2972: CLOSE c48;
2973:
2974: EXCEPTION
2975: WHEN OTHERS THEN

Line 3103: FROM ben_pl_bnf_f pbn,

3099: CURSOR c_plbnf( p_person_id number ,
3100: p_effective_date date
3101: ) is
3102: SELECT 'Y'
3103: FROM ben_pl_bnf_f pbn,
3104: ben_per_in_ler pil,
3105: ben_ler_f ler,
3106: ben_prtt_enrt_rslt_f pen
3107: WHERE