APPS.BEN_PERSON_DELETE dependencies on BEN_PER_IN_ORG_UNIT_F

Line 194: FROM ben_per_in_org_unit_f

190: CURSOR c10 (
191: p_person_id NUMBER
192: ) IS
193: SELECT 1
194: FROM ben_per_in_org_unit_f
195: WHERE person_id = p_person_id;
196: CURSOR c5 (
197: p_person_id NUMBER
198: ) IS

Line 826: -- Testing for values in BEN_PER_IN_ORG_UNIT_F

822: --
823: CLOSE c9;
824:
825: --
826: -- Testing for values in BEN_PER_IN_ORG_UNIT_F
827: --
828: OPEN c10 (
829: p_person_id
830: );

Line 842: 'BEN_PER_IN_ORG_UNIT_F'

838: 'BEN_94121_DT_CHILD_EXISTS'
839: );
840: fnd_message.set_token (
841: 'TABLE_NAME',
842: 'BEN_PER_IN_ORG_UNIT_F'
843: );
844: fnd_message.raise_error;
845: END IF;
846:

Line 2600: FROM ben_per_in_org_unit_f

2596: CURSOR c43 (
2597: p_person_id NUMBER
2598: ) IS
2599: SELECT per_in_org_unit_id
2600: FROM ben_per_in_org_unit_f
2601: WHERE person_id = p_person_id
2602: FOR UPDATE OF per_in_org_unit_id;
2603:
2604: --

Line 3041: <>

3037: CLOSE c42;
3038: OPEN c43 (
3039: p_person_id
3040: );
3041: <>
3042: LOOP
3043: FETCH c43 INTO l_id;
3044: EXIT WHEN c43%NOTFOUND;
3045: DELETE FROM ben_per_in_org_unit_f

Line 3045: DELETE FROM ben_per_in_org_unit_f

3041: <>
3042: LOOP
3043: FETCH c43 INTO l_id;
3044: EXIT WHEN c43%NOTFOUND;
3045: DELETE FROM ben_per_in_org_unit_f
3046: WHERE CURRENT OF c43;
3047: END LOOP ben_per_in_org_unit_f;
3048: CLOSE c43;
3049:

Line 3047: END LOOP ben_per_in_org_unit_f;

3043: FETCH c43 INTO l_id;
3044: EXIT WHEN c43%NOTFOUND;
3045: DELETE FROM ben_per_in_org_unit_f
3046: WHERE CURRENT OF c43;
3047: END LOOP ben_per_in_org_unit_f;
3048: CLOSE c43;
3049:
3050: OPEN c44 (
3051: p_person_id