APPS.BEN_PERSON_DELETE dependencies on BEN_POPL_ORG_F

Line 206: FROM ben_popl_org_f

202: CURSOR c14 (
203: p_person_id NUMBER
204: ) IS
205: SELECT 1
206: FROM ben_popl_org_f
207: WHERE person_id = p_person_id;
208: CURSOR c18 (
209: p_person_id NUMBER
210: ) IS

Line 876: -- Testing for values in BEN_POPL_ORG_F

872: --
873: CLOSE c5;
874:
875: --
876: -- Testing for values in BEN_POPL_ORG_F
877: --
878: OPEN c14 (
879: p_person_id
880: );

Line 892: 'BEN_POPL_ORG_F'

888: 'BEN_94121_DT_CHILD_EXISTS'
889: );
890: fnd_message.set_token (
891: 'TABLE_NAME',
892: 'BEN_POPL_ORG_F'
893: );
894: fnd_message.raise_error;
895: END IF;
896:

Line 2630: FROM ben_popl_org_f

2626: CURSOR c46 (
2627: p_person_id NUMBER
2628: ) IS
2629: SELECT popl_org_id
2630: FROM ben_popl_org_f
2631: WHERE person_id = p_person_id
2632: FOR UPDATE OF popl_org_id;
2633:
2634: --

Line 3079: <>

3075: if(p_per_in_ler_id is NULL) then
3076: OPEN c46 (
3077: p_person_id
3078: );
3079: <>
3080: LOOP
3081: FETCH c46 INTO l_id;
3082: EXIT WHEN c46%NOTFOUND;
3083: DELETE FROM ben_popl_org_f

Line 3083: DELETE FROM ben_popl_org_f

3079: <>
3080: LOOP
3081: FETCH c46 INTO l_id;
3082: EXIT WHEN c46%NOTFOUND;
3083: DELETE FROM ben_popl_org_f
3084: WHERE CURRENT OF c46;
3085: END LOOP ben_popl_org_f;
3086: CLOSE c46;
3087: OPEN c47 (

Line 3085: END LOOP ben_popl_org_f;

3081: FETCH c46 INTO l_id;
3082: EXIT WHEN c46%NOTFOUND;
3083: DELETE FROM ben_popl_org_f
3084: WHERE CURRENT OF c46;
3085: END LOOP ben_popl_org_f;
3086: CLOSE c46;
3087: OPEN c47 (
3088: p_person_id
3089: );