APPS.BEN_PERSON_DELETE dependencies on BEN_PER_DLVRY_MTHD_F

Line 176: FROM ben_per_dlvry_mthd_f

172: CURSOR c8 (
173: p_person_id NUMBER
174: ) IS
175: SELECT 1
176: FROM ben_per_dlvry_mthd_f
177: WHERE person_id = p_person_id;
178: CURSOR c12 (
179: p_person_id NUMBER
180: ) IS

Line 751: -- Testing for values in BEN_PER_DLVRY_MTHD_F

747: --
748: CLOSE c19;
749:
750: --
751: -- Testing for values in BEN_PER_DLVRY_MTHD_F
752: --
753: OPEN c8 (
754: p_person_id
755: );

Line 767: 'BEN_PER_DLVRY_MTHD_F'

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

Line 2572: FROM ben_per_dlvry_mthd_f

2568: CURSOR c40 (
2569: p_person_id NUMBER
2570: ) IS
2571: SELECT per_dlvry_mthd_id
2572: FROM ben_per_dlvry_mthd_f
2573: WHERE person_id = p_person_id
2574: FOR UPDATE OF per_dlvry_mthd_id;
2575:
2576: --

Line 2967: <>

2963: if(p_per_in_ler_id is NULL) then
2964: OPEN c40 (
2965: p_person_id
2966: );
2967: <>
2968: LOOP
2969: FETCH c40 INTO l_id;
2970: EXIT WHEN c40%NOTFOUND;
2971: DELETE FROM ben_per_dlvry_mthd_f

Line 2971: DELETE FROM ben_per_dlvry_mthd_f

2967: <>
2968: LOOP
2969: FETCH c40 INTO l_id;
2970: EXIT WHEN c40%NOTFOUND;
2971: DELETE FROM ben_per_dlvry_mthd_f
2972: WHERE CURRENT OF c40;
2973: END LOOP ben_per_dlvry_mthd_f;
2974: CLOSE c40;
2975: end if;

Line 2973: END LOOP ben_per_dlvry_mthd_f;

2969: FETCH c40 INTO l_id;
2970: EXIT WHEN c40%NOTFOUND;
2971: DELETE FROM ben_per_dlvry_mthd_f
2972: WHERE CURRENT OF c40;
2973: END LOOP ben_per_dlvry_mthd_f;
2974: CLOSE c40;
2975: end if;
2976: OPEN c41 (
2977: p_person_id