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_PER_CM_F

Line 121: FROM ben_per_cm_f

117: CURSOR c19 (
118: p_person_id NUMBER
119: ) IS
120: SELECT 1
121: FROM ben_per_cm_f
122: WHERE person_id = p_person_id;
123: CURSOR c8 (
124: p_person_id NUMBER
125: ) IS

Line 677: -- Testing for values in BEN_PER_CM_F

673: --
674: CLOSE c4;
675:
676: --
677: -- Testing for values in BEN_PER_CM_F
678: --
679: OPEN c19 (
680: p_person_id
681: );

Line 693: 'BEN_PER_CM_F'

689: 'BEN_94121_DT_CHILD_EXISTS'
690: );
691: fnd_message.set_token (
692: 'TABLE_NAME',
693: 'BEN_PER_CM_F'
694: );
695: fnd_message.raise_error;
696: END IF;
697:

Line 1307: --** CN|c4|Fetch the per_cm_id from ben_per_cm_f associated with a person_id.

1303: ) IS
1304: l_proc varchar2(100):= g_package||'delete_communications';
1305:
1306: --** C|c1
1307: --** CN|c4|Fetch the per_cm_id from ben_per_cm_f associated with a person_id.
1308: CURSOR c1 IS
1309: SELECT DISTINCT per_cm_id
1310: FROM ben_per_cm_f
1311: WHERE person_id = p_person_id;

Line 1310: FROM ben_per_cm_f

1306: --** C|c1
1307: --** CN|c4|Fetch the per_cm_id from ben_per_cm_f associated with a person_id.
1308: CURSOR c1 IS
1309: SELECT DISTINCT per_cm_id
1310: FROM ben_per_cm_f
1311: WHERE person_id = p_person_id;
1312:
1313: --
1314: CURSOR c2 (

Line 2457: FROM ben_per_cm_f

2453: CURSOR c39 (
2454: p_person_id NUMBER
2455: ) IS
2456: SELECT per_cm_id
2457: FROM ben_per_cm_f
2458: WHERE person_id = p_person_id
2459: FOR UPDATE OF per_cm_id;
2460:
2461: --

Line 2826: <>

2822: CLOSE c38;
2823: OPEN c39 (
2824: p_person_id
2825: );
2826: <>
2827: LOOP
2828: FETCH c39 INTO l_id;
2829: EXIT WHEN c39%NOTFOUND;
2830: DELETE FROM ben_per_cm_f

Line 2830: DELETE FROM ben_per_cm_f

2826: <>
2827: LOOP
2828: FETCH c39 INTO l_id;
2829: EXIT WHEN c39%NOTFOUND;
2830: DELETE FROM ben_per_cm_f
2831: WHERE CURRENT OF c39;
2832: END LOOP ben_per_cm_f;
2833: CLOSE c39;
2834: OPEN c40 (

Line 2832: END LOOP ben_per_cm_f;

2828: FETCH c39 INTO l_id;
2829: EXIT WHEN c39%NOTFOUND;
2830: DELETE FROM ben_per_cm_f
2831: WHERE CURRENT OF c39;
2832: END LOOP ben_per_cm_f;
2833: CLOSE c39;
2834: OPEN c40 (
2835: p_person_id
2836: );