APPS.BEN_PERSON_DELETE dependencies on BEN_PER_PIN_F

Line 200: FROM ben_per_pin_f

196: CURSOR c5 (
197: p_person_id NUMBER
198: ) IS
199: SELECT 1
200: FROM ben_per_pin_f
201: WHERE person_id = p_person_id;
202: CURSOR c14 (
203: p_person_id NUMBER
204: ) IS

Line 851: -- Testing for values in BEN_PER_PIN_F

847: --
848: CLOSE c10;
849:
850: --
851: -- Testing for values in BEN_PER_PIN_F
852: --
853: OPEN c5 (
854: p_person_id
855: );

Line 867: 'BEN_PER_PIN_F'

863: 'BEN_94121_DT_CHILD_EXISTS'
864: );
865: fnd_message.set_token (
866: 'TABLE_NAME',
867: 'BEN_PER_PIN_F'
868: );
869: fnd_message.raise_error;
870: END IF;
871:

Line 2609: FROM ben_per_pin_f

2605: CURSOR c44 (
2606: p_person_id NUMBER
2607: ) IS
2608: SELECT per_pin_id
2609: FROM ben_per_pin_f
2610: WHERE person_id = p_person_id
2611: FOR UPDATE OF per_pin_id;
2612:
2613: --

Line 3053: <>

3049:
3050: OPEN c44 (
3051: p_person_id
3052: );
3053: <>
3054: LOOP
3055: FETCH c44 INTO l_id;
3056: EXIT WHEN c44%NOTFOUND;
3057: DELETE FROM ben_per_pin_f

Line 3057: DELETE FROM ben_per_pin_f

3053: <>
3054: LOOP
3055: FETCH c44 INTO l_id;
3056: EXIT WHEN c44%NOTFOUND;
3057: DELETE FROM ben_per_pin_f
3058: WHERE CURRENT OF c44;
3059: END LOOP ben_per_pin_f;
3060: CLOSE c44;
3061: end if;

Line 3059: END LOOP ben_per_pin_f;

3055: FETCH c44 INTO l_id;
3056: EXIT WHEN c44%NOTFOUND;
3057: DELETE FROM ben_per_pin_f
3058: WHERE CURRENT OF c44;
3059: END LOOP ben_per_pin_f;
3060: CLOSE c44;
3061: end if;
3062:
3063: OPEN c45 (