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 269: FROM ben_pl_bnf_f

265: CURSOR c35 (
266: p_person_id NUMBER
267: ) IS
268: SELECT 1
269: FROM ben_pl_bnf_f
270: WHERE bnf_person_id = p_person_id;
271:
272: l_temp VARCHAR2 (2);
273: BEGIN

Line 1701: FROM ben_pl_bnf_f

1697: CURSOR c30 (
1698: p_per_in_ler_id IN NUMBER
1699: ) IS
1700: SELECT pl_bnf_id
1701: FROM ben_pl_bnf_f
1702: WHERE per_in_ler_id = p_per_in_ler_id
1703: FOR UPDATE OF pl_bnf_id;
1704:
1705: --

Line 1998: <>

1994: CLOSE c29;
1995: OPEN c30 (
1996: r1.per_in_ler_id
1997: );
1998: <>
1999: LOOP
2000: FETCH c30 INTO l_id;
2001: EXIT WHEN c30%NOTFOUND;
2002: DELETE FROM ben_pl_bnf_f

Line 2002: DELETE FROM ben_pl_bnf_f

1998: <>
1999: LOOP
2000: FETCH c30 INTO l_id;
2001: EXIT WHEN c30%NOTFOUND;
2002: DELETE FROM ben_pl_bnf_f
2003: WHERE CURRENT OF c30;
2004: END LOOP ben_pl_bnf_f;
2005: CLOSE c30;
2006: OPEN c31 (

Line 2004: END LOOP ben_pl_bnf_f;

2000: FETCH c30 INTO l_id;
2001: EXIT WHEN c30%NOTFOUND;
2002: DELETE FROM ben_pl_bnf_f
2003: WHERE CURRENT OF c30;
2004: END LOOP ben_pl_bnf_f;
2005: CLOSE c30;
2006: OPEN c31 (
2007: r1.per_in_ler_id
2008: );

Line 2657: FROM ben_pl_bnf_f

2653: CURSOR c48 (
2654: p_person_id NUMBER
2655: ) IS
2656: SELECT pl_bnf_id
2657: FROM ben_pl_bnf_f
2658: WHERE bnf_person_id = p_person_id
2659: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id)
2660: FOR UPDATE OF pl_bnf_id;
2661:

Line 3103: <>

3099:
3100: OPEN c48 (
3101: p_person_id
3102: );
3103: <>
3104: LOOP
3105: FETCH c48 INTO l_id;
3106: EXIT WHEN c48%NOTFOUND;
3107: DELETE FROM ben_pl_bnf_f

Line 3107: DELETE FROM ben_pl_bnf_f

3103: <>
3104: LOOP
3105: FETCH c48 INTO l_id;
3106: EXIT WHEN c48%NOTFOUND;
3107: DELETE FROM ben_pl_bnf_f
3108: WHERE CURRENT OF c48;
3109: END LOOP ben_pl_bnf_f;
3110: CLOSE c48;
3111:

Line 3109: END LOOP ben_pl_bnf_f;

3105: FETCH c48 INTO l_id;
3106: EXIT WHEN c48%NOTFOUND;
3107: DELETE FROM ben_pl_bnf_f
3108: WHERE CURRENT OF c48;
3109: END LOOP ben_pl_bnf_f;
3110: CLOSE c48;
3111:
3112: EXCEPTION
3113: WHEN OTHERS THEN

Line 3241: FROM ben_pl_bnf_f pbn,

3237: CURSOR c_plbnf( p_person_id number ,
3238: p_effective_date date
3239: ) is
3240: SELECT 'Y'
3241: FROM ben_pl_bnf_f pbn,
3242: ben_per_in_ler pil,
3243: ben_ler_f ler,
3244: ben_prtt_enrt_rslt_f pen
3245: WHERE