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_BATCH_RATE_INFO

Line 53: FROM ben_batch_rate_info

49: CURSOR c25 (
50: p_person_id NUMBER
51: ) IS
52: SELECT 1
53: FROM ben_batch_rate_info
54: WHERE person_id = p_person_id;
55: CURSOR c26 (
56: p_person_id NUMBER
57: ) IS

Line 402: -- Testing for values in BEN_BATCH_RATE_INFO

398: --
399: CLOSE c24;
400:
401: --
402: -- Testing for values in BEN_BATCH_RATE_INFO
403: --
404: OPEN c25 (
405: p_person_id
406: );

Line 418: 'BEN_BATCH_RATE_INFO'

414: 'BEN_94121_DT_CHILD_EXISTS'
415: );
416: fnd_message.set_token (
417: 'TABLE_NAME',
418: 'BEN_BATCH_RATE_INFO'
419: );
420: fnd_message.raise_error;
421: END IF;
422:

Line 2345: FROM ben_batch_rate_info

2341: CURSOR c27 (
2342: p_person_id NUMBER
2343: ) IS
2344: SELECT batch_rt_id
2345: FROM ben_batch_rate_info
2346: WHERE person_id = p_person_id
2347: FOR UPDATE OF batch_rt_id;
2348:
2349: --

Line 2694: <>

2690: CLOSE c26;
2691: OPEN c27 (
2692: p_person_id
2693: );
2694: <>
2695: LOOP
2696: FETCH c27 INTO l_id;
2697: EXIT WHEN c27%NOTFOUND;
2698: DELETE FROM ben_batch_rate_info

Line 2698: DELETE FROM ben_batch_rate_info

2694: <>
2695: LOOP
2696: FETCH c27 INTO l_id;
2697: EXIT WHEN c27%NOTFOUND;
2698: DELETE FROM ben_batch_rate_info
2699: WHERE CURRENT OF c27;
2700: END LOOP ben_batch_rate_info;
2701: CLOSE c27;
2702: OPEN c28 (

Line 2700: END LOOP ben_batch_rate_info;

2696: FETCH c27 INTO l_id;
2697: EXIT WHEN c27%NOTFOUND;
2698: DELETE FROM ben_batch_rate_info
2699: WHERE CURRENT OF c27;
2700: END LOOP ben_batch_rate_info;
2701: CLOSE c27;
2702: OPEN c28 (
2703: p_person_id
2704: );