APPS.BEN_PERSON_DELETE dependencies on BEN_PTNL_LER_FOR_PER

Line 218: FROM ben_ptnl_ler_for_per

214: CURSOR c13 (
215: p_person_id NUMBER
216: ) IS
217: SELECT 1
218: FROM ben_ptnl_ler_for_per
219: WHERE person_id = p_person_id;
220: CURSOR c28 (
221: p_person_id NUMBER
222: ) IS

Line 926: -- Testing for values in BEN_PTNL_LER_FOR_PER

922: --
923: CLOSE c18;
924:
925: --
926: -- Testing for values in BEN_PTNL_LER_FOR_PER
927: --
928: OPEN c13 (
929: p_person_id
930: );

Line 942: 'BEN_PTNL_LER_FOR_PER'

938: 'BEN_94121_DT_CHILD_EXISTS'
939: );
940: fnd_message.set_token (
941: 'TABLE_NAME',
942: 'BEN_PTNL_LER_FOR_PER'
943: );
944: fnd_message.raise_error;
945: END IF;
946:

Line 2618: FROM ben_ptnl_ler_for_per ptnl,ben_ler_f ler

2614: CURSOR c45 (
2615: p_person_id NUMBER
2616: ) IS
2617: SELECT ptnl_ler_for_per_id
2618: FROM ben_ptnl_ler_for_per ptnl,ben_ler_f ler
2619: WHERE person_id = p_person_id
2620: and ler.ler_id = ptnl.ler_id
2621: and ( (p_per_in_ler_id is not NULL and ler.typ_cd = 'SCHEDDU') or (p_per_in_ler_id is NULL) )
2622: and trunc(sysdate) between ler.effective_start_date and ler.effective_end_date

Line 3066: <>

3062:
3063: OPEN c45 (
3064: p_person_id
3065: );
3066: <>
3067: LOOP
3068: FETCH c45 INTO l_id;
3069: EXIT WHEN c45%NOTFOUND;
3070: DELETE FROM ben_ptnl_ler_for_per

Line 3070: DELETE FROM ben_ptnl_ler_for_per

3066: <>
3067: LOOP
3068: FETCH c45 INTO l_id;
3069: EXIT WHEN c45%NOTFOUND;
3070: DELETE FROM ben_ptnl_ler_for_per
3071: WHERE CURRENT OF c45;
3072: END LOOP ben_ptnl_ler_for_per;
3073: CLOSE c45;
3074:

Line 3072: END LOOP ben_ptnl_ler_for_per;

3068: FETCH c45 INTO l_id;
3069: EXIT WHEN c45%NOTFOUND;
3070: DELETE FROM ben_ptnl_ler_for_per
3071: WHERE CURRENT OF c45;
3072: END LOOP ben_ptnl_ler_for_per;
3073: CLOSE c45;
3074:
3075: if(p_per_in_ler_id is NULL) then
3076: OPEN c46 (