APPS.BEN_PERSON_DELETE dependencies on BEN_PER_IN_LGL_ENTY_F

Line 139: FROM ben_per_in_lgl_enty_f

135: CURSOR c9 (
136: p_person_id NUMBER
137: ) IS
138: SELECT 1
139: FROM ben_per_in_lgl_enty_f
140: WHERE person_id = p_person_id;
141: CURSOR c10 (
142: p_person_id NUMBER
143: ) IS

Line 752: -- Testing for values in BEN_PER_IN_LGL_ENTY_F

748: --
749: CLOSE c12;
750:
751: --
752: -- Testing for values in BEN_PER_IN_LGL_ENTY_F
753: --
754: OPEN c9 (
755: p_person_id
756: );

Line 768: 'BEN_PER_IN_LGL_ENTY_F'

764: 'BEN_94121_DT_CHILD_EXISTS'
765: );
766: fnd_message.set_token (
767: 'TABLE_NAME',
768: 'BEN_PER_IN_LGL_ENTY_F'
769: );
770: fnd_message.raise_error;
771: END IF;
772:

Line 2484: FROM ben_per_in_lgl_enty_f

2480: CURSOR c42 (
2481: p_person_id NUMBER
2482: ) IS
2483: SELECT per_in_lgl_enty_id
2484: FROM ben_per_in_lgl_enty_f
2485: WHERE person_id = p_person_id
2486: FOR UPDATE OF per_in_lgl_enty_id;
2487:
2488: --

Line 2896: <>

2892:
2893: OPEN c42 (
2894: p_person_id
2895: );
2896: <>
2897: LOOP
2898: FETCH c42 INTO l_id;
2899: EXIT WHEN c42%NOTFOUND;
2900: DELETE FROM ben_per_in_lgl_enty_f

Line 2900: DELETE FROM ben_per_in_lgl_enty_f

2896: <>
2897: LOOP
2898: FETCH c42 INTO l_id;
2899: EXIT WHEN c42%NOTFOUND;
2900: DELETE FROM ben_per_in_lgl_enty_f
2901: WHERE CURRENT OF c42;
2902: END LOOP ben_per_in_lgl_enty_f;
2903: CLOSE c42;
2904: OPEN c43 (

Line 2902: END LOOP ben_per_in_lgl_enty_f;

2898: FETCH c42 INTO l_id;
2899: EXIT WHEN c42%NOTFOUND;
2900: DELETE FROM ben_per_in_lgl_enty_f
2901: WHERE CURRENT OF c42;
2902: END LOOP ben_per_in_lgl_enty_f;
2903: CLOSE c42;
2904: OPEN c43 (
2905: p_person_id
2906: );