APPS.BEN_PERSON_DELETE dependencies on BEN_CRT_ORDR_CVRD_PER

Line 120: FROM ben_crt_ordr_cvrd_per

116: CURSOR c16 (
117: p_person_id NUMBER
118: ) IS
119: SELECT 1
120: FROM ben_crt_ordr_cvrd_per
121: WHERE person_id = p_person_id;
122: CURSOR c17 (
123: p_person_id NUMBER
124: ) IS

Line 526: -- Testing for values in BEN_CRT_ORDR_CVRD_PER

522: --
523: CLOSE c15;
524:
525: --
526: -- Testing for values in BEN_CRT_ORDR_CVRD_PER
527: --
528: OPEN c16 (
529: p_person_id
530: );

Line 542: 'BEN_CRT_ORDR_CVRD_PER'

538: 'BEN_94121_DT_CHILD_EXISTS'
539: );
540: fnd_message.set_token (
541: 'TABLE_NAME',
542: 'BEN_CRT_ORDR_CVRD_PER'
543: );
544: fnd_message.raise_error;
545: END IF;
546:

Line 1159: FROM ben_crt_ordr_cvrd_per

1155: CURSOR c_crt_ordr_cvrd (
1156: p_dpnt_person_id IN NUMBER
1157: ) IS
1158: SELECT crt_ordr_cvrd_per_id
1159: FROM ben_crt_ordr_cvrd_per
1160: WHERE crt_ordr_id IN (SELECT crt_ordr_id
1161: FROM ben_crt_ordr
1162: WHERE person_id = p_dpnt_person_id)
1163: FOR UPDATE OF crt_ordr_id;

Line 1252: DELETE FROM ben_crt_ordr_cvrd_per

1248: if(p_per_in_ler_id is NULL) then
1249: FOR l_crt_ordr_cvrd IN c_crt_ordr_cvrd (
1250: l_ecd.dpnt_person_id
1251: ) LOOP
1252: DELETE FROM ben_crt_ordr_cvrd_per
1253: WHERE CURRENT OF c_crt_ordr_cvrd;
1254: END LOOP;
1255: end if;
1256: hr_utility.set_location(l_proc, 15);

Line 2496: FROM ben_crt_ordr_cvrd_per

2492: CURSOR c32 (
2493: p_person_id NUMBER
2494: ) IS
2495: SELECT crt_ordr_cvrd_per_id
2496: FROM ben_crt_ordr_cvrd_per
2497: WHERE crt_ordr_id IN (SELECT crt_ordr_id
2498: FROM ben_crt_ordr
2499: WHERE person_id = p_person_id)
2500: FOR UPDATE OF crt_ordr_cvrd_per_id;

Line 2875: <>

2871: if(p_per_in_ler_id is NULL) then
2872: OPEN c32 (
2873: p_person_id
2874: );
2875: <>
2876: LOOP
2877: FETCH c32 INTO l_id;
2878: EXIT WHEN c32%NOTFOUND;
2879: DELETE FROM ben_crt_ordr_cvrd_per

Line 2879: DELETE FROM ben_crt_ordr_cvrd_per

2875: <>
2876: LOOP
2877: FETCH c32 INTO l_id;
2878: EXIT WHEN c32%NOTFOUND;
2879: DELETE FROM ben_crt_ordr_cvrd_per
2880: WHERE CURRENT OF c32;
2881: END LOOP ben_crt_ordr_cvrd_per;
2882: CLOSE c32;
2883: OPEN c33 (

Line 2881: END LOOP ben_crt_ordr_cvrd_per;

2877: FETCH c32 INTO l_id;
2878: EXIT WHEN c32%NOTFOUND;
2879: DELETE FROM ben_crt_ordr_cvrd_per
2880: WHERE CURRENT OF c32;
2881: END LOOP ben_crt_ordr_cvrd_per;
2882: CLOSE c32;
2883: OPEN c33 (
2884: p_person_id
2885: );