APPS.BEN_PERSON_DELETE dependencies on BEN_CRT_ORDR_CVRD_PER

Line 71: FROM ben_crt_ordr_cvrd_per

67: CURSOR c16 (
68: p_person_id NUMBER
69: ) IS
70: SELECT 1
71: FROM ben_crt_ordr_cvrd_per
72: WHERE person_id = p_person_id;
73: CURSOR c17 (
74: p_person_id NUMBER
75: ) IS

Line 477: -- Testing for values in BEN_CRT_ORDR_CVRD_PER

473: --
474: CLOSE c15;
475:
476: --
477: -- Testing for values in BEN_CRT_ORDR_CVRD_PER
478: --
479: OPEN c16 (
480: p_person_id
481: );

Line 493: 'BEN_CRT_ORDR_CVRD_PER'

489: 'BEN_94121_DT_CHILD_EXISTS'
490: );
491: fnd_message.set_token (
492: 'TABLE_NAME',
493: 'BEN_CRT_ORDR_CVRD_PER'
494: );
495: fnd_message.raise_error;
496: END IF;
497:

Line 1108: FROM ben_crt_ordr_cvrd_per

1104: CURSOR c_crt_ordr_cvrd (
1105: p_dpnt_person_id IN NUMBER
1106: ) IS
1107: SELECT crt_ordr_cvrd_per_id
1108: FROM ben_crt_ordr_cvrd_per
1109: WHERE crt_ordr_id IN (SELECT crt_ordr_id
1110: FROM ben_crt_ordr
1111: WHERE person_id = p_dpnt_person_id)
1112: FOR UPDATE OF crt_ordr_id;

Line 1200: DELETE FROM ben_crt_ordr_cvrd_per

1196: FOR l_ecd IN c_ecd LOOP
1197: FOR l_crt_ordr_cvrd IN c_crt_ordr_cvrd (
1198: l_ecd.dpnt_person_id
1199: ) LOOP
1200: DELETE FROM ben_crt_ordr_cvrd_per
1201: WHERE CURRENT OF c_crt_ordr_cvrd;
1202: END LOOP;
1203: hr_utility.set_location(l_proc, 15);
1204: FOR l_cvrd_dpnt IN c_cvrd_dpnt (

Line 2392: FROM ben_crt_ordr_cvrd_per

2388: CURSOR c32 (
2389: p_person_id NUMBER
2390: ) IS
2391: SELECT crt_ordr_cvrd_per_id
2392: FROM ben_crt_ordr_cvrd_per
2393: WHERE crt_ordr_id IN (SELECT crt_ordr_id
2394: FROM ben_crt_ordr
2395: WHERE person_id = p_person_id)
2396: FOR UPDATE OF crt_ordr_cvrd_per_id;

Line 2749: <>

2745: CLOSE c31;
2746: OPEN c32 (
2747: p_person_id
2748: );
2749: <>
2750: LOOP
2751: FETCH c32 INTO l_id;
2752: EXIT WHEN c32%NOTFOUND;
2753: DELETE FROM ben_crt_ordr_cvrd_per

Line 2753: DELETE FROM ben_crt_ordr_cvrd_per

2749: <>
2750: LOOP
2751: FETCH c32 INTO l_id;
2752: EXIT WHEN c32%NOTFOUND;
2753: DELETE FROM ben_crt_ordr_cvrd_per
2754: WHERE CURRENT OF c32;
2755: END LOOP ben_crt_ordr_cvrd_per;
2756: CLOSE c32;
2757: OPEN c33 (

Line 2755: END LOOP ben_crt_ordr_cvrd_per;

2751: FETCH c32 INTO l_id;
2752: EXIT WHEN c32%NOTFOUND;
2753: DELETE FROM ben_crt_ordr_cvrd_per
2754: WHERE CURRENT OF c32;
2755: END LOOP ben_crt_ordr_cvrd_per;
2756: CLOSE c32;
2757: OPEN c33 (
2758: p_person_id
2759: );