APPS.BEN_PERSON_DELETE dependencies on BEN_EXT_RSLT_DTL

Line 138: FROM ben_ext_rslt_dtl

134: CURSOR c6 (
135: p_person_id NUMBER
136: ) IS
137: SELECT 1
138: FROM ben_ext_rslt_dtl
139: WHERE person_id = p_person_id;
140: CURSOR c7 (
141: p_person_id NUMBER
142: ) IS

Line 601: -- Testing for values in BEN_EXT_RSLT_DTL

597: --
598: CLOSE c3;
599:
600: --
601: -- Testing for values in BEN_EXT_RSLT_DTL
602: --
603: OPEN c6 (
604: p_person_id
605: );

Line 617: 'BEN_EXT_RSLT_DTL'

613: 'BEN_94121_DT_CHILD_EXISTS'
614: );
615: fnd_message.set_token (
616: 'TABLE_NAME',
617: 'BEN_EXT_RSLT_DTL'
618: );
619: fnd_message.raise_error;
620: END IF;
621:

Line 2535: FROM ben_ext_rslt_dtl

2531: CURSOR c36 (
2532: p_person_id NUMBER
2533: ) IS
2534: SELECT ext_rslt_dtl_id
2535: FROM ben_ext_rslt_dtl
2536: WHERE person_id = p_person_id
2537: FOR UPDATE OF ext_rslt_dtl_id;
2538:
2539: --

Line 2921: <>

2917: CLOSE c35;
2918: OPEN c36 (
2919: p_person_id
2920: );
2921: <>
2922: LOOP
2923: FETCH c36 INTO l_id;
2924: EXIT WHEN c36%NOTFOUND;
2925: DELETE FROM ben_ext_rslt_dtl

Line 2925: DELETE FROM ben_ext_rslt_dtl

2921: <>
2922: LOOP
2923: FETCH c36 INTO l_id;
2924: EXIT WHEN c36%NOTFOUND;
2925: DELETE FROM ben_ext_rslt_dtl
2926: WHERE CURRENT OF c36;
2927: END LOOP ben_ext_rslt_dtl;
2928: CLOSE c36;
2929: OPEN c37 (

Line 2927: END LOOP ben_ext_rslt_dtl;

2923: FETCH c36 INTO l_id;
2924: EXIT WHEN c36%NOTFOUND;
2925: DELETE FROM ben_ext_rslt_dtl
2926: WHERE CURRENT OF c36;
2927: END LOOP ben_ext_rslt_dtl;
2928: CLOSE c36;
2929: OPEN c37 (
2930: p_person_id
2931: );