APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 189: FROM ben_prtt_reimbmt_rqst_f

185: CURSOR c30 (
186: p_person_id NUMBER
187: ) IS
188: SELECT 1
189: FROM ben_prtt_reimbmt_rqst_f
190: WHERE submitter_person_id = p_person_id;
191: CURSOR c31 (
192: p_person_id NUMBER
193: ) IS

Line 195: FROM ben_prtt_reimbmt_rqst_f

191: CURSOR c31 (
192: p_person_id NUMBER
193: ) IS
194: SELECT 1
195: FROM ben_prtt_reimbmt_rqst_f
196: WHERE recipient_person_id = p_person_id;
197: CURSOR c32 (
198: p_person_id NUMBER
199: ) IS

Line 201: FROM ben_prtt_reimbmt_rqst_f

197: CURSOR c32 (
198: p_person_id NUMBER
199: ) IS
200: SELECT 1
201: FROM ben_prtt_reimbmt_rqst_f
202: WHERE provider_person_id = p_person_id;
203: CURSOR c33 (
204: p_person_id NUMBER
205: ) IS

Line 207: FROM ben_prtt_reimbmt_rqst_f

203: CURSOR c33 (
204: p_person_id NUMBER
205: ) IS
206: SELECT 1
207: FROM ben_prtt_reimbmt_rqst_f
208: WHERE provider_ssn_person_id = p_person_id;
209: CURSOR c34 (
210: p_person_id NUMBER
211: ) IS

Line 2212: --** CN|c1|Fetch the prtt_reimbmt_rqst_id from ben_prtt_reimbmt_rqst_f associated with a person_id.

2208: p_person_id NUMBER
2209: ) IS
2210:
2211: --** C|c1
2212: --** CN|c1|Fetch the prtt_reimbmt_rqst_id from ben_prtt_reimbmt_rqst_f associated with a person_id.
2213: CURSOR c1 IS
2214: SELECT prtt_reimbmt_rqst_id
2215: FROM ben_prtt_reimbmt_rqst_f
2216: WHERE submitter_person_id = p_person_id

Line 2215: FROM ben_prtt_reimbmt_rqst_f

2211: --** C|c1
2212: --** CN|c1|Fetch the prtt_reimbmt_rqst_id from ben_prtt_reimbmt_rqst_f associated with a person_id.
2213: CURSOR c1 IS
2214: SELECT prtt_reimbmt_rqst_id
2215: FROM ben_prtt_reimbmt_rqst_f
2216: WHERE submitter_person_id = p_person_id
2217: OR recipient_person_id = p_person_id
2218: OR provider_person_id = p_person_id
2219: OR provider_ssn_person_id = p_person_id

Line 2248: DELETE FROM ben_prtt_reimbmt_rqst_f

2244: DELETE FROM ben_prtt_reimbmt_recon
2245: WHERE CURRENT OF c2;
2246: END LOOP ben_prtt_reimbmt_recon;
2247: CLOSE c2;
2248: DELETE FROM ben_prtt_reimbmt_rqst_f
2249: WHERE CURRENT OF c1;
2250: END LOOP;
2251: END delete_reimbmt_rqst;
2252: