APPS.BEN_PERSON_DELETE dependencies on BEN_EXT_CRIT_VAL

Line 1222: FROM ben_ext_crit_val

1218: CURSOR c6 (
1219: p_elig_cvrd_dpnt_id NUMBER
1220: ) IS
1221: SELECT ext_crit_val_id
1222: FROM ben_ext_crit_val
1223: WHERE ext_crit_val_id IN
1224: (SELECT DISTINCT ext_crit_val_id
1225: FROM ben_ext_crit_val val,
1226: ben_ext_crit_typ typ

Line 1225: FROM ben_ext_crit_val val,

1221: SELECT ext_crit_val_id
1222: FROM ben_ext_crit_val
1223: WHERE ext_crit_val_id IN
1224: (SELECT DISTINCT ext_crit_val_id
1225: FROM ben_ext_crit_val val,
1226: ben_ext_crit_typ typ
1227: WHERE typ.crit_typ_cd = 'PID'
1228: AND val.ext_crit_typ_id =
1229: typ.ext_crit_typ_id

Line 1327: <>

1323: hr_utility.set_location(l_proc, 45);
1324: OPEN c6 (
1325: l_ecd.elig_cvrd_dpnt_id
1326: );
1327: <>
1328: LOOP
1329: FETCH c6 INTO l_id;
1330: EXIT WHEN c6%NOTFOUND;
1331: DELETE FROM ben_ext_crit_val

Line 1331: DELETE FROM ben_ext_crit_val

1327: <>
1328: LOOP
1329: FETCH c6 INTO l_id;
1330: EXIT WHEN c6%NOTFOUND;
1331: DELETE FROM ben_ext_crit_val
1332: WHERE CURRENT OF c6;
1333: END LOOP ben_ext_crit_val;
1334: CLOSE c6;
1335: hr_utility.set_location(l_proc, 50);

Line 1333: END LOOP ben_ext_crit_val;

1329: FETCH c6 INTO l_id;
1330: EXIT WHEN c6%NOTFOUND;
1331: DELETE FROM ben_ext_crit_val
1332: WHERE CURRENT OF c6;
1333: END LOOP ben_ext_crit_val;
1334: CLOSE c6;
1335: hr_utility.set_location(l_proc, 50);
1336: OPEN c7 (
1337: l_ecd.elig_cvrd_dpnt_id

Line 2639: FROM ben_ext_crit_val

2635: CURSOR c47 (
2636: p_person_id NUMBER
2637: ) IS
2638: SELECT ext_crit_val_id
2639: FROM ben_ext_crit_val
2640: WHERE ext_crit_val_id IN (SELECT DISTINCT ext_crit_val_id
2641: FROM ben_ext_crit_val val,
2642: ben_ext_crit_typ typ
2643: WHERE typ.crit_typ_cd =

Line 2641: FROM ben_ext_crit_val val,

2637: ) IS
2638: SELECT ext_crit_val_id
2639: FROM ben_ext_crit_val
2640: WHERE ext_crit_val_id IN (SELECT DISTINCT ext_crit_val_id
2641: FROM ben_ext_crit_val val,
2642: ben_ext_crit_typ typ
2643: WHERE typ.crit_typ_cd =
2644: 'PID'
2645: AND val.ext_crit_typ_id =

Line 3090: <>

3086: CLOSE c46;
3087: OPEN c47 (
3088: p_person_id
3089: );
3090: <>
3091: LOOP
3092: FETCH c47 INTO l_id;
3093: EXIT WHEN c47%NOTFOUND;
3094: DELETE FROM ben_ext_crit_val

Line 3094: DELETE FROM ben_ext_crit_val

3090: <>
3091: LOOP
3092: FETCH c47 INTO l_id;
3093: EXIT WHEN c47%NOTFOUND;
3094: DELETE FROM ben_ext_crit_val
3095: WHERE CURRENT OF c47;
3096: END LOOP ben_ext_crit_val;
3097: CLOSE c47;
3098: end if;

Line 3096: END LOOP ben_ext_crit_val;

3092: FETCH c47 INTO l_id;
3093: EXIT WHEN c47%NOTFOUND;
3094: DELETE FROM ben_ext_crit_val
3095: WHERE CURRENT OF c47;
3096: END LOOP ben_ext_crit_val;
3097: CLOSE c47;
3098: end if;
3099:
3100: OPEN c48 (