APPS.BEN_PERSON_DELETE dependencies on BEN_EXT_RSLT_ERR

Line 144: FROM ben_ext_rslt_err

140: CURSOR c7 (
141: p_person_id NUMBER
142: ) IS
143: SELECT 1
144: FROM ben_ext_rslt_err
145: WHERE person_id = p_person_id;
146: CURSOR c11 (
147: p_person_id NUMBER
148: ) IS

Line 626: -- Testing for values in BEN_EXT_RSLT_ERR

622: --
623: CLOSE c6;
624:
625: --
626: -- Testing for values in BEN_EXT_RSLT_ERR
627: --
628: OPEN c7 (
629: p_person_id
630: );

Line 642: 'BEN_EXT_RSLT_ERR'

638: 'BEN_94121_DT_CHILD_EXISTS'
639: );
640: fnd_message.set_token (
641: 'TABLE_NAME',
642: 'BEN_EXT_RSLT_ERR'
643: );
644: fnd_message.raise_error;
645: END IF;
646:

Line 2544: FROM ben_ext_rslt_err

2540: CURSOR c37 (
2541: p_person_id NUMBER
2542: ) IS
2543: SELECT ext_rslt_err_id
2544: FROM ben_ext_rslt_err
2545: WHERE person_id = p_person_id
2546: FOR UPDATE OF ext_rslt_err_id;
2547:
2548: --

Line 2932: <>

2928: CLOSE c36;
2929: OPEN c37 (
2930: p_person_id
2931: );
2932: <>
2933: LOOP
2934: FETCH c37 INTO l_id;
2935: EXIT WHEN c37%NOTFOUND;
2936: DELETE FROM ben_ext_rslt_err

Line 2936: DELETE FROM ben_ext_rslt_err

2932: <>
2933: LOOP
2934: FETCH c37 INTO l_id;
2935: EXIT WHEN c37%NOTFOUND;
2936: DELETE FROM ben_ext_rslt_err
2937: WHERE CURRENT OF c37;
2938: END LOOP ben_ext_rslt_err;
2939: CLOSE c37;
2940: OPEN c38 (

Line 2938: END LOOP ben_ext_rslt_err;

2934: FETCH c37 INTO l_id;
2935: EXIT WHEN c37%NOTFOUND;
2936: DELETE FROM ben_ext_rslt_err
2937: WHERE CURRENT OF c37;
2938: END LOOP ben_ext_rslt_err;
2939: CLOSE c37;
2940: OPEN c38 (
2941: p_person_id
2942: );