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_LER_INFO

Line 47: FROM ben_batch_ler_info

43: CURSOR c24 (
44: p_person_id NUMBER
45: ) IS
46: SELECT 1
47: FROM ben_batch_ler_info
48: WHERE person_id = p_person_id;
49: CURSOR c25 (
50: p_person_id NUMBER
51: ) IS

Line 377: -- Testing for values in BEN_BATCH_LER_INFO

373: --
374: CLOSE c23;
375:
376: --
377: -- Testing for values in BEN_BATCH_LER_INFO
378: --
379: OPEN c24 (
380: p_person_id
381: );

Line 393: 'BEN_BATCH_LER_INFO'

389: 'BEN_94121_DT_CHILD_EXISTS'
390: );
391: fnd_message.set_token (
392: 'TABLE_NAME',
393: 'BEN_BATCH_LER_INFO'
394: );
395: fnd_message.raise_error;
396: END IF;
397:

Line 2336: FROM ben_batch_ler_info

2332: CURSOR c26 (
2333: p_person_id NUMBER
2334: ) IS
2335: SELECT batch_ler_id
2336: FROM ben_batch_ler_info
2337: WHERE person_id = p_person_id
2338: FOR UPDATE OF batch_ler_id;
2339:
2340: --

Line 2683: <>

2679: CLOSE c25;
2680: OPEN c26 (
2681: p_person_id
2682: );
2683: <>
2684: LOOP
2685: FETCH c26 INTO l_id;
2686: EXIT WHEN c26%NOTFOUND;
2687: DELETE FROM ben_batch_ler_info

Line 2687: DELETE FROM ben_batch_ler_info

2683: <>
2684: LOOP
2685: FETCH c26 INTO l_id;
2686: EXIT WHEN c26%NOTFOUND;
2687: DELETE FROM ben_batch_ler_info
2688: WHERE CURRENT OF c26;
2689: END LOOP ben_batch_ler_info;
2690: CLOSE c26;
2691: OPEN c27 (

Line 2689: END LOOP ben_batch_ler_info;

2685: FETCH c26 INTO l_id;
2686: EXIT WHEN c26%NOTFOUND;
2687: DELETE FROM ben_batch_ler_info
2688: WHERE CURRENT OF c26;
2689: END LOOP ben_batch_ler_info;
2690: CLOSE c26;
2691: OPEN c27 (
2692: p_person_id
2693: );