APPS.BEN_PERSON_DELETE dependencies on BEN_EXT_RSLT_DTL

Line 89: FROM ben_ext_rslt_dtl

85: CURSOR c6 (
86: p_person_id NUMBER
87: ) IS
88: SELECT 1
89: FROM ben_ext_rslt_dtl
90: WHERE person_id = p_person_id;
91: CURSOR c7 (
92: p_person_id NUMBER
93: ) IS

Line 552: -- Testing for values in BEN_EXT_RSLT_DTL

548: --
549: CLOSE c3;
550:
551: --
552: -- Testing for values in BEN_EXT_RSLT_DTL
553: --
554: OPEN c6 (
555: p_person_id
556: );

Line 568: 'BEN_EXT_RSLT_DTL'

564: 'BEN_94121_DT_CHILD_EXISTS'
565: );
566: fnd_message.set_token (
567: 'TABLE_NAME',
568: 'BEN_EXT_RSLT_DTL'
569: );
570: fnd_message.raise_error;
571: END IF;
572:

Line 2430: FROM ben_ext_rslt_dtl

2426: CURSOR c36 (
2427: p_person_id NUMBER
2428: ) IS
2429: SELECT ext_rslt_dtl_id
2430: FROM ben_ext_rslt_dtl
2431: WHERE person_id = p_person_id
2432: FOR UPDATE OF ext_rslt_dtl_id;
2433:
2434: --

Line 2793: <>

2789: CLOSE c35;
2790: OPEN c36 (
2791: p_person_id
2792: );
2793: <>
2794: LOOP
2795: FETCH c36 INTO l_id;
2796: EXIT WHEN c36%NOTFOUND;
2797: DELETE FROM ben_ext_rslt_dtl

Line 2797: DELETE FROM ben_ext_rslt_dtl

2793: <>
2794: LOOP
2795: FETCH c36 INTO l_id;
2796: EXIT WHEN c36%NOTFOUND;
2797: DELETE FROM ben_ext_rslt_dtl
2798: WHERE CURRENT OF c36;
2799: END LOOP ben_ext_rslt_dtl;
2800: CLOSE c36;
2801: OPEN c37 (

Line 2799: END LOOP ben_ext_rslt_dtl;

2795: FETCH c36 INTO l_id;
2796: EXIT WHEN c36%NOTFOUND;
2797: DELETE FROM ben_ext_rslt_dtl
2798: WHERE CURRENT OF c36;
2799: END LOOP ben_ext_rslt_dtl;
2800: CLOSE c36;
2801: OPEN c37 (
2802: p_person_id
2803: );