1 package body ben_org_delete as
2 /* $Header: bebgdchk.pkb 120.0 2005/05/28 00:41:10 appldev noship $ */
3 procedure perform_ri_check(p_bg_id in number) is
4
5 cursor c1(p_bg_id NUMBER)
6 is select 1 from BEN_CBR_QUALD_BNF
7 where business_group_id = p_bg_id;
8
9 --cursor c2(p_bg_id NUMBER)
10 --is select 1 from BEN_HLTH_CVG_SLCTD_RT_F
11 --where business_group_id = p_bg_id;
12
13 cursor c3(p_bg_id NUMBER)
14 is select 1 from BEN_PER_INFO_CHG_CS_LER_F
15 where business_group_id = p_bg_id;
16
17 --cursor c4(p_bg_id NUMBER)
18 --is select 1 from BEN_PRTN_IN_ANTHR_PL_RT_F
19 --where business_group_id = p_bg_id;
20
21 --cursor c5(p_bg_id NUMBER)
22 --is select 1 from BEN_PRTT_PREM_BY_MO_CR_F
23 --where business_group_id = p_bg_id;
24
25 cursor c6(p_bg_id NUMBER)
26 is select 1 from BEN_RLTD_PER_CHG_CS_LER_F
27 where business_group_id = p_bg_id;
28
29 cursor c7(p_bg_id NUMBER)
30 is select 1 from BEN_PCT_FL_TM_FCTR
31 where business_group_id = p_bg_id;
32
33 cursor c8(p_bg_id NUMBER)
34 is select 1 from BEN_AGE_FCTR
35 where business_group_id = p_bg_id;
36
37 cursor c9(p_bg_id NUMBER)
38 is select 1 from BEN_BENFTS_GRP
39 where business_group_id = p_bg_id;
40
41 cursor c10(p_bg_id NUMBER)
42 is select 1 from BEN_GD_OR_SVC_TYP
43 where business_group_id = p_bg_id;
44
45 cursor c11(p_bg_id NUMBER)
46 is select 1 from BEN_LOS_FCTR
47 where business_group_id = p_bg_id;
48
49 cursor c12(p_bg_id NUMBER)
50 is select 1 from BEN_ELIGY_PRFL_F
51 where business_group_id = p_bg_id;
52
53 cursor c13(p_bg_id NUMBER)
54 is select 1 from BEN_ELIG_LVG_RSN_PRTE_F
55 where business_group_id = p_bg_id;
56
57 cursor c14(p_bg_id NUMBER)
58 is select 1 from BEN_ELIG_NO_OTHR_CVG_PRTE_F
59 where business_group_id = p_bg_id;
60
61 cursor c15(p_bg_id NUMBER)
62 is select 1 from BEN_ELIG_OPTD_MDCR_PRTE_F
63 where business_group_id = p_bg_id;
64
65 cursor c16(p_bg_id NUMBER)
66 is select 1 from BEN_ACTN_TYP
67 where business_group_id = p_bg_id;
68
69 cursor c17(p_bg_id NUMBER)
70 is select 1 from BEN_BATCH_ACTN_ITEM_INFO
71 where business_group_id = p_bg_id;
72
73 cursor c18(p_bg_id NUMBER)
74 is select 1 from BEN_BATCH_PARAMETER
75 where business_group_id = p_bg_id;
76
77 cursor c19(p_bg_id NUMBER)
78 is select 1 from BEN_BNFTS_BAL_F
79 where business_group_id = p_bg_id;
80
81 cursor c20(p_bg_id NUMBER)
82 is select 1 from BEN_CM_TYP_F
83 where business_group_id = p_bg_id;
84
85 cursor c21(p_bg_id NUMBER)
86 is select 1 from BEN_CM_TYP_TRGR_F
87 where business_group_id = p_bg_id;
88
89 cursor c22(p_bg_id NUMBER)
90 is select 1 from BEN_CNTNG_PRTN_ELIG_PRFL_F
91 where business_group_id = p_bg_id;
92
93 cursor c23(p_bg_id NUMBER)
94 is select 1 from BEN_COMP_ASSET
95 where business_group_id = p_bg_id;
96
97 cursor c24(p_bg_id NUMBER)
98 is select 1 from BEN_CSR_ACTIVITIES
99 where business_group_id = p_bg_id;
100
101 cursor c25(p_bg_id NUMBER)
102 is select 1 from BEN_ELIG_BRGNG_UNIT_PRTE_F
103 where business_group_id = p_bg_id;
104
105 cursor c26(p_bg_id NUMBER)
106 is select 1 from BEN_ELIG_FL_TM_PT_TM_PRTE_F
107 where business_group_id = p_bg_id;
108
109 cursor c27(p_bg_id NUMBER)
110 is select 1 from BEN_ELIG_HRLY_SLRD_PRTE_F
111 where business_group_id = p_bg_id;
112
113 cursor c28(p_bg_id NUMBER)
114 is select 1 from BEN_ELIG_LBR_MMBR_PRTE_F
115 where business_group_id = p_bg_id;
116
117 cursor c29(p_bg_id NUMBER)
118 is select 1 from BEN_ELIG_PER_TYP_PRTE_F
119 where business_group_id = p_bg_id;
120
121 cursor c30(p_bg_id NUMBER)
122 is select 1 from BEN_ELIG_PYRL_PRTE_F
123 where business_group_id = p_bg_id;
124
125 cursor c31(p_bg_id NUMBER)
126 is select 1 from BEN_ELIG_SCHEDD_HRS_PRTE_F
127 where business_group_id = p_bg_id;
128
129 cursor c32(p_bg_id NUMBER)
130 is select 1 from BEN_EXT_CHG_EVT_LOG
131 where business_group_id = p_bg_id;
132
133 cursor c33(p_bg_id NUMBER)
134 is select 1 from BEN_EXT_CRIT_PRFL
135 where business_group_id = p_bg_id;
136
137 cursor c34(p_bg_id NUMBER)
138 is select 1 from BEN_EXT_FILE
139 where business_group_id = p_bg_id;
140
141 cursor c35(p_bg_id NUMBER)
142 is select 1 from BEN_EXT_FLD
143 where business_group_id = p_bg_id;
144
145 cursor c36(p_bg_id NUMBER)
146 is select 1 from BEN_EXT_RCD
147 where business_group_id = p_bg_id;
148
149 cursor c37(p_bg_id NUMBER)
150 is select 1 from BEN_PIN
151 where business_group_id = p_bg_id;
152
153 cursor c38(p_bg_id NUMBER)
154 is select 1 from BEN_PL_TYP_F
155 where business_group_id = p_bg_id;
156
157 cursor c39(p_bg_id NUMBER)
158 is select 1 from BEN_POP_UP_MESSAGES
159 where business_group_id = p_bg_id;
160
161 cursor c40(p_bg_id NUMBER)
162 is select 1 from BEN_PSTL_ZIP_RNG_F
163 where business_group_id = p_bg_id;
164
165 cursor c41(p_bg_id NUMBER)
166 is select 1 from BEN_VSTG_SCHED_F
167 where business_group_id = p_bg_id;
168
169 cursor c42(p_bg_id NUMBER)
170 is select 1 from BEN_YR_PERD
171 where business_group_id = p_bg_id;
172
173 cursor c43(p_bg_id NUMBER)
174 is select 1 from BEN_CMBN_AGE_LOS_FCTR
175 where business_group_id = p_bg_id;
176
177 cursor c44(p_bg_id NUMBER)
178 is select 1 from BEN_CM_DLVRY_MTHD_TYP
179 where business_group_id = p_bg_id;
180
181 cursor c45(p_bg_id NUMBER)
182 is select 1 from BEN_CNTNU_PRTN_CTFN_TYP_F
183 where business_group_id = p_bg_id;
184
185 cursor c46(p_bg_id NUMBER)
186 is select 1 from BEN_ELIGY_PRFL_RL_F
187 where business_group_id = p_bg_id;
188
189 cursor c47(p_bg_id NUMBER)
190 is select 1 from BEN_ELIG_AGE_PRTE_F
191 where business_group_id = p_bg_id;
192
193 cursor c48(p_bg_id NUMBER)
194 is select 1 from BEN_ELIG_BENFTS_GRP_PRTE_F
195 where business_group_id = p_bg_id;
196
197 cursor c49(p_bg_id NUMBER)
198 is select 1 from BEN_ELIG_LOS_PRTE_F
199 where business_group_id = p_bg_id;
200
201 cursor c50(p_bg_id NUMBER)
202 is select 1 from BEN_ELIG_PCT_FL_TM_PRTE_F
203 where business_group_id = p_bg_id;
204
205 cursor c51(p_bg_id NUMBER)
206 is select 1 from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
207 where business_group_id = p_bg_id;
208
209 cursor c52(p_bg_id NUMBER)
210 is select 1 from BEN_ELIG_WK_LOC_PRTE_F
211 where business_group_id = p_bg_id;
212
213 cursor c53(p_bg_id NUMBER)
214 is select 1 from BEN_EXT_CRIT_TYP
215 where business_group_id = p_bg_id;
216
217 cursor c54(p_bg_id NUMBER)
218 is select 1 from BEN_EXT_DFN
219 where business_group_id = p_bg_id;
220
221 cursor c55(p_bg_id NUMBER)
222 is select 1 from BEN_ORG_UNIT_PRDCT_F
223 where business_group_id = p_bg_id;
224
225 cursor c56(p_bg_id NUMBER)
226 is select 1 from BEN_PER_BNFTS_BAL_F
227 where business_group_id = p_bg_id;
228
229 cursor c57(p_bg_id NUMBER)
230 is select 1 from BEN_PER_PIN_F
231 where business_group_id = p_bg_id;
232
233 cursor c58(p_bg_id NUMBER)
234 is select 1 from BEN_VSTG_AGE_RQMT
235 where business_group_id = p_bg_id;
236
237 cursor c59(p_bg_id NUMBER)
238 is select 1 from BEN_VSTG_FOR_ACTY_RT_F
239 where business_group_id = p_bg_id;
240
241 cursor c60(p_bg_id NUMBER)
242 is select 1 from BEN_WTHN_YR_PERD
243 where business_group_id = p_bg_id;
244
245 cursor c61(p_bg_id NUMBER)
246 is select 1 from BEN_CM_DLVRY_MED_TYP
247 where business_group_id = p_bg_id;
248
249 cursor c62(p_bg_id NUMBER)
250 is select 1 from BEN_ELIG_SVC_AREA_PRTE_F
251 where business_group_id = p_bg_id;
252
253 cursor c63(p_bg_id NUMBER)
254 is select 1 from BEN_EXT_CRIT_VAL
255 where business_group_id = p_bg_id;
256
257 cursor c64(p_bg_id NUMBER)
258 is select 1 from BEN_EXT_DATA_ELMT
259 where business_group_id = p_bg_id;
260
261 cursor c65(p_bg_id NUMBER)
262 is select 1 from BEN_EXT_RSLT
263 where business_group_id = p_bg_id;
264
265 cursor c66(p_bg_id NUMBER)
266 is select 1 from BEN_SVC_AREA_F
267 where business_group_id = p_bg_id;
268
269 cursor c67(p_bg_id NUMBER)
270 is select 1 from BEN_VSTG_LOS_RQMT
271 where business_group_id = p_bg_id;
272
273 cursor c68(p_bg_id NUMBER)
274 is select 1 from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
275 where business_group_id = p_bg_id;
276
277 cursor c69(p_bg_id NUMBER)
278 is select 1 from BEN_EXT_CRIT_CMBN
279 where business_group_id = p_bg_id;
280
281 cursor c70(p_bg_id NUMBER)
282 is select 1 from BEN_EXT_DATA_ELMT_DECD
283 where business_group_id = p_bg_id;
284
285 cursor c71(p_bg_id NUMBER)
286 is select 1 from BEN_EXT_DATA_ELMT_IN_RCD
287 where business_group_id = p_bg_id;
288
289 cursor c72(p_bg_id NUMBER)
290 is select 1 from BEN_EXT_RSLT_DTL
291 where business_group_id = p_bg_id;
292
293 cursor c73(p_bg_id NUMBER)
294 is select 1 from BEN_SVC_AREA_PSTL_ZIP_RNG_F
295 where business_group_id = p_bg_id;
296
297 cursor c74(p_bg_id NUMBER)
298 is select 1 from BEN_COMP_LVL_FCTR
299 where business_group_id = p_bg_id;
300
301 cursor c75(p_bg_id NUMBER)
302 is select 1 from BEN_ELIG_LGL_ENTY_PRTE_F
303 where business_group_id = p_bg_id;
304
305 cursor c76(p_bg_id NUMBER)
306 is select 1 from BEN_ELIG_ORG_UNIT_PRTE_F
307 where business_group_id = p_bg_id;
308
309 cursor c77(p_bg_id NUMBER)
310 is select 1 from BEN_EXT_RSLT_ERR
311 where business_group_id = p_bg_id;
312
313 cursor c78(p_bg_id NUMBER)
314 is select 1 from BEN_REGN_F
315 where business_group_id = p_bg_id;
316
317 cursor c79(p_bg_id NUMBER)
318 is select 1 from BEN_EXT_INCL_DATA_ELMT
319 where business_group_id = p_bg_id;
320
321 cursor c80(p_bg_id NUMBER)
322 is select 1 from BEN_EXT_RCD_IN_FILE
323 where business_group_id = p_bg_id;
324
325 cursor c81(p_bg_id NUMBER)
326 is select 1 from BEN_REGN_FOR_REGY_BODY_F
327 where business_group_id = p_bg_id;
328
329 cursor c82(p_bg_id NUMBER)
330 is select 1 from BEN_EXT_INCL_CHG
331 where business_group_id = p_bg_id;
332
333 cursor c83(p_bg_id NUMBER)
334 is select 1 from BEN_EXT_WHERE_CLAUSE
335 where business_group_id = p_bg_id;
336
337 cursor c84(p_bg_id NUMBER)
338 is select 1 from BEN_RPTG_GRP
339 where business_group_id = p_bg_id;
340
341 cursor c85(p_bg_id NUMBER)
342 is select 1 from BEN_DPNT_CVG_ELIGY_PRFL_F
343 where business_group_id = p_bg_id;
344
345 cursor c86(p_bg_id NUMBER)
346 is select 1 from BEN_HRS_WKD_IN_PERD_FCTR
347 where business_group_id = p_bg_id;
348
349 cursor c87(p_bg_id NUMBER)
350 is select 1 from BEN_DPNT_CVG_RQD_RLSHP_F
351 where business_group_id = p_bg_id;
352
353 cursor c88(p_bg_id NUMBER)
354 is select 1 from BEN_DSGNTR_ENRLD_CVG_F
355 where business_group_id = p_bg_id;
356
357 cursor c89(p_bg_id NUMBER)
358 is select 1 from BEN_ELIG_COMP_LVL_PRTE_F
359 where business_group_id = p_bg_id;
360
361 cursor c90(p_bg_id NUMBER)
362 is select 1 from BEN_ELIG_DSBLD_STAT_CVG_F
363 where business_group_id = p_bg_id;
364
365 cursor c91(p_bg_id NUMBER)
366 is select 1 from BEN_ELIG_HRS_WKD_PRTE_F
367 where business_group_id = p_bg_id;
368
369 cursor c92(p_bg_id NUMBER)
370 is select 1 from BEN_ELIG_MLTRY_STAT_CVG_F
371 where business_group_id = p_bg_id;
372
373 cursor c93(p_bg_id NUMBER)
374 is select 1 from BEN_ELIG_MRTL_STAT_CVG_F
375 where business_group_id = p_bg_id;
376
377 cursor c94(p_bg_id NUMBER)
378 is select 1 from BEN_ELIG_STDNT_STAT_CVG_F
379 where business_group_id = p_bg_id;
380
381 cursor c95(p_bg_id NUMBER)
382 is select 1 from BEN_ELIG_AGE_CVG_F
383 where business_group_id = p_bg_id;
384
385 cursor c96(p_bg_id NUMBER)
386 is select 1 from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
387 where business_group_id = p_bg_id;
388
389 cursor c97(p_bg_id NUMBER)
390 is select 1 from BEN_PTD_LMT_F
391 where business_group_id = p_bg_id;
392
393 cursor c98(p_bg_id NUMBER)
394 is select 1 from BEN_PTD_BAL_TYP_F
395 where business_group_id = p_bg_id;
396
397 cursor c99(p_bg_id NUMBER)
398 is select 1 from BEN_ELIG_GRD_PRTE_F
399 where business_group_id = p_bg_id;
400
401 cursor c100(p_bg_id NUMBER)
402 is select 1 from BEN_PER_DLVRY_MTHD_F
403 where business_group_id = p_bg_id;
404
405 cursor c101(p_bg_id NUMBER)
406 is select 1 from BEN_PER_IN_LGL_ENTY_F
407 where business_group_id = p_bg_id;
408
409 cursor c102(p_bg_id NUMBER)
410 is select 1 from BEN_PER_IN_ORG_UNIT_F
411 where business_group_id = p_bg_id;
412
413 cursor c103(p_bg_id NUMBER)
414 is select 1 from BEN_PER_IN_ORG_ROLE_F
415 where business_group_id = p_bg_id;
416
417 cursor c104(p_bg_id NUMBER)
418 is select 1 from BEN_ACRS_PTIP_CVG_F
419 where business_group_id = p_bg_id;
420
421 cursor c105(p_bg_id NUMBER)
422 is select 1 from BEN_PL_TYP_OPT_TYP_F
423 where business_group_id = p_bg_id;
424
425 cursor c106(p_bg_id NUMBER)
426 is select 1 from BEN_ENRT_PERD
427 where business_group_id = p_bg_id;
428
429 cursor c107(p_bg_id NUMBER)
430 is select 1 from BEN_OPT_F
431 where business_group_id = p_bg_id;
432
433 cursor c108(p_bg_id NUMBER)
434 is select 1 from BEN_LER_F
435 where business_group_id = p_bg_id;
436
437 cursor c109(p_bg_id NUMBER)
438 is select 1 from BEN_LER_RLTD_PER_CS_LER_F
439 where business_group_id = p_bg_id;
440
441 cursor c110(p_bg_id NUMBER)
442 is select 1 from BEN_CBR_PER_IN_LER
443 where business_group_id = p_bg_id;
444
445 cursor c111(p_bg_id NUMBER)
446 is select 1 from BEN_CSS_RLTD_PER_PER_IN_LER_F
447 where business_group_id = p_bg_id;
448
449 cursor c112(p_bg_id NUMBER)
450 is select 1 from BEN_LER_PER_INFO_CS_LER_F
451 where business_group_id = p_bg_id;
452
453 cursor c113(p_bg_id NUMBER)
454 is select 1 from BEN_LE_CLSN_N_RSTR
455 where business_group_id = p_bg_id;
456
457 cursor c114(p_bg_id NUMBER)
458 is select 1 from BEN_PER_IN_LER
459 where business_group_id = p_bg_id;
460
461 cursor c115(p_bg_id NUMBER)
462 is select 1 from BEN_PTNL_LER_FOR_PER
463 where business_group_id = p_bg_id;
464
465 cursor c116(p_bg_id NUMBER)
466 is select 1 from BEN_PGM_F
467 where business_group_id = p_bg_id;
468
469 cursor c117(p_bg_id NUMBER)
470 is select 1 from BEN_ELIG_ENRLD_ANTHR_PGM_F
471 where business_group_id = p_bg_id;
472
473 cursor c118(p_bg_id NUMBER)
474 is select 1 from BEN_ELIG_PRTT_ANTHR_PGM_F
475 where business_group_id = p_bg_id;
476
477 cursor c119(p_bg_id NUMBER)
478 is select 1 from BEN_PLIP_F
479 where business_group_id = p_bg_id;
480
481 cursor c120(p_bg_id NUMBER)
482 is select 1 from BEN_PL_F
483 where business_group_id = p_bg_id;
484
485 cursor c121(p_bg_id NUMBER)
486 is select 1 from BEN_PTIP_F
487 where business_group_id = p_bg_id;
488
489 cursor c122(p_bg_id NUMBER)
490 is select 1 from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
491 where business_group_id = p_bg_id;
492
496
493 cursor c124(p_bg_id NUMBER)
494 is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
495 where business_group_id = p_bg_id;
497 cursor c125(p_bg_id NUMBER)
498 is select 1 from BEN_ELIG_ENRLD_ANTHR_PL_F
499 where business_group_id = p_bg_id;
500
501 cursor c126(p_bg_id NUMBER)
502 is select 1 from BEN_ENRT_ENRLD_ANTHR_PL_F
503 where business_group_id = p_bg_id;
504
505 cursor c127(p_bg_id NUMBER)
506 is select 1 from BEN_OIPLIP_F
507 where business_group_id = p_bg_id;
508
509 cursor c128(p_bg_id NUMBER)
510 is select 1 from BEN_OIPL_F
511 where business_group_id = p_bg_id;
512
513 cursor c129(p_bg_id NUMBER)
514 is select 1 from BEN_PGM_DPNT_CVG_CTFN_F
515 where business_group_id = p_bg_id;
516
517 cursor c130(p_bg_id NUMBER)
518 is select 1 from BEN_BNFT_PRVDR_POOL_F
519 where business_group_id = p_bg_id;
520
521 cursor c131(p_bg_id NUMBER)
522 is select 1 from BEN_CMBN_PLIP_F
523 where business_group_id = p_bg_id;
524
525 cursor c132(p_bg_id NUMBER)
526 is select 1 from BEN_CMBN_PTIP_F
527 where business_group_id = p_bg_id;
528
529 cursor c133(p_bg_id NUMBER)
530 is select 1 from BEN_CMBN_PTIP_OPT_F
531 where business_group_id = p_bg_id;
532
533 cursor c134(p_bg_id NUMBER)
534 is select 1 from BEN_CM_TYP_USG_F
535 where business_group_id = p_bg_id;
536
537 cursor c135(p_bg_id NUMBER)
538 is select 1 from BEN_DSGN_RQMT_F
539 where business_group_id = p_bg_id;
540
541 cursor c136(p_bg_id NUMBER)
542 is select 1 from BEN_ELIG_TO_PRTE_RSN_F
543 where business_group_id = p_bg_id;
544
545 cursor c137(p_bg_id NUMBER)
546 is select 1 from BEN_LER_CHG_PGM_ENRT_F
547 where business_group_id = p_bg_id;
548
549 cursor c138(p_bg_id NUMBER)
550 is select 1 from BEN_PL_BNF_CTFN_F
551 where business_group_id = p_bg_id;
552
553 cursor c139(p_bg_id NUMBER)
554 is select 1 from BEN_PL_DPNT_CVG_CTFN_F
555 where business_group_id = p_bg_id;
556
557 cursor c140(p_bg_id NUMBER)
558 is select 1 from BEN_PL_GD_OR_SVC_F
559 where business_group_id = p_bg_id;
560
561 cursor c141(p_bg_id NUMBER)
562 is select 1 from BEN_PL_REGN_F
563 where business_group_id = p_bg_id;
564
565 cursor c142(p_bg_id NUMBER)
566 is select 1 from BEN_PL_REGY_BOD_F
567 where business_group_id = p_bg_id;
568
569 cursor c143(p_bg_id NUMBER)
570 is select 1 from BEN_POPL_ACTN_TYP_F
571 where business_group_id = p_bg_id;
572
573 cursor c144(p_bg_id NUMBER)
574 is select 1 from BEN_POPL_ENRT_TYP_CYCL_F
575 where business_group_id = p_bg_id;
576
577 cursor c145(p_bg_id NUMBER)
578 is select 1 from BEN_POPL_ORG_F
579 where business_group_id = p_bg_id;
580
581 cursor c146(p_bg_id NUMBER)
582 is select 1 from BEN_WV_PRTN_RSN_PL_F
583 where business_group_id = p_bg_id;
584
585 cursor c147(p_bg_id NUMBER)
586 is select 1 from BEN_CRT_ORDR
587 where business_group_id = p_bg_id;
588
589 cursor c148(p_bg_id NUMBER)
590 is select 1 from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
591 where business_group_id = p_bg_id;
592
593 cursor c149(p_bg_id NUMBER)
594 is select 1 from BEN_ENRT_CTFN_F
595 where business_group_id = p_bg_id;
596
597 cursor c150(p_bg_id NUMBER)
598 is select 1 from BEN_LEE_RSN_F
599 where business_group_id = p_bg_id;
600
601 cursor c151(p_bg_id NUMBER)
602 is select 1 from BEN_PL_R_OIPL_ASSET_F
603 where business_group_id = p_bg_id;
604
605 cursor c152(p_bg_id NUMBER)
606 is select 1 from BEN_POPL_RPTG_GRP_F
607 where business_group_id = p_bg_id;
608
609 cursor c153(p_bg_id NUMBER)
610 is select 1 from BEN_POPL_YR_PERD
611 where business_group_id = p_bg_id;
612
613 cursor c154(p_bg_id NUMBER)
614 is select 1 from BEN_PRTN_ELIG_F
615 where business_group_id = p_bg_id;
616
617 cursor c155(p_bg_id NUMBER)
618 is select 1 from BEN_VALD_RLSHP_FOR_REIMB_F
619 where business_group_id = p_bg_id;
620
621 cursor c156(p_bg_id NUMBER)
622 is select 1 from BEN_VRBL_RT_PRFL_F
623 where business_group_id = p_bg_id;
624
625 cursor c157(p_bg_id NUMBER)
626 is select 1 from BEN_BNFT_RSTRN_CTFN_F
627 where business_group_id = p_bg_id;
628
629 cursor c158(p_bg_id NUMBER)
630 is select 1 from BEN_BRGNG_UNIT_RT_F
631 where business_group_id = p_bg_id;
632
633 cursor c159(p_bg_id NUMBER)
634 is select 1 from BEN_CMBN_AGE_LOS_RT_F
635 where business_group_id = p_bg_id;
636
637 cursor c160(p_bg_id NUMBER)
638 is select 1 from BEN_COMP_LVL_RT_F
639 where business_group_id = p_bg_id;
640
641 cursor c161(p_bg_id NUMBER)
642 is select 1 from BEN_DSGN_RQMT_RLSHP_TYP
643 where business_group_id = p_bg_id;
644
645 cursor c162(p_bg_id NUMBER)
646 is select 1 from BEN_ENRT_PERD_FOR_PL_F
647 where business_group_id = p_bg_id;
648
649 cursor c163(p_bg_id NUMBER)
650 is select 1 from BEN_LGL_ENTY_RT_F
651 where business_group_id = p_bg_id;
652
653 cursor c164(p_bg_id NUMBER)
654 is select 1 from BEN_LOS_RT_F
658 is select 1 from BEN_ORG_UNIT_RT_F
655 where business_group_id = p_bg_id;
656
657 cursor c165(p_bg_id NUMBER)
659 where business_group_id = p_bg_id;
660
661 cursor c166(p_bg_id NUMBER)
662 is select 1 from BEN_PCT_FL_TM_RT_F
663 where business_group_id = p_bg_id;
664
665 cursor c167(p_bg_id NUMBER)
666 is select 1 from BEN_PER_TYP_RT_F
667 where business_group_id = p_bg_id;
668
669 cursor c168(p_bg_id NUMBER)
670 is select 1 from BEN_PPL_GRP_RT_F
671 where business_group_id = p_bg_id;
672
673 cursor c169(p_bg_id NUMBER)
674 is select 1 from BEN_PSTL_ZIP_RT_F
675 where business_group_id = p_bg_id;
676
677 cursor c170(p_bg_id NUMBER)
678 is select 1 from BEN_PYRL_RT_F
679 where business_group_id = p_bg_id;
680
681 cursor c171(p_bg_id NUMBER)
682 is select 1 from BEN_SCHEDD_HRS_RT_F
683 where business_group_id = p_bg_id;
684
685 cursor c172(p_bg_id NUMBER)
686 is select 1 from BEN_SVC_AREA_RT_F
687 where business_group_id = p_bg_id;
688
689 cursor c173(p_bg_id NUMBER)
690 is select 1 from BEN_TBCO_USE_RT_F
691 where business_group_id = p_bg_id;
692
693 cursor c174(p_bg_id NUMBER)
694 is select 1 from BEN_TTL_CVG_VOL_RT_F
695 where business_group_id = p_bg_id;
696
697 cursor c175(p_bg_id NUMBER)
698 is select 1 from BEN_TTL_PRTT_RT_F
699 where business_group_id = p_bg_id;
700
701 cursor c176(p_bg_id NUMBER)
702 is select 1 from BEN_VRBL_MTCHG_RT_F
703 where business_group_id = p_bg_id;
704
705 cursor c177(p_bg_id NUMBER)
706 is select 1 from BEN_VRBL_RT_PRFL_RL_F
707 where business_group_id = p_bg_id;
708
709 cursor c178(p_bg_id NUMBER)
710 is select 1 from BEN_WK_LOC_RT_F
711 where business_group_id = p_bg_id;
712
713 cursor c179(p_bg_id NUMBER)
714 is select 1 from BEN_ACTL_PREM_F
715 where business_group_id = p_bg_id;
716
717 cursor c180(p_bg_id NUMBER)
718 is select 1 from BEN_CRT_ORDR_CVRD_PER
719 where business_group_id = p_bg_id;
720
721 cursor c181(p_bg_id NUMBER)
722 is select 1 from BEN_FL_TM_PT_TM_RT_F
723 where business_group_id = p_bg_id;
724
725 cursor c182(p_bg_id NUMBER)
726 is select 1 from BEN_GNDR_RT_F
727 where business_group_id = p_bg_id;
728
729 cursor c183(p_bg_id NUMBER)
730 is select 1 from BEN_GRADE_RT_F
731 where business_group_id = p_bg_id;
732
733 cursor c184(p_bg_id NUMBER)
734 is select 1 from BEN_HRLY_SLRD_RT_F
735 where business_group_id = p_bg_id;
736
737 cursor c185(p_bg_id NUMBER)
738 is select 1 from BEN_HRS_WKD_IN_PERD_RT_F
739 where business_group_id = p_bg_id;
740
741 cursor c186(p_bg_id NUMBER)
742 is select 1 from BEN_LBR_MMBR_RT_F
743 where business_group_id = p_bg_id;
744
745 cursor c187(p_bg_id NUMBER)
746 is select 1 from BEN_LER_BNFT_RSTRN_F
747 where business_group_id = p_bg_id;
748
749 cursor c188(p_bg_id NUMBER)
750 is select 1 from BEN_LER_RQRS_ENRT_CTFN_F
751 where business_group_id = p_bg_id;
752
753 cursor c189(p_bg_id NUMBER)
754 is select 1 from BEN_LER_BNFT_RSTRN_CTFN_F
755 where business_group_id = p_bg_id;
756
757 cursor c190(p_bg_id NUMBER)
758 is select 1 from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
759 where business_group_id = p_bg_id;
760
761 cursor c191(p_bg_id NUMBER)
762 is select 1 from BEN_CVG_AMT_CALC_MTHD_F
763 where business_group_id = p_bg_id;
764
765 cursor c192(p_bg_id NUMBER)
766 is select 1 from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
767 where business_group_id = p_bg_id;
768
769 cursor c193(p_bg_id NUMBER)
770 is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
771 where business_group_id = p_bg_id;
772
773 cursor c194(p_bg_id NUMBER)
774 is select 1 from BEN_ELIG_PER_F
775 where business_group_id = p_bg_id;
776
777 cursor c195(p_bg_id NUMBER)
778 is select 1 from BEN_ENRT_ENRLD_ANTHR_OIPL_F
779 where business_group_id = p_bg_id;
780
781 cursor c196(p_bg_id NUMBER)
782 is select 1 from BEN_LER_CHG_DPNT_CVG_F
783 where business_group_id = p_bg_id;
784
785 cursor c197(p_bg_id NUMBER)
786 is select 1 from BEN_LER_CHG_OIPL_ENRT_F
787 where business_group_id = p_bg_id;
788
789 cursor c198(p_bg_id NUMBER)
790 is select 1 from BEN_LER_CHG_PL_NIP_ENRT_F
791 where business_group_id = p_bg_id;
792
793 cursor c199(p_bg_id NUMBER)
794 is select 1 from BEN_PIL_ELCTBL_CHC_POPL
795 where business_group_id = p_bg_id;
796
797 cursor c200(p_bg_id NUMBER)
798 is select 1 from BEN_AGE_RT_F
799 where business_group_id = p_bg_id;
800
801 cursor c201(p_bg_id NUMBER)
802 is select 1 from BEN_ASNT_SET_RT_F
803 where business_group_id = p_bg_id;
804
805 cursor c202(p_bg_id NUMBER)
806 is select 1 from BEN_BENFTS_GRP_RT_F
807 where business_group_id = p_bg_id;
808
809 cursor c203(p_bg_id NUMBER)
810 is select 1 from BEN_PRTT_ENRT_RSLT_F
811 where business_group_id = p_bg_id;
812
813 cursor c204(p_bg_id NUMBER)
814 is select 1 from BEN_BNFT_VRBL_RT_F
815 where business_group_id = p_bg_id;
816
817 cursor c205(p_bg_id NUMBER)
821 cursor c206(p_bg_id NUMBER)
818 is select 1 from BEN_ELIG_CVRD_DPNT_F
819 where business_group_id = p_bg_id;
820
822 is select 1 from BEN_ELIG_PER_ELCTBL_CHC
823 where business_group_id = p_bg_id;
824
825 cursor c207(p_bg_id NUMBER)
826 is select 1 from BEN_ENRT_BNFT
827 where business_group_id = p_bg_id;
828
829 cursor c208(p_bg_id NUMBER)
830 is select 1 from BEN_PL_BNF_F
831 where business_group_id = p_bg_id;
832
833 cursor c209(p_bg_id NUMBER)
834 is select 1 from BEN_PL_R_OIPL_PREM_BY_MO_F
835 where business_group_id = p_bg_id;
836
837 cursor c210(p_bg_id NUMBER)
838 is select 1 from BEN_PRTT_PREM_F
839 where business_group_id = p_bg_id;
840
841 cursor c211(p_bg_id NUMBER)
842 is select 1 from BEN_ENRT_PREM
843 where business_group_id = p_bg_id;
844
845 cursor c212(p_bg_id NUMBER)
846 is select 1 from BEN_PRTN_ELIGY_RL_F
847 where business_group_id = p_bg_id;
848
849 cursor c213(p_bg_id NUMBER)
850 is select 1 from BEN_ELCTBL_CHC_CTFN
851 where business_group_id = p_bg_id;
852
853 cursor c214(p_bg_id NUMBER)
854 is select 1 from BEN_ACTL_PREM_VRBL_RT_RL_F
855 where business_group_id = p_bg_id;
856
857 cursor c215(p_bg_id NUMBER)
858 is select 1 from BEN_BNFT_VRBL_RT_RL_F
859 where business_group_id = p_bg_id;
860
861 cursor c216(p_bg_id NUMBER)
862 is select 1 from BEN_ELIG_PPL_GRP_PRTE_F
863 where business_group_id = p_bg_id;
864
865 cursor c217(p_bg_id NUMBER)
866 is select 1 from BEN_PRTN_ELIG_PRFL_F
867 where business_group_id = p_bg_id;
868
869 cursor c218(p_bg_id NUMBER)
870 is select 1 from BEN_WV_PRTN_RSN_CTFN_PL_F
871 where business_group_id = p_bg_id;
872
873 cursor c219(p_bg_id NUMBER)
874 is select 1 from BEN_ACTL_PREM_VRBL_RT_F
875 where business_group_id = p_bg_id;
876
877 cursor c220(p_bg_id NUMBER)
878 is select 1 from BEN_ELIG_PER_OPT_F
879 where business_group_id = p_bg_id;
880
881 cursor c221(p_bg_id NUMBER)
882 is select 1 from BEN_ELIG_PER_WV_PL_TYP_F
883 where business_group_id = p_bg_id;
884
885 cursor c222(p_bg_id NUMBER)
886 is select 1 from BEN_PL_GD_R_SVC_CTFN_F
887 where business_group_id = p_bg_id;
888
889 cursor c223(p_bg_id NUMBER)
890 is select 1 from BEN_PRMRY_CARE_PRVDR_F
891 where business_group_id = p_bg_id;
892
893 cursor c224(p_bg_id NUMBER)
894 is select 1 from BEN_PRTT_ENRT_ACTN_F
895 where business_group_id = p_bg_id;
896
897 cursor c225(p_bg_id NUMBER)
898 is select 1 from BEN_PRTT_ENRT_CTFN_PRVDD_F
899 where business_group_id = p_bg_id;
900
901 cursor c226(p_bg_id NUMBER)
902 is select 1 from BEN_ELIG_DPNT
903 where business_group_id = p_bg_id;
904
905 cursor c227(p_bg_id NUMBER)
906 is select 1 from BEN_LEE_RSN_RL_F
907 where business_group_id = p_bg_id;
908
909 cursor c228(p_bg_id NUMBER)
910 is select 1 from BEN_PL_REGY_PRP_F
911 where business_group_id = p_bg_id;
912
913 cursor c229(p_bg_id NUMBER)
914 is select 1 from BEN_SCHEDD_ENRT_RL_F
915 where business_group_id = p_bg_id;
916
917 cursor c230(p_bg_id NUMBER)
918 is select 1 from BEN_ELIG_OTHR_PTIP_PRTE_F
919 where business_group_id = p_bg_id;
920
921 cursor c231(p_bg_id NUMBER)
922 is select 1 from BEN_LER_CHG_PTIP_ENRT_F
923 where business_group_id = p_bg_id;
924
925 cursor c232(p_bg_id NUMBER)
926 is select 1 from BEN_LER_CHG_DPNT_CVG_CTFN_F
927 where business_group_id = p_bg_id;
928
929 cursor c233(p_bg_id NUMBER)
930 is select 1 from BEN_LER_CHG_OIPL_ENRT_RL_F
931 where business_group_id = p_bg_id;
932
933 cursor c234(p_bg_id NUMBER)
934 is select 1 from BEN_LER_CHG_PLIP_ENRT_F
935 where business_group_id = p_bg_id;
936
937 cursor c235(p_bg_id NUMBER)
938 is select 1 from BEN_LER_ENRT_CTFN_F
939 where business_group_id = p_bg_id;
940
941 cursor c236(p_bg_id NUMBER)
942 is select 1 from BEN_LER_CHG_PLIP_ENRT_RL_F
943 where business_group_id = p_bg_id;
944
945 cursor c237(p_bg_id NUMBER)
946 is select 1 from BEN_LER_CHG_PL_NIP_RL_F
947 where business_group_id = p_bg_id;
948
949 cursor c238(p_bg_id NUMBER)
950 is select 1 from BEN_PER_CM_F
951 where business_group_id = p_bg_id;
952
953 cursor c239(p_bg_id NUMBER)
954 is select 1 from BEN_PER_CM_TRGR_F
955 where business_group_id = p_bg_id;
956
957 cursor c240(p_bg_id NUMBER)
958 is select 1 from BEN_PL_BNF_CTFN_PRVDD_F
959 where business_group_id = p_bg_id;
960
961 cursor c241(p_bg_id NUMBER)
962 is select 1 from BEN_PTIP_DPNT_CVG_CTFN_F
963 where business_group_id = p_bg_id;
964
965 cursor c242(p_bg_id NUMBER)
966 is select 1 from BEN_WV_PRTN_RSN_PTIP_F
967 where business_group_id = p_bg_id;
968
969 cursor c243(p_bg_id NUMBER)
970 is select 1 from BEN_CVRD_DPNT_CTFN_PRVDD_F
971 where business_group_id = p_bg_id;
972
973 cursor c244(p_bg_id NUMBER)
974 is select 1 from BEN_PER_CM_USG_F
975 where business_group_id = p_bg_id;
976
977 cursor c245(p_bg_id NUMBER)
981 cursor c246(p_bg_id NUMBER)
978 is select 1 from BEN_POPL_ORG_ROLE_F
979 where business_group_id = p_bg_id;
980
982 is select 1 from BEN_ELIG_JOB_PRTE_F
983 where business_group_id = p_bg_id;
984
985 cursor c247(p_bg_id NUMBER)
986 is select 1 from BEN_WV_PRTN_RSN_CTFN_PTIP_F
987 where business_group_id = p_bg_id;
988
989 cursor c248(p_bg_id NUMBER)
990 is select 1 from BEN_BATCH_COMMU_INFO
991 where business_group_id = p_bg_id;
992
993 cursor c249(p_bg_id NUMBER)
994 is select 1 from BEN_BATCH_DPNT_INFO
995 where business_group_id = p_bg_id;
996
997 cursor c250(p_bg_id NUMBER)
998 is select 1 from BEN_BATCH_ELCTBL_CHC_INFO
999 where business_group_id = p_bg_id;
1000
1001 cursor c251(p_bg_id NUMBER)
1002 is select 1 from BEN_BATCH_ELIG_INFO
1003 where business_group_id = p_bg_id;
1004
1005 cursor c252(p_bg_id NUMBER)
1006 is select 1 from BEN_BATCH_LER_INFO
1007 where business_group_id = p_bg_id;
1008
1009 cursor c253(p_bg_id NUMBER)
1010 is select 1 from BEN_BATCH_RATE_INFO
1011 where business_group_id = p_bg_id;
1012
1013 cursor c254(p_bg_id NUMBER)
1014 is select 1 from BEN_BENEFIT_ACTIONS
1015 where business_group_id = p_bg_id;
1016
1017 cursor c255(p_bg_id NUMBER)
1018 is select 1 from BEN_CLPSE_LF_EVT_F
1019 where business_group_id = p_bg_id;
1020
1021 cursor c256(p_bg_id NUMBER)
1022 is select 1 from BEN_PREM_CSTG_BY_SGMT_F
1023 where business_group_id = p_bg_id;
1024
1025 cursor c257(p_bg_id NUMBER)
1026 is select 1 from BEN_BATCH_PROC_INFO
1027 where business_group_id = p_bg_id;
1028
1029 cursor c258(p_bg_id NUMBER)
1030 is select 1 from BEN_PRTT_PREM_BY_MO_F
1031 where business_group_id = p_bg_id;
1032
1033 cursor c259(p_bg_id NUMBER)
1034 is select 1 from BEN_PER_CM_PRVDD_F
1035 where business_group_id = p_bg_id;
1036
1037 cursor c260(p_bg_id NUMBER)
1038 is select 1 from BEN_PRTT_REIMBMT_RQST_F
1039 where business_group_id = p_bg_id;
1040
1041 cursor c261(p_bg_id NUMBER)
1042 is select 1 from BEN_PRTT_CLM_GD_OR_SVC_TYP
1043 where business_group_id = p_bg_id;
1044
1045 cursor c262(p_bg_id NUMBER)
1046 is select 1 from BEN_ROLL_REIMB_RQST
1047 where business_group_id = p_bg_id;
1048
1049 cursor c263(p_bg_id NUMBER)
1050 is select 1 from BEN_ELIG_EE_STAT_PRTE_F
1051 where business_group_id = p_bg_id;
1052
1053 cursor c264(p_bg_id NUMBER)
1054 is select 1 from BEN_EE_STAT_RT_F
1055 where business_group_id = p_bg_id;
1056
1057 cursor c265(p_bg_id NUMBER)
1058 is select 1 from BEN_ELIG_ASNT_SET_PRTE_F
1059 where business_group_id = p_bg_id;
1060
1061 cursor c266(p_bg_id NUMBER)
1062 is select 1 from BEN_ACTY_BASE_RT_F
1063 where business_group_id = p_bg_id;
1064
1065 cursor c267(p_bg_id NUMBER)
1066 is select 1 from BEN_ACTY_RT_PTD_LMT_F
1067 where business_group_id = p_bg_id;
1068
1069 cursor c268(p_bg_id NUMBER)
1070 is select 1 from BEN_ACTY_RT_PYMT_SCHED_F
1071 where business_group_id = p_bg_id;
1072
1073 cursor c269(p_bg_id NUMBER)
1074 is select 1 from BEN_ACTY_VRBL_RT_F
1075 where business_group_id = p_bg_id;
1076
1077 cursor c270(p_bg_id NUMBER)
1078 is select 1 from BEN_APLCN_TO_BNFT_POOL_F
1079 where business_group_id = p_bg_id;
1080
1081 cursor c271(p_bg_id NUMBER)
1082 is select 1 from BEN_BNFT_POOL_RLOVR_RQMT_F
1083 where business_group_id = p_bg_id;
1084
1085 cursor c272(p_bg_id NUMBER)
1086 is select 1 from BEN_BNFT_PRVDD_LDGR_F
1087 where business_group_id = p_bg_id;
1088
1089 cursor c273(p_bg_id NUMBER)
1090 is select 1 from BEN_COMP_LVL_ACTY_RT_F
1091 where business_group_id = p_bg_id;
1092
1093 cursor c274(p_bg_id NUMBER)
1094 is select 1 from BEN_MTCHG_RT_F
1095 where business_group_id = p_bg_id;
1096
1097 cursor c275(p_bg_id NUMBER)
1098 is select 1 from BEN_PAIRD_RT_F
1099 where business_group_id = p_bg_id;
1100
1101 cursor c276(p_bg_id NUMBER)
1102 is select 1 from BEN_PRTL_MO_RT_PRTN_VAL_F
1103 where business_group_id = p_bg_id;
1104
1105 cursor c277(p_bg_id NUMBER)
1106 is select 1 from BEN_VRBL_RT_RL_F
1107 where business_group_id = p_bg_id;
1108
1109 cursor c278(p_bg_id NUMBER)
1110 is select 1 from BEN_DED_SCHED_PY_FREQ
1111 where business_group_id = p_bg_id;
1112
1113 cursor c279(p_bg_id NUMBER)
1114 is select 1 from BEN_ACTY_RT_DED_SCHED_F
1115 where business_group_id = p_bg_id;
1116
1117 cursor c280(p_bg_id NUMBER)
1118 is select 1 from BEN_PERD_TO_PROC
1119 where business_group_id = p_bg_id;
1120
1121 cursor c281(p_bg_id NUMBER)
1122 is select 1 from BEN_PYMT_SCHED_PY_FREQ
1123 where business_group_id = p_bg_id;
1124
1125 cursor c282(p_bg_id NUMBER)
1126 is select 1 from BEN_PRTT_ASSOCD_INSTN_F
1127 where business_group_id = p_bg_id;
1128
1129 cursor c283(p_bg_id NUMBER)
1130 is select 1 from BEN_PRTT_RT_VAL
1131 where business_group_id = p_bg_id;
1132
1133 cursor c284(p_bg_id NUMBER)
1134 is select 1 from BEN_PRTT_VSTG_F
1135 where business_group_id = p_bg_id;
1136
1137 cursor c285(p_bg_id NUMBER)
1141 cursor c286(p_bg_id NUMBER)
1138 is select 1 from BEN_ENRT_RT
1139 where business_group_id = p_bg_id;
1140
1142 is select 1 from BEN_PRTT_REIMBMT_RECON
1143 where business_group_id = p_bg_id;
1144
1145 cursor c287(p_bg_id NUMBER)
1146 is select 1 from BEN_ELIG_LOA_RSN_PRTE_F
1147 where business_group_id = p_bg_id;
1148
1149 cursor c288(p_bg_id NUMBER)
1150 is select 1 from BEN_LOA_RSN_RT_F
1151 where business_group_id = p_bg_id;
1152
1153 cursor c289(p_bg_id NUMBER)
1154 is select 1 from BEN_ELIG_PY_BSS_PRTE_F
1155 where business_group_id = p_bg_id;
1156
1157 cursor c290(p_bg_id NUMBER)
1158 is select 1 from BEN_PY_BSS_RT_F
1159 where business_group_id = p_bg_id;
1160
1161 cursor c291(p_bg_id NUMBER)
1162 is select 1 from BEN_ELIG_ENRLD_ANTHR_OIPL_F
1163 where business_group_id = p_bg_id;
1164
1165 cursor c292(p_bg_id NUMBER)
1166 is select 1 from BEN_PL_PCP
1167 where business_group_id = p_bg_id;
1168
1169 cursor c293(p_bg_id NUMBER)
1170 is select 1 from BEN_PL_PCP_TYP
1171 where business_group_id = p_bg_id;
1172
1173 cursor c294(p_bg_id NUMBER)
1174 is select 1 from BEN_OPTIP_F
1175 where business_group_id = p_bg_id;
1176
1177
1178 l_temp VARCHAR2(2);
1179 BEGIN
1180 --
1181 -- Testing for values in BEN_CBR_QUALD_BNF
1182 --
1183 open c1(p_bg_id);
1184 --
1185 fetch c1 into l_temp;
1186 if c1%found then
1187 close c1;
1188 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1189 fnd_message.set_token('TABLE_NAME','BEN_CBR_QUALD_BNF');
1190 fnd_message.raise_error;
1191 end if;
1192 --
1193 close c1;
1194
1195 --
1196 -- Testing for values in BEN_HLTH_CVG_SLCTD_RT_F
1197 --
1198 --open c2(p_bg_id);
1199 --
1200 --fetch c2 into l_temp;
1201 --if c2%found then
1202 -- close c2;
1203 -- fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1204 -- fnd_message.set_token('TABLE_NAME','BEN_HLTH_CVG_SLCTD_RT_F');
1205 -- fnd_message.raise_error;
1206 --end if;
1207 --
1208 --close c2;
1209
1210 --
1211 -- Testing for values in BEN_PER_INFO_CHG_CS_LER_F
1212 --
1213 open c3(p_bg_id);
1214 --
1215 fetch c3 into l_temp;
1216 if c3%found then
1217 close c3;
1218 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1219 fnd_message.set_token('TABLE_NAME','BEN_PER_INFO_CHG_CS_LER_F');
1220 fnd_message.raise_error;
1221 end if;
1222 --
1223 close c3;
1224
1225 --
1226 -- Testing for values in BEN_PRTN_IN_ANTHR_PL_RT_F
1227 --
1228 --open c4(p_bg_id);
1229 --
1230 --fetch c4 into l_temp;
1231 --if c4%found then
1232 -- close c4;
1233 -- fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1234 -- fnd_message.set_token('TABLE_NAME','BEN_PRTN_IN_ANTHR_PL_RT_F');
1235 -- fnd_message.raise_error;
1236 --end if;
1237 --
1238 --close c4;
1239
1240 --
1241 -- Testing for values in BEN_PRTT_PREM_BY_MO_CR_F
1242 --
1243 --open c5(p_bg_id);
1244 --
1245 --fetch c5 into l_temp;
1246 --if c5%found then
1247 -- close c5;
1248 -- fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1249 -- fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_BY_MO_CR_F');
1250 -- fnd_message.raise_error;
1251 --end if;
1252 --
1253 --close c5;
1254
1255 --
1256 -- Testing for values in BEN_RLTD_PER_CHG_CS_LER_F
1257 --
1258 open c6(p_bg_id);
1259 --
1260 fetch c6 into l_temp;
1261 if c6%found then
1262 close c6;
1263 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1264 fnd_message.set_token('TABLE_NAME','BEN_RLTD_PER_CHG_CS_LER_F');
1265 fnd_message.raise_error;
1266 end if;
1267 --
1268 close c6;
1269
1270 --
1271 -- Testing for values in BEN_PCT_FL_TM_FCTR
1272 --
1273 open c7(p_bg_id);
1274 --
1275 fetch c7 into l_temp;
1276 if c7%found then
1277 close c7;
1278 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1279 fnd_message.set_token('TABLE_NAME','BEN_PCT_FL_TM_FCTR');
1280 fnd_message.raise_error;
1281 end if;
1282 --
1283 close c7;
1284
1285 --
1286 -- Testing for values in BEN_AGE_FCTR
1287 --
1288 open c8(p_bg_id);
1289 --
1290 fetch c8 into l_temp;
1291 if c8%found then
1292 close c8;
1293 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1294 fnd_message.set_token('TABLE_NAME','BEN_AGE_FCTR');
1295 fnd_message.raise_error;
1296 end if;
1297 --
1298 close c8;
1299
1300 --
1301 -- Testing for values in BEN_BENFTS_GRP
1302 --
1303 open c9(p_bg_id);
1304 --
1305 fetch c9 into l_temp;
1306 if c9%found then
1307 close c9;
1308 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1309 fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP');
1310 fnd_message.raise_error;
1311 end if;
1312 --
1313 close c9;
1314
1315 --
1316 -- Testing for values in BEN_GD_OR_SVC_TYP
1317 --
1318 open c10(p_bg_id);
1319 --
1320 fetch c10 into l_temp;
1321 if c10%found then
1325 fnd_message.raise_error;
1322 close c10;
1323 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1324 fnd_message.set_token('TABLE_NAME','BEN_GD_OR_SVC_TYP');
1326 end if;
1327 --
1328 close c10;
1329
1330 --
1331 -- Testing for values in BEN_LOS_FCTR
1332 --
1333 open c11(p_bg_id);
1334 --
1335 fetch c11 into l_temp;
1336 if c11%found then
1337 close c11;
1338 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1339 fnd_message.set_token('TABLE_NAME','BEN_LOS_FCTR');
1340 fnd_message.raise_error;
1341 end if;
1342 --
1343 close c11;
1344
1345 --
1346 -- Testing for values in BEN_ELIGY_PRFL_F
1347 --
1348 open c12(p_bg_id);
1349 --
1350 fetch c12 into l_temp;
1351 if c12%found then
1352 close c12;
1353 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1354 fnd_message.set_token('TABLE_NAME','BEN_ELIGY_PRFL_F');
1355 fnd_message.raise_error;
1356 end if;
1357 --
1358 close c12;
1359
1360 --
1361 -- Testing for values in BEN_ELIG_LVG_RSN_PRTE_F
1362 --
1363 open c13(p_bg_id);
1364 --
1365 fetch c13 into l_temp;
1366 if c13%found then
1367 close c13;
1368 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1369 fnd_message.set_token('TABLE_NAME','BEN_ELIG_LVG_RSN_PRTE_F');
1370 fnd_message.raise_error;
1371 end if;
1372 --
1373 close c13;
1374
1375 --
1376 -- Testing for values in BEN_ELIG_NO_OTHR_CVG_PRTE_F
1377 --
1378 open c14(p_bg_id);
1379 --
1380 fetch c14 into l_temp;
1381 if c14%found then
1382 close c14;
1383 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1384 fnd_message.set_token('TABLE_NAME','BEN_ELIG_NO_OTHR_CVG_PRTE_F');
1385 fnd_message.raise_error;
1386 end if;
1387 --
1388 close c14;
1389
1390 --
1391 -- Testing for values in BEN_ELIG_OPTD_MDCR_PRTE_F
1392 --
1393 open c15(p_bg_id);
1394 --
1395 fetch c15 into l_temp;
1396 if c15%found then
1397 close c15;
1398 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1399 fnd_message.set_token('TABLE_NAME','BEN_ELIG_OPTD_MDCR_PRTE_F');
1400 fnd_message.raise_error;
1401 end if;
1402 --
1403 close c15;
1404
1405 --
1406 -- Testing for values in BEN_ACTN_TYP
1407 --
1408 open c16(p_bg_id);
1409 --
1410 fetch c16 into l_temp;
1411 if c16%found then
1412 close c16;
1413 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1414 fnd_message.set_token('TABLE_NAME','BEN_ACTN_TYP');
1415 fnd_message.raise_error;
1416 end if;
1417 --
1418 close c16;
1419
1420 --
1421 -- Testing for values in BEN_BATCH_ACTN_ITEM_INFO
1422 --
1423 open c17(p_bg_id);
1424 --
1425 fetch c17 into l_temp;
1426 if c17%found then
1427 close c17;
1428 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1429 fnd_message.set_token('TABLE_NAME','BEN_BATCH_ACTN_ITEM_INFO');
1430 fnd_message.raise_error;
1431 end if;
1432 --
1433 close c17;
1434
1435 --
1436 -- Testing for values in BEN_BATCH_PARAMETER
1437 --
1438 open c18(p_bg_id);
1439 --
1440 fetch c18 into l_temp;
1441 if c18%found then
1442 close c18;
1443 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1444 fnd_message.set_token('TABLE_NAME','BEN_BATCH_PARAMETER');
1445 fnd_message.raise_error;
1446 end if;
1447 --
1448 close c18;
1449
1450 --
1451 -- Testing for values in BEN_BNFTS_BAL_F
1452 --
1453 open c19(p_bg_id);
1454 --
1455 fetch c19 into l_temp;
1456 if c19%found then
1457 close c19;
1458 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1459 fnd_message.set_token('TABLE_NAME','BEN_BNFTS_BAL_F');
1460 fnd_message.raise_error;
1461 end if;
1462 --
1463 close c19;
1464
1465 --
1466 -- Testing for values in BEN_CM_TYP_F
1467 --
1468 open c20(p_bg_id);
1469 --
1470 fetch c20 into l_temp;
1471 if c20%found then
1472 close c20;
1473 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1474 fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_F');
1475 fnd_message.raise_error;
1476 end if;
1477 --
1478 close c20;
1479
1480 --
1481 -- Testing for values in BEN_CM_TYP_TRGR_F
1482 --
1483 open c21(p_bg_id);
1484 --
1485 fetch c21 into l_temp;
1486 if c21%found then
1487 close c21;
1488 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1489 fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_TRGR_F');
1490 fnd_message.raise_error;
1491 end if;
1492 --
1493 close c21;
1494
1495 --
1496 -- Testing for values in BEN_CNTNG_PRTN_ELIG_PRFL_F
1497 --
1498 open c22(p_bg_id);
1499 --
1500 fetch c22 into l_temp;
1501 if c22%found then
1502 close c22;
1503 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1504 fnd_message.set_token('TABLE_NAME','BEN_CNTNG_PRTN_ELIG_PRFL_F');
1505 fnd_message.raise_error;
1506 end if;
1507 --
1508 close c22;
1509
1513 open c23(p_bg_id);
1510 --
1511 -- Testing for values in BEN_COMP_ASSET
1512 --
1514 --
1515 fetch c23 into l_temp;
1516 if c23%found then
1517 close c23;
1518 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1519 fnd_message.set_token('TABLE_NAME','BEN_COMP_ASSET');
1520 fnd_message.raise_error;
1521 end if;
1522 --
1523 close c23;
1524
1525 --
1526 -- Testing for values in BEN_CSR_ACTIVITIES
1527 --
1528 open c24(p_bg_id);
1529 --
1530 fetch c24 into l_temp;
1531 if c24%found then
1532 close c24;
1533 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1534 fnd_message.set_token('TABLE_NAME','BEN_CSR_ACTIVITIES');
1535 fnd_message.raise_error;
1536 end if;
1537 --
1538 close c24;
1539
1540 --
1541 -- Testing for values in BEN_ELIG_BRGNG_UNIT_PRTE_F
1542 --
1543 open c25(p_bg_id);
1544 --
1545 fetch c25 into l_temp;
1546 if c25%found then
1547 close c25;
1548 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1549 fnd_message.set_token('TABLE_NAME','BEN_ELIG_BRGNG_UNIT_PRTE_F');
1550 fnd_message.raise_error;
1551 end if;
1552 --
1553 close c25;
1554
1555 --
1556 -- Testing for values in BEN_ELIG_FL_TM_PT_TM_PRTE_F
1557 --
1558 open c26(p_bg_id);
1559 --
1560 fetch c26 into l_temp;
1561 if c26%found then
1562 close c26;
1563 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1564 fnd_message.set_token('TABLE_NAME','BEN_ELIG_FL_TM_PT_TM_PRTE_F');
1565 fnd_message.raise_error;
1566 end if;
1567 --
1568 close c26;
1569
1570 --
1571 -- Testing for values in BEN_ELIG_HRLY_SLRD_PRTE_F
1572 --
1573 open c27(p_bg_id);
1574 --
1575 fetch c27 into l_temp;
1576 if c27%found then
1577 close c27;
1578 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1579 fnd_message.set_token('TABLE_NAME','BEN_ELIG_HRLY_SLRD_PRTE_F');
1580 fnd_message.raise_error;
1581 end if;
1582 --
1583 close c27;
1584
1585 --
1586 -- Testing for values in BEN_ELIG_LBR_MMBR_PRTE_F
1587 --
1588 open c28(p_bg_id);
1589 --
1590 fetch c28 into l_temp;
1591 if c28%found then
1592 close c28;
1593 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1594 fnd_message.set_token('TABLE_NAME','BEN_ELIG_LBR_MMBR_PRTE_F');
1595 fnd_message.raise_error;
1596 end if;
1597 --
1598 close c28;
1599
1600 --
1601 -- Testing for values in BEN_ELIG_PER_TYP_PRTE_F
1602 --
1603 open c29(p_bg_id);
1604 --
1605 fetch c29 into l_temp;
1606 if c29%found then
1607 close c29;
1608 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1609 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_TYP_PRTE_F');
1610 fnd_message.raise_error;
1611 end if;
1612 --
1613 close c29;
1614
1615 --
1616 -- Testing for values in BEN_ELIG_PYRL_PRTE_F
1617 --
1618 open c30(p_bg_id);
1619 --
1620 fetch c30 into l_temp;
1621 if c30%found then
1622 close c30;
1623 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1624 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PYRL_PRTE_F');
1625 fnd_message.raise_error;
1626 end if;
1627 --
1628 close c30;
1629
1630 --
1631 -- Testing for values in BEN_ELIG_SCHEDD_HRS_PRTE_F
1632 --
1633 open c31(p_bg_id);
1634 --
1635 fetch c31 into l_temp;
1636 if c31%found then
1637 close c31;
1638 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1639 fnd_message.set_token('TABLE_NAME','BEN_ELIG_SCHEDD_HRS_PRTE_F');
1640 fnd_message.raise_error;
1641 end if;
1642 --
1643 close c31;
1644
1645 --
1646 -- Testing for values in BEN_EXT_CHG_EVT_LOG
1647 --
1648 open c32(p_bg_id);
1649 --
1650 fetch c32 into l_temp;
1651 if c32%found then
1652 close c32;
1653 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1654 fnd_message.set_token('TABLE_NAME','BEN_EXT_CHG_EVT_LOG');
1655 fnd_message.raise_error;
1656 end if;
1657 --
1658 close c32;
1659
1660 --
1661 -- Testing for values in BEN_EXT_CRIT_PRFL
1662 --
1663 open c33(p_bg_id);
1664 --
1665 fetch c33 into l_temp;
1666 if c33%found then
1667 close c33;
1668 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1669 fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_PRFL');
1670 fnd_message.raise_error;
1671 end if;
1672 --
1673 close c33;
1674
1675 --
1676 -- Testing for values in BEN_EXT_FILE
1677 --
1678 open c34(p_bg_id);
1679 --
1680 fetch c34 into l_temp;
1681 if c34%found then
1682 close c34;
1683 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1684 fnd_message.set_token('TABLE_NAME','BEN_EXT_FILE');
1685 fnd_message.raise_error;
1686 end if;
1687 --
1688 close c34;
1689
1690 --
1691 -- Testing for values in BEN_EXT_FLD
1692 --
1693 open c35(p_bg_id);
1694 --
1695 fetch c35 into l_temp;
1696 if c35%found then
1697 close c35;
1701 end if;
1698 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1699 fnd_message.set_token('TABLE_NAME','BEN_EXT_FLD');
1700 fnd_message.raise_error;
1702 --
1703 close c35;
1704
1705 --
1706 -- Testing for values in BEN_EXT_RCD
1707 --
1708 open c36(p_bg_id);
1709 --
1710 fetch c36 into l_temp;
1711 if c36%found then
1712 close c36;
1713 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1714 fnd_message.set_token('TABLE_NAME','BEN_EXT_RCD');
1715 fnd_message.raise_error;
1716 end if;
1717 --
1718 close c36;
1719
1720 --
1721 -- Testing for values in BEN_PIN
1722 --
1723 open c37(p_bg_id);
1724 --
1725 fetch c37 into l_temp;
1726 if c37%found then
1727 close c37;
1728 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1729 fnd_message.set_token('TABLE_NAME','BEN_PIN');
1730 fnd_message.raise_error;
1731 end if;
1732 --
1733 close c37;
1734
1735 --
1736 -- Testing for values in BEN_PL_TYP_F
1737 --
1738 open c38(p_bg_id);
1739 --
1740 fetch c38 into l_temp;
1741 if c38%found then
1742 close c38;
1743 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1744 fnd_message.set_token('TABLE_NAME','BEN_PL_TYP_F');
1745 fnd_message.raise_error;
1746 end if;
1747 --
1748 close c38;
1749
1750 --
1751 -- Testing for values in BEN_POP_UP_MESSAGES
1752 --
1753 open c39(p_bg_id);
1754 --
1755 fetch c39 into l_temp;
1756 if c39%found then
1757 close c39;
1758 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1759 fnd_message.set_token('TABLE_NAME','BEN_POP_UP_MESSAGES');
1760 fnd_message.raise_error;
1761 end if;
1762 --
1763 close c39;
1764
1765 --
1766 -- Testing for values in BEN_PSTL_ZIP_RNG_F
1767 --
1768 open c40(p_bg_id);
1769 --
1770 fetch c40 into l_temp;
1771 if c40%found then
1772 close c40;
1773 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1774 fnd_message.set_token('TABLE_NAME','BEN_PSTL_ZIP_RNG_F');
1775 fnd_message.raise_error;
1776 end if;
1777 --
1778 close c40;
1779
1780 --
1781 -- Testing for values in BEN_VSTG_SCHED_F
1782 --
1783 open c41(p_bg_id);
1784 --
1785 fetch c41 into l_temp;
1786 if c41%found then
1787 close c41;
1788 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1789 fnd_message.set_token('TABLE_NAME','BEN_VSTG_SCHED_F');
1790 fnd_message.raise_error;
1791 end if;
1792 --
1793 close c41;
1794
1795 --
1796 -- Testing for values in BEN_YR_PERD
1797 --
1798 open c42(p_bg_id);
1799 --
1800 fetch c42 into l_temp;
1801 if c42%found then
1802 close c42;
1803 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1804 fnd_message.set_token('TABLE_NAME','BEN_YR_PERD');
1805 fnd_message.raise_error;
1806 end if;
1807 --
1808 close c42;
1809
1810 --
1811 -- Testing for values in BEN_CMBN_AGE_LOS_FCTR
1812 --
1813 open c43(p_bg_id);
1814 --
1815 fetch c43 into l_temp;
1816 if c43%found then
1817 close c43;
1818 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1819 fnd_message.set_token('TABLE_NAME','BEN_CMBN_AGE_LOS_FCTR');
1820 fnd_message.raise_error;
1821 end if;
1822 --
1823 close c43;
1824
1825 --
1826 -- Testing for values in BEN_CM_DLVRY_MTHD_TYP
1827 --
1828 open c44(p_bg_id);
1829 --
1830 fetch c44 into l_temp;
1831 if c44%found then
1832 close c44;
1833 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1834 fnd_message.set_token('TABLE_NAME','BEN_CM_DLVRY_MTHD_TYP');
1835 fnd_message.raise_error;
1836 end if;
1837 --
1838 close c44;
1839
1840 --
1841 -- Testing for values in BEN_CNTNU_PRTN_CTFN_TYP_F
1842 --
1843 open c45(p_bg_id);
1844 --
1845 fetch c45 into l_temp;
1846 if c45%found then
1847 close c45;
1848 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1849 fnd_message.set_token('TABLE_NAME','BEN_CNTNU_PRTN_CTFN_TYP_F');
1850 fnd_message.raise_error;
1851 end if;
1852 --
1853 close c45;
1854
1855 --
1856 -- Testing for values in BEN_ELIGY_PRFL_RL_F
1857 --
1858 open c46(p_bg_id);
1859 --
1860 fetch c46 into l_temp;
1861 if c46%found then
1862 close c46;
1863 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1864 fnd_message.set_token('TABLE_NAME','BEN_ELIGY_PRFL_RL_F');
1865 fnd_message.raise_error;
1866 end if;
1867 --
1868 close c46;
1869
1870 --
1871 -- Testing for values in BEN_ELIG_AGE_PRTE_F
1872 --
1873 open c47(p_bg_id);
1874 --
1875 fetch c47 into l_temp;
1876 if c47%found then
1877 close c47;
1878 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1879 fnd_message.set_token('TABLE_NAME','BEN_ELIG_AGE_PRTE_F');
1880 fnd_message.raise_error;
1881 end if;
1882 --
1883 close c47;
1884
1885 --
1886 -- Testing for values in BEN_ELIG_BENFTS_GRP_PRTE_F
1887 --
1891 if c48%found then
1888 open c48(p_bg_id);
1889 --
1890 fetch c48 into l_temp;
1892 close c48;
1893 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1894 fnd_message.set_token('TABLE_NAME','BEN_ELIG_BENFTS_GRP_PRTE_F');
1895 fnd_message.raise_error;
1896 end if;
1897 --
1898 close c48;
1899
1900 --
1901 -- Testing for values in BEN_ELIG_LOS_PRTE_F
1902 --
1903 open c49(p_bg_id);
1904 --
1905 fetch c49 into l_temp;
1906 if c49%found then
1907 close c49;
1908 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1909 fnd_message.set_token('TABLE_NAME','BEN_ELIG_LOS_PRTE_F');
1910 fnd_message.raise_error;
1911 end if;
1912 --
1913 close c49;
1914
1915 --
1916 -- Testing for values in BEN_ELIG_PCT_FL_TM_PRTE_F
1917 --
1918 open c50(p_bg_id);
1919 --
1920 fetch c50 into l_temp;
1921 if c50%found then
1922 close c50;
1923 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1924 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PCT_FL_TM_PRTE_F');
1925 fnd_message.raise_error;
1926 end if;
1927 --
1928 close c50;
1929
1930 --
1931 -- Testing for values in BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
1932 --
1933 open c51(p_bg_id);
1934 --
1935 fetch c51 into l_temp;
1936 if c51%found then
1937 close c51;
1938 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1939 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PSTL_CD_R_RNG_PRTE_F');
1940 fnd_message.raise_error;
1941 end if;
1942 --
1943 close c51;
1944
1945 --
1946 -- Testing for values in BEN_ELIG_WK_LOC_PRTE_F
1947 --
1948 open c52(p_bg_id);
1949 --
1950 fetch c52 into l_temp;
1951 if c52%found then
1952 close c52;
1953 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1954 fnd_message.set_token('TABLE_NAME','BEN_ELIG_WK_LOC_PRTE_F');
1955 fnd_message.raise_error;
1956 end if;
1957 --
1958 close c52;
1959
1960 --
1961 -- Testing for values in BEN_EXT_CRIT_TYP
1962 --
1963 open c53(p_bg_id);
1964 --
1965 fetch c53 into l_temp;
1966 if c53%found then
1967 close c53;
1968 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1969 fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_TYP');
1970 fnd_message.raise_error;
1971 end if;
1972 --
1973 close c53;
1974
1975 --
1976 -- Testing for values in BEN_EXT_DFN
1977 --
1978 open c54(p_bg_id);
1979 --
1980 fetch c54 into l_temp;
1981 if c54%found then
1982 close c54;
1983 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1984 fnd_message.set_token('TABLE_NAME','BEN_EXT_DFN');
1985 fnd_message.raise_error;
1986 end if;
1987 --
1988 close c54;
1989
1990 --
1991 -- Testing for values in BEN_ORG_UNIT_PRDCT_F
1992 --
1993 open c55(p_bg_id);
1994 --
1995 fetch c55 into l_temp;
1996 if c55%found then
1997 close c55;
1998 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1999 fnd_message.set_token('TABLE_NAME','BEN_ORG_UNIT_PRDCT_F');
2000 fnd_message.raise_error;
2001 end if;
2002 --
2003 close c55;
2004
2005 --
2006 -- Testing for values in BEN_PER_BNFTS_BAL_F
2007 --
2008 open c56(p_bg_id);
2009 --
2010 fetch c56 into l_temp;
2011 if c56%found then
2012 close c56;
2013 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2014 fnd_message.set_token('TABLE_NAME','BEN_PER_BNFTS_BAL_F');
2015 fnd_message.raise_error;
2016 end if;
2017 --
2018 close c56;
2019
2020 --
2021 -- Testing for values in BEN_PER_PIN_F
2022 --
2023 open c57(p_bg_id);
2024 --
2025 fetch c57 into l_temp;
2026 if c57%found then
2027 close c57;
2028 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2029 fnd_message.set_token('TABLE_NAME','BEN_PER_PIN_F');
2030 fnd_message.raise_error;
2031 end if;
2032 --
2033 close c57;
2034
2035 --
2036 -- Testing for values in BEN_VSTG_AGE_RQMT
2037 --
2038 open c58(p_bg_id);
2039 --
2040 fetch c58 into l_temp;
2041 if c58%found then
2042 close c58;
2043 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2044 fnd_message.set_token('TABLE_NAME','BEN_VSTG_AGE_RQMT');
2045 fnd_message.raise_error;
2046 end if;
2047 --
2048 close c58;
2049
2050 --
2051 -- Testing for values in BEN_VSTG_FOR_ACTY_RT_F
2052 --
2053 open c59(p_bg_id);
2054 --
2055 fetch c59 into l_temp;
2056 if c59%found then
2057 close c59;
2058 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2059 fnd_message.set_token('TABLE_NAME','BEN_VSTG_FOR_ACTY_RT_F');
2060 fnd_message.raise_error;
2061 end if;
2062 --
2063 close c59;
2064
2065 --
2066 -- Testing for values in BEN_WTHN_YR_PERD
2067 --
2068 open c60(p_bg_id);
2069 --
2070 fetch c60 into l_temp;
2071 if c60%found then
2072 close c60;
2073 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2074 fnd_message.set_token('TABLE_NAME','BEN_WTHN_YR_PERD');
2078 close c60;
2075 fnd_message.raise_error;
2076 end if;
2077 --
2079
2080 --
2081 -- Testing for values in BEN_CM_DLVRY_MED_TYP
2082 --
2083 open c61(p_bg_id);
2084 --
2085 fetch c61 into l_temp;
2086 if c61%found then
2087 close c61;
2088 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2089 fnd_message.set_token('TABLE_NAME','BEN_CM_DLVRY_MED_TYP');
2090 fnd_message.raise_error;
2091 end if;
2092 --
2093 close c61;
2094
2095 --
2096 -- Testing for values in BEN_ELIG_SVC_AREA_PRTE_F
2097 --
2098 open c62(p_bg_id);
2099 --
2100 fetch c62 into l_temp;
2101 if c62%found then
2102 close c62;
2103 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2104 fnd_message.set_token('TABLE_NAME','BEN_ELIG_SVC_AREA_PRTE_F');
2105 fnd_message.raise_error;
2106 end if;
2107 --
2108 close c62;
2109
2110 --
2111 -- Testing for values in BEN_EXT_CRIT_VAL
2112 --
2113 open c63(p_bg_id);
2114 --
2115 fetch c63 into l_temp;
2116 if c63%found then
2117 close c63;
2118 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2119 fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_VAL');
2120 fnd_message.raise_error;
2121 end if;
2122 --
2123 close c63;
2124
2125 --
2126 -- Testing for values in BEN_EXT_DATA_ELMT
2127 --
2128 open c64(p_bg_id);
2129 --
2130 fetch c64 into l_temp;
2131 if c64%found then
2132 close c64;
2133 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2134 fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT');
2135 fnd_message.raise_error;
2136 end if;
2137 --
2138 close c64;
2139
2140 --
2141 -- Testing for values in BEN_EXT_RSLT
2142 --
2143 open c65(p_bg_id);
2144 --
2145 fetch c65 into l_temp;
2146 if c65%found then
2147 close c65;
2148 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2149 fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT');
2150 fnd_message.raise_error;
2151 end if;
2152 --
2153 close c65;
2154
2155 --
2156 -- Testing for values in BEN_SVC_AREA_F
2157 --
2158 open c66(p_bg_id);
2159 --
2160 fetch c66 into l_temp;
2161 if c66%found then
2162 close c66;
2163 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2164 fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_F');
2165 fnd_message.raise_error;
2166 end if;
2167 --
2168 close c66;
2169
2170 --
2171 -- Testing for values in BEN_VSTG_LOS_RQMT
2172 --
2173 open c67(p_bg_id);
2174 --
2175 fetch c67 into l_temp;
2176 if c67%found then
2177 close c67;
2178 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2179 fnd_message.set_token('TABLE_NAME','BEN_VSTG_LOS_RQMT');
2180 fnd_message.raise_error;
2181 end if;
2182 --
2183 close c67;
2184
2185 --
2186 -- Testing for values in BEN_ELIG_CMBN_AGE_LOS_PRTE_F
2187 --
2188 open c68(p_bg_id);
2189 --
2190 fetch c68 into l_temp;
2191 if c68%found then
2192 close c68;
2193 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2194 fnd_message.set_token('TABLE_NAME','BEN_ELIG_CMBN_AGE_LOS_PRTE_F');
2195 fnd_message.raise_error;
2196 end if;
2197 --
2198 close c68;
2199
2200 --
2201 -- Testing for values in BEN_EXT_CRIT_CMBN
2202 --
2203 open c69(p_bg_id);
2204 --
2205 fetch c69 into l_temp;
2206 if c69%found then
2207 close c69;
2208 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2209 fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_CMBN');
2210 fnd_message.raise_error;
2211 end if;
2212 --
2213 close c69;
2214
2215 --
2216 -- Testing for values in BEN_EXT_DATA_ELMT_DECD
2217 --
2218 open c70(p_bg_id);
2219 --
2220 fetch c70 into l_temp;
2221 if c70%found then
2222 close c70;
2223 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2224 fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_DECD');
2225 fnd_message.raise_error;
2226 end if;
2227 --
2228 close c70;
2229
2230 --
2231 -- Testing for values in BEN_EXT_DATA_ELMT_IN_RCD
2232 --
2233 open c71(p_bg_id);
2234 --
2235 fetch c71 into l_temp;
2236 if c71%found then
2237 close c71;
2238 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2239 fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_IN_RCD');
2240 fnd_message.raise_error;
2241 end if;
2242 --
2243 close c71;
2244
2245 --
2246 -- Testing for values in BEN_EXT_RSLT_DTL
2247 --
2248 open c72(p_bg_id);
2249 --
2250 fetch c72 into l_temp;
2251 if c72%found then
2252 close c72;
2253 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2254 fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT_DTL');
2255 fnd_message.raise_error;
2256 end if;
2257 --
2258 close c72;
2259
2260 --
2261 -- Testing for values in BEN_SVC_AREA_PSTL_ZIP_RNG_F
2262 --
2263 open c73(p_bg_id);
2264 --
2268 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2265 fetch c73 into l_temp;
2266 if c73%found then
2267 close c73;
2269 fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_PSTL_ZIP_RNG_F');
2270 fnd_message.raise_error;
2271 end if;
2272 --
2273 close c73;
2274
2275 --
2276 -- Testing for values in BEN_COMP_LVL_FCTR
2277 --
2278 open c74(p_bg_id);
2279 --
2280 fetch c74 into l_temp;
2281 if c74%found then
2282 close c74;
2283 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2284 fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_FCTR');
2285 fnd_message.raise_error;
2286 end if;
2287 --
2288 close c74;
2289
2290 --
2291 -- Testing for values in BEN_ELIG_LGL_ENTY_PRTE_F
2292 --
2293 open c75(p_bg_id);
2294 --
2295 fetch c75 into l_temp;
2296 if c75%found then
2297 close c75;
2298 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2299 fnd_message.set_token('TABLE_NAME','BEN_ELIG_LGL_ENTY_PRTE_F');
2300 fnd_message.raise_error;
2301 end if;
2302 --
2303 close c75;
2304
2305 --
2306 -- Testing for values in BEN_ELIG_ORG_UNIT_PRTE_F
2307 --
2308 open c76(p_bg_id);
2309 --
2310 fetch c76 into l_temp;
2311 if c76%found then
2312 close c76;
2313 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2314 fnd_message.set_token('TABLE_NAME','BEN_ELIG_ORG_UNIT_PRTE_F');
2315 fnd_message.raise_error;
2316 end if;
2317 --
2318 close c76;
2319
2320 --
2321 -- Testing for values in BEN_EXT_RSLT_ERR
2322 --
2323 open c77(p_bg_id);
2324 --
2325 fetch c77 into l_temp;
2326 if c77%found then
2327 close c77;
2328 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2329 fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT_ERR');
2330 fnd_message.raise_error;
2331 end if;
2332 --
2333 close c77;
2334
2335 --
2336 -- Testing for values in BEN_REGN_F
2337 --
2338 open c78(p_bg_id);
2339 --
2340 fetch c78 into l_temp;
2341 if c78%found then
2342 close c78;
2343 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2344 fnd_message.set_token('TABLE_NAME','BEN_REGN_F');
2345 fnd_message.raise_error;
2346 end if;
2347 --
2348 close c78;
2349
2350 --
2351 -- Testing for values in BEN_EXT_INCL_DATA_ELMT
2352 --
2353 open c79(p_bg_id);
2354 --
2355 fetch c79 into l_temp;
2356 if c79%found then
2357 close c79;
2358 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2359 fnd_message.set_token('TABLE_NAME','BEN_EXT_INCL_DATA_ELMT');
2360 fnd_message.raise_error;
2361 end if;
2362 --
2363 close c79;
2364
2365 --
2366 -- Testing for values in BEN_EXT_RCD_IN_FILE
2367 --
2368 open c80(p_bg_id);
2369 --
2370 fetch c80 into l_temp;
2371 if c80%found then
2372 close c80;
2373 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2374 fnd_message.set_token('TABLE_NAME','BEN_EXT_RCD_IN_FILE');
2375 fnd_message.raise_error;
2376 end if;
2377 --
2378 close c80;
2379
2380 --
2381 -- Testing for values in BEN_REGN_FOR_REGY_BODY_F
2382 --
2383 open c81(p_bg_id);
2384 --
2385 fetch c81 into l_temp;
2386 if c81%found then
2387 close c81;
2388 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2389 fnd_message.set_token('TABLE_NAME','BEN_REGN_FOR_REGY_BODY_F');
2390 fnd_message.raise_error;
2391 end if;
2392 --
2393 close c81;
2394
2395 --
2396 -- Testing for values in BEN_EXT_INCL_CHG
2397 --
2398 open c82(p_bg_id);
2399 --
2400 fetch c82 into l_temp;
2401 if c82%found then
2402 close c82;
2403 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2404 fnd_message.set_token('TABLE_NAME','BEN_EXT_INCL_CHG');
2405 fnd_message.raise_error;
2406 end if;
2407 --
2408 close c82;
2409
2410 --
2411 -- Testing for values in BEN_EXT_WHERE_CLAUSE
2412 --
2413 open c83(p_bg_id);
2414 --
2415 fetch c83 into l_temp;
2416 if c83%found then
2417 close c83;
2418 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2419 fnd_message.set_token('TABLE_NAME','BEN_EXT_WHERE_CLAUSE');
2420 fnd_message.raise_error;
2421 end if;
2422 --
2423 close c83;
2424
2425 --
2426 -- Testing for values in BEN_RPTG_GRP
2427 --
2428 open c84(p_bg_id);
2429 --
2430 fetch c84 into l_temp;
2431 if c84%found then
2432 close c84;
2433 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2434 fnd_message.set_token('TABLE_NAME','BEN_RPTG_GRP');
2435 fnd_message.raise_error;
2436 end if;
2437 --
2438 close c84;
2439
2440 --
2441 -- Testing for values in BEN_DPNT_CVG_ELIGY_PRFL_F
2442 --
2443 open c85(p_bg_id);
2444 --
2445 fetch c85 into l_temp;
2446 if c85%found then
2447 close c85;
2448 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2449 fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVG_ELIGY_PRFL_F');
2450 fnd_message.raise_error;
2451 end if;
2455 --
2452 --
2453 close c85;
2454
2456 -- Testing for values in BEN_HRS_WKD_IN_PERD_FCTR
2457 --
2458 open c86(p_bg_id);
2459 --
2460 fetch c86 into l_temp;
2461 if c86%found then
2462 close c86;
2463 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2464 fnd_message.set_token('TABLE_NAME','BEN_HRS_WKD_IN_PERD_FCTR');
2465 fnd_message.raise_error;
2466 end if;
2467 --
2468 close c86;
2469
2470 --
2471 -- Testing for values in BEN_DPNT_CVG_RQD_RLSHP_F
2472 --
2473 open c87(p_bg_id);
2474 --
2475 fetch c87 into l_temp;
2476 if c87%found then
2477 close c87;
2478 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2479 fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVG_RQD_RLSHP_F');
2480 fnd_message.raise_error;
2481 end if;
2482 --
2483 close c87;
2484
2485 --
2486 -- Testing for values in BEN_DSGNTR_ENRLD_CVG_F
2487 --
2488 open c88(p_bg_id);
2489 --
2490 fetch c88 into l_temp;
2491 if c88%found then
2492 close c88;
2493 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2494 fnd_message.set_token('TABLE_NAME','BEN_DSGNTR_ENRLD_CVG_F');
2495 fnd_message.raise_error;
2496 end if;
2497 --
2498 close c88;
2499
2500 --
2501 -- Testing for values in BEN_ELIG_COMP_LVL_PRTE_F
2502 --
2503 open c89(p_bg_id);
2504 --
2505 fetch c89 into l_temp;
2506 if c89%found then
2507 close c89;
2508 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2509 fnd_message.set_token('TABLE_NAME','BEN_ELIG_COMP_LVL_PRTE_F');
2510 fnd_message.raise_error;
2511 end if;
2512 --
2513 close c89;
2514
2515 --
2516 -- Testing for values in BEN_ELIG_DSBLD_STAT_CVG_F
2517 --
2518 open c90(p_bg_id);
2519 --
2520 fetch c90 into l_temp;
2521 if c90%found then
2522 close c90;
2523 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2524 fnd_message.set_token('TABLE_NAME','BEN_ELIG_DSBLD_STAT_CVG_F');
2525 fnd_message.raise_error;
2526 end if;
2527 --
2528 close c90;
2529
2530 --
2531 -- Testing for values in BEN_ELIG_HRS_WKD_PRTE_F
2532 --
2533 open c91(p_bg_id);
2534 --
2535 fetch c91 into l_temp;
2536 if c91%found then
2537 close c91;
2538 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2539 fnd_message.set_token('TABLE_NAME','BEN_ELIG_HRS_WKD_PRTE_F');
2540 fnd_message.raise_error;
2541 end if;
2542 --
2543 close c91;
2544
2545 --
2546 -- Testing for values in BEN_ELIG_MLTRY_STAT_CVG_F
2547 --
2548 open c92(p_bg_id);
2549 --
2550 fetch c92 into l_temp;
2551 if c92%found then
2552 close c92;
2553 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2554 fnd_message.set_token('TABLE_NAME','BEN_ELIG_MLTRY_STAT_CVG_F');
2555 fnd_message.raise_error;
2556 end if;
2557 --
2558 close c92;
2559
2560 --
2561 -- Testing for values in BEN_ELIG_MRTL_STAT_CVG_F
2562 --
2563 open c93(p_bg_id);
2564 --
2565 fetch c93 into l_temp;
2566 if c93%found then
2567 close c93;
2568 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2569 fnd_message.set_token('TABLE_NAME','BEN_ELIG_MRTL_STAT_CVG_F');
2570 fnd_message.raise_error;
2571 end if;
2572 --
2573 close c93;
2574
2575 --
2576 -- Testing for values in BEN_ELIG_STDNT_STAT_CVG_F
2577 --
2578 open c94(p_bg_id);
2579 --
2580 fetch c94 into l_temp;
2581 if c94%found then
2582 close c94;
2583 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2584 fnd_message.set_token('TABLE_NAME','BEN_ELIG_STDNT_STAT_CVG_F');
2585 fnd_message.raise_error;
2586 end if;
2587 --
2588 close c94;
2589
2590 --
2591 -- Testing for values in BEN_ELIG_AGE_CVG_F
2592 --
2593 open c95(p_bg_id);
2594 --
2595 fetch c95 into l_temp;
2596 if c95%found then
2597 close c95;
2598 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2599 fnd_message.set_token('TABLE_NAME','BEN_ELIG_AGE_CVG_F');
2600 fnd_message.raise_error;
2601 end if;
2602 --
2603 close c95;
2604
2605 --
2606 -- Testing for values in BEN_ELIG_PSTL_CD_R_RNG_CVG_F
2607 --
2608 open c96(p_bg_id);
2609 --
2610 fetch c96 into l_temp;
2611 if c96%found then
2612 close c96;
2613 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2614 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PSTL_CD_R_RNG_CVG_F');
2615 fnd_message.raise_error;
2616 end if;
2617 --
2618 close c96;
2619
2620 --
2621 -- Testing for values in BEN_PTD_LMT_F
2622 --
2623 open c97(p_bg_id);
2624 --
2625 fetch c97 into l_temp;
2626 if c97%found then
2627 close c97;
2628 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2629 fnd_message.set_token('TABLE_NAME','BEN_PTD_LMT_F');
2630 fnd_message.raise_error;
2631 end if;
2632 --
2633 close c97;
2634
2635 --
2636 -- Testing for values in BEN_PTD_BAL_TYP_F
2637 --
2638 open c98(p_bg_id);
2639 --
2643 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2640 fetch c98 into l_temp;
2641 if c98%found then
2642 close c98;
2644 fnd_message.set_token('TABLE_NAME','BEN_PTD_BAL_TYP_F');
2645 fnd_message.raise_error;
2646 end if;
2647 --
2648 close c98;
2649
2650 --
2651 -- Testing for values in BEN_ELIG_GRD_PRTE_F
2652 --
2653 open c99(p_bg_id);
2654 --
2655 fetch c99 into l_temp;
2656 if c99%found then
2657 close c99;
2658 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2659 fnd_message.set_token('TABLE_NAME','BEN_ELIG_GRD_PRTE_F');
2660 fnd_message.raise_error;
2661 end if;
2662 --
2663 close c99;
2664
2665 --
2666 -- Testing for values in BEN_PER_DLVRY_MTHD_F
2667 --
2668 open c100(p_bg_id);
2669 --
2670 fetch c100 into l_temp;
2671 if c100%found then
2672 close c100;
2673 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2674 fnd_message.set_token('TABLE_NAME','BEN_PER_DLVRY_MTHD_F');
2675 fnd_message.raise_error;
2676 end if;
2677 --
2678 close c100;
2679
2680 --
2681 -- Testing for values in BEN_PER_IN_LGL_ENTY_F
2682 --
2683 open c101(p_bg_id);
2684 --
2685 fetch c101 into l_temp;
2686 if c101%found then
2687 close c101;
2688 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2689 fnd_message.set_token('TABLE_NAME','BEN_PER_IN_LGL_ENTY_F');
2690 fnd_message.raise_error;
2691 end if;
2692 --
2693 close c101;
2694
2695 --
2696 -- Testing for values in BEN_PER_IN_ORG_UNIT_F
2697 --
2698 open c102(p_bg_id);
2699 --
2700 fetch c102 into l_temp;
2701 if c102%found then
2702 close c102;
2703 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2704 fnd_message.set_token('TABLE_NAME','BEN_PER_IN_ORG_UNIT_F');
2705 fnd_message.raise_error;
2706 end if;
2707 --
2708 close c102;
2709
2710 --
2711 -- Testing for values in BEN_PER_IN_ORG_ROLE_F
2712 --
2713 open c103(p_bg_id);
2714 --
2715 fetch c103 into l_temp;
2716 if c103%found then
2717 close c103;
2718 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2719 fnd_message.set_token('TABLE_NAME','BEN_PER_IN_ORG_ROLE_F');
2720 fnd_message.raise_error;
2721 end if;
2722 --
2723 close c103;
2724
2725 --
2726 -- Testing for values in BEN_ACRS_PTIP_CVG_F
2727 --
2728 open c104(p_bg_id);
2729 --
2730 fetch c104 into l_temp;
2731 if c104%found then
2732 close c104;
2733 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2734 fnd_message.set_token('TABLE_NAME','BEN_ACRS_PTIP_CVG_F');
2735 fnd_message.raise_error;
2736 end if;
2737 --
2738 close c104;
2739
2740 --
2741 -- Testing for values in BEN_PL_TYP_OPT_TYP_F
2742 --
2743 open c105(p_bg_id);
2744 --
2745 fetch c105 into l_temp;
2746 if c105%found then
2747 close c105;
2748 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2749 fnd_message.set_token('TABLE_NAME','BEN_PL_TYP_OPT_TYP_F');
2750 fnd_message.raise_error;
2751 end if;
2752 --
2753 close c105;
2754
2755 --
2756 -- Testing for values in BEN_ENRT_PERD
2757 --
2758 open c106(p_bg_id);
2759 --
2760 fetch c106 into l_temp;
2761 if c106%found then
2762 close c106;
2763 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2764 fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD');
2765 fnd_message.raise_error;
2766 end if;
2767 --
2768 close c106;
2769
2770 --
2771 -- Testing for values in BEN_OPT_F
2772 --
2773 open c107(p_bg_id);
2774 --
2775 fetch c107 into l_temp;
2776 if c107%found then
2777 close c107;
2778 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2779 fnd_message.set_token('TABLE_NAME','BEN_OPT_F');
2780 fnd_message.raise_error;
2781 end if;
2782 --
2783 close c107;
2784
2785 --
2786 -- Testing for values in BEN_LER_F
2787 --
2788 open c108(p_bg_id);
2789 --
2790 fetch c108 into l_temp;
2791 if c108%found then
2792 close c108;
2793 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2794 fnd_message.set_token('TABLE_NAME','BEN_LER_F');
2795 fnd_message.raise_error;
2796 end if;
2797 --
2798 close c108;
2799
2800 --
2801 -- Testing for values in BEN_LER_RLTD_PER_CS_LER_F
2802 --
2803 open c109(p_bg_id);
2804 --
2805 fetch c109 into l_temp;
2806 if c109%found then
2807 close c109;
2808 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2809 fnd_message.set_token('TABLE_NAME','BEN_LER_RLTD_PER_CS_LER_F');
2810 fnd_message.raise_error;
2811 end if;
2812 --
2813 close c109;
2814
2815 --
2816 -- Testing for values in BEN_CBR_PER_IN_LER
2817 --
2818 open c110(p_bg_id);
2819 --
2820 fetch c110 into l_temp;
2821 if c110%found then
2822 close c110;
2823 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2824 fnd_message.set_token('TABLE_NAME','BEN_CBR_PER_IN_LER');
2828 close c110;
2825 fnd_message.raise_error;
2826 end if;
2827 --
2829
2830 --
2831 -- Testing for values in BEN_CSS_RLTD_PER_PER_IN_LER_F
2832 --
2833 open c111(p_bg_id);
2834 --
2835 fetch c111 into l_temp;
2836 if c111%found then
2837 close c111;
2838 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2839 fnd_message.set_token('TABLE_NAME','BEN_CSS_RLTD_PER_PER_IN_LER_F');
2840 fnd_message.raise_error;
2841 end if;
2842 --
2843 close c111;
2844
2845 --
2846 -- Testing for values in BEN_LER_PER_INFO_CS_LER_F
2847 --
2848 open c112(p_bg_id);
2849 --
2850 fetch c112 into l_temp;
2851 if c112%found then
2852 close c112;
2853 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2854 fnd_message.set_token('TABLE_NAME','BEN_LER_PER_INFO_CS_LER_F');
2855 fnd_message.raise_error;
2856 end if;
2857 --
2858 close c112;
2859
2860 --
2861 -- Testing for values in BEN_LE_CLSN_N_RSTR
2862 --
2863 open c113(p_bg_id);
2864 --
2865 fetch c113 into l_temp;
2866 if c113%found then
2867 close c113;
2868 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2869 fnd_message.set_token('TABLE_NAME','BEN_LE_CLSN_N_RSTR');
2870 fnd_message.raise_error;
2871 end if;
2872 --
2873 close c113;
2874
2875 --
2876 -- Testing for values in BEN_PER_IN_LER
2877 --
2878 open c114(p_bg_id);
2879 --
2880 fetch c114 into l_temp;
2881 if c114%found then
2882 close c114;
2883 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2884 fnd_message.set_token('TABLE_NAME','BEN_PER_IN_LER');
2885 fnd_message.raise_error;
2886 end if;
2887 --
2888 close c114;
2889
2890 --
2891 -- Testing for values in BEN_PTNL_LER_FOR_PER
2892 --
2893 open c115(p_bg_id);
2894 --
2895 fetch c115 into l_temp;
2896 if c115%found then
2897 close c115;
2898 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2899 fnd_message.set_token('TABLE_NAME','BEN_PTNL_LER_FOR_PER');
2900 fnd_message.raise_error;
2901 end if;
2902 --
2903 close c115;
2904
2905 --
2906 -- Testing for values in BEN_PGM_F
2907 --
2908 open c116(p_bg_id);
2909 --
2910 fetch c116 into l_temp;
2911 if c116%found then
2912 close c116;
2913 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2914 fnd_message.set_token('TABLE_NAME','BEN_PGM_F');
2915 fnd_message.raise_error;
2916 end if;
2917 --
2918 close c116;
2919
2920 --
2921 -- Testing for values in BEN_ELIG_ENRLD_ANTHR_PGM_F
2922 --
2923 open c117(p_bg_id);
2924 --
2925 fetch c117 into l_temp;
2926 if c117%found then
2927 close c117;
2928 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2929 fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_PGM_F');
2930 fnd_message.raise_error;
2931 end if;
2932 --
2933 close c117;
2934
2935 --
2936 -- Testing for values in BEN_ELIG_PRTT_ANTHR_PGM_F
2937 --
2938 open c118(p_bg_id);
2939 --
2940 fetch c118 into l_temp;
2941 if c118%found then
2942 close c118;
2943 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2944 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PRTT_ANTHR_PGM_F');
2945 fnd_message.raise_error;
2946 end if;
2947 --
2948 close c118;
2949
2950 --
2951 -- Testing for values in BEN_PLIP_F
2952 --
2953 open c119(p_bg_id);
2954 --
2955 fetch c119 into l_temp;
2956 if c119%found then
2957 close c119;
2958 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2959 fnd_message.set_token('TABLE_NAME','BEN_PLIP_F');
2960 fnd_message.raise_error;
2961 end if;
2962 --
2963 close c119;
2964
2965 --
2966 -- Testing for values in BEN_PL_F
2967 --
2968 open c120(p_bg_id);
2969 --
2970 fetch c120 into l_temp;
2971 if c120%found then
2972 close c120;
2973 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2974 fnd_message.set_token('TABLE_NAME','BEN_PL_F');
2975 fnd_message.raise_error;
2976 end if;
2977 --
2978 close c120;
2979
2980 --
2981 -- Testing for values in BEN_PTIP_F
2982 --
2983 open c121(p_bg_id);
2984 --
2985 fetch c121 into l_temp;
2986 if c121%found then
2987 close c121;
2988 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2989 fnd_message.set_token('TABLE_NAME','BEN_PTIP_F');
2990 fnd_message.raise_error;
2991 end if;
2992 --
2993 close c121;
2994
2995 --
2996 -- Testing for values in BEN_DPNT_CVRD_ANTHR_PL_CVG_F
2997 --
2998 open c122(p_bg_id);
2999 --
3000 fetch c122 into l_temp;
3001 if c122%found then
3002 close c122;
3003 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3004 fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVRD_ANTHR_PL_CVG_F');
3005 fnd_message.raise_error;
3006 end if;
3007 --
3008 close c122;
3009
3010 --
3011 -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_PL_F
3012 --
3013 open c124(p_bg_id);
3017 close c124;
3014 --
3015 fetch c124 into l_temp;
3016 if c124%found then
3018 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3019 fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_PL_F');
3020 fnd_message.raise_error;
3021 end if;
3022 --
3023 close c124;
3024
3025 --
3026 -- Testing for values in BEN_ELIG_ENRLD_ANTHR_PL_F
3027 --
3028 open c125(p_bg_id);
3029 --
3030 fetch c125 into l_temp;
3031 if c125%found then
3032 close c125;
3033 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3034 fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_PL_F');
3035 fnd_message.raise_error;
3036 end if;
3037 --
3038 close c125;
3039
3040 --
3041 -- Testing for values in BEN_ENRT_ENRLD_ANTHR_PL_F
3042 --
3043 open c126(p_bg_id);
3044 --
3045 fetch c126 into l_temp;
3046 if c126%found then
3047 close c126;
3048 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3049 fnd_message.set_token('TABLE_NAME','BEN_ENRT_ENRLD_ANTHR_PL_F');
3050 fnd_message.raise_error;
3051 end if;
3052 --
3053 close c126;
3054
3055 --
3056 -- Testing for values in BEN_OIPLIP_F
3057 --
3058 open c127(p_bg_id);
3059 --
3060 fetch c127 into l_temp;
3061 if c127%found then
3062 close c127;
3063 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3064 fnd_message.set_token('TABLE_NAME','BEN_OIPLIP_F');
3065 fnd_message.raise_error;
3066 end if;
3067 --
3068 close c127;
3069
3070 --
3071 -- Testing for values in BEN_OIPL_F
3072 --
3073 open c128(p_bg_id);
3074 --
3075 fetch c128 into l_temp;
3076 if c128%found then
3077 close c128;
3078 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3079 fnd_message.set_token('TABLE_NAME','BEN_OIPL_F');
3080 fnd_message.raise_error;
3081 end if;
3082 --
3083 close c128;
3084
3085 --
3086 -- Testing for values in BEN_PGM_DPNT_CVG_CTFN_F
3087 --
3088 open c129(p_bg_id);
3089 --
3090 fetch c129 into l_temp;
3091 if c129%found then
3092 close c129;
3093 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3094 fnd_message.set_token('TABLE_NAME','BEN_PGM_DPNT_CVG_CTFN_F');
3095 fnd_message.raise_error;
3096 end if;
3097 --
3098 close c129;
3099
3100 --
3101 -- Testing for values in BEN_BNFT_PRVDR_POOL_F
3102 --
3103 open c130(p_bg_id);
3104 --
3105 fetch c130 into l_temp;
3106 if c130%found then
3107 close c130;
3108 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3109 fnd_message.set_token('TABLE_NAME','BEN_BNFT_PRVDR_POOL_F');
3110 fnd_message.raise_error;
3111 end if;
3112 --
3113 close c130;
3114
3115 --
3116 -- Testing for values in BEN_CMBN_PLIP_F
3117 --
3118 open c131(p_bg_id);
3119 --
3120 fetch c131 into l_temp;
3121 if c131%found then
3122 close c131;
3123 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3124 fnd_message.set_token('TABLE_NAME','BEN_CMBN_PLIP_F');
3125 fnd_message.raise_error;
3126 end if;
3127 --
3128 close c131;
3129
3130 --
3131 -- Testing for values in BEN_CMBN_PTIP_F
3132 --
3133 open c132(p_bg_id);
3134 --
3135 fetch c132 into l_temp;
3136 if c132%found then
3137 close c132;
3138 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3139 fnd_message.set_token('TABLE_NAME','BEN_CMBN_PTIP_F');
3140 fnd_message.raise_error;
3141 end if;
3142 --
3143 close c132;
3144
3145 --
3146 -- Testing for values in BEN_CMBN_PTIP_OPT_F
3147 --
3148 open c133(p_bg_id);
3149 --
3150 fetch c133 into l_temp;
3151 if c133%found then
3152 close c133;
3153 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3154 fnd_message.set_token('TABLE_NAME','BEN_CMBN_PTIP_OPT_F');
3155 fnd_message.raise_error;
3156 end if;
3157 --
3158 close c133;
3159
3160 --
3161 -- Testing for values in BEN_CM_TYP_USG_F
3162 --
3163 open c134(p_bg_id);
3164 --
3165 fetch c134 into l_temp;
3166 if c134%found then
3167 close c134;
3168 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3169 fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_USG_F');
3170 fnd_message.raise_error;
3171 end if;
3172 --
3173 close c134;
3174
3175 --
3176 -- Testing for values in BEN_DSGN_RQMT_F
3177 --
3178 open c135(p_bg_id);
3179 --
3180 fetch c135 into l_temp;
3181 if c135%found then
3182 close c135;
3183 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3184 fnd_message.set_token('TABLE_NAME','BEN_DSGN_RQMT_F');
3185 fnd_message.raise_error;
3186 end if;
3187 --
3188 close c135;
3189
3190 --
3191 -- Testing for values in BEN_ELIG_TO_PRTE_RSN_F
3192 --
3193 open c136(p_bg_id);
3194 --
3195 fetch c136 into l_temp;
3196 if c136%found then
3197 close c136;
3198 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3202 --
3199 fnd_message.set_token('TABLE_NAME','BEN_ELIG_TO_PRTE_RSN_F');
3200 fnd_message.raise_error;
3201 end if;
3203 close c136;
3204
3205 --
3206 -- Testing for values in BEN_LER_CHG_PGM_ENRT_F
3207 --
3208 open c137(p_bg_id);
3209 --
3210 fetch c137 into l_temp;
3211 if c137%found then
3212 close c137;
3213 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3214 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PGM_ENRT_F');
3215 fnd_message.raise_error;
3216 end if;
3217 --
3218 close c137;
3219
3220 --
3221 -- Testing for values in BEN_PL_BNF_CTFN_F
3222 --
3223 open c138(p_bg_id);
3224 --
3225 fetch c138 into l_temp;
3226 if c138%found then
3227 close c138;
3228 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3229 fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_CTFN_F');
3230 fnd_message.raise_error;
3231 end if;
3232 --
3233 close c138;
3234
3235 --
3236 -- Testing for values in BEN_PL_DPNT_CVG_CTFN_F
3237 --
3238 open c139(p_bg_id);
3239 --
3240 fetch c139 into l_temp;
3241 if c139%found then
3242 close c139;
3243 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3244 fnd_message.set_token('TABLE_NAME','BEN_PL_DPNT_CVG_CTFN_F');
3245 fnd_message.raise_error;
3246 end if;
3247 --
3248 close c139;
3249
3250 --
3251 -- Testing for values in BEN_PL_GD_OR_SVC_F
3252 --
3253 open c140(p_bg_id);
3254 --
3255 fetch c140 into l_temp;
3256 if c140%found then
3257 close c140;
3258 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3259 fnd_message.set_token('TABLE_NAME','BEN_PL_GD_OR_SVC_F');
3260 fnd_message.raise_error;
3261 end if;
3262 --
3263 close c140;
3264
3265 --
3266 -- Testing for values in BEN_PL_REGN_F
3267 --
3268 open c141(p_bg_id);
3269 --
3270 fetch c141 into l_temp;
3271 if c141%found then
3272 close c141;
3273 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3274 fnd_message.set_token('TABLE_NAME','BEN_PL_REGN_F');
3275 fnd_message.raise_error;
3276 end if;
3277 --
3278 close c141;
3279
3280 --
3281 -- Testing for values in BEN_PL_REGY_BOD_F
3282 --
3283 open c142(p_bg_id);
3284 --
3285 fetch c142 into l_temp;
3286 if c142%found then
3287 close c142;
3288 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3289 fnd_message.set_token('TABLE_NAME','BEN_PL_REGY_BOD_F');
3290 fnd_message.raise_error;
3291 end if;
3292 --
3293 close c142;
3294
3295 --
3296 -- Testing for values in BEN_POPL_ACTN_TYP_F
3297 --
3298 open c143(p_bg_id);
3299 --
3300 fetch c143 into l_temp;
3301 if c143%found then
3302 close c143;
3303 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3304 fnd_message.set_token('TABLE_NAME','BEN_POPL_ACTN_TYP_F');
3305 fnd_message.raise_error;
3306 end if;
3307 --
3308 close c143;
3309
3310 --
3311 -- Testing for values in BEN_POPL_ENRT_TYP_CYCL_F
3312 --
3313 open c144(p_bg_id);
3314 --
3315 fetch c144 into l_temp;
3316 if c144%found then
3317 close c144;
3318 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3319 fnd_message.set_token('TABLE_NAME','BEN_POPL_ENRT_TYP_CYCL_F');
3320 fnd_message.raise_error;
3321 end if;
3322 --
3323 close c144;
3324
3325 --
3326 -- Testing for values in BEN_POPL_ORG_F
3327 --
3328 open c145(p_bg_id);
3329 --
3330 fetch c145 into l_temp;
3331 if c145%found then
3332 close c145;
3333 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3334 fnd_message.set_token('TABLE_NAME','BEN_POPL_ORG_F');
3335 fnd_message.raise_error;
3336 end if;
3337 --
3338 close c145;
3339
3340 --
3341 -- Testing for values in BEN_WV_PRTN_RSN_PL_F
3342 --
3343 open c146(p_bg_id);
3344 --
3345 fetch c146 into l_temp;
3346 if c146%found then
3347 close c146;
3348 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3349 fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_PL_F');
3350 fnd_message.raise_error;
3351 end if;
3352 --
3353 close c146;
3354
3355 --
3356 -- Testing for values in BEN_CRT_ORDR
3357 --
3358 open c147(p_bg_id);
3359 --
3360 fetch c147 into l_temp;
3361 if c147%found then
3362 close c147;
3363 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3364 fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR');
3365 fnd_message.raise_error;
3366 end if;
3367 --
3368 close c147;
3369
3370 --
3371 -- Testing for values in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
3372 --
3373 open c148(p_bg_id);
3374 --
3375 fetch c148 into l_temp;
3376 if c148%found then
3377 close c148;
3378 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3379 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PRTT_ANTHR_PL_PRTE_F');
3380 fnd_message.raise_error;
3381 end if;
3382 --
3383 close c148;
3384
3385 --
3389 --
3386 -- Testing for values in BEN_ENRT_CTFN_F
3387 --
3388 open c149(p_bg_id);
3390 fetch c149 into l_temp;
3391 if c149%found then
3392 close c149;
3393 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3394 fnd_message.set_token('TABLE_NAME','BEN_ENRT_CTFN_F');
3395 fnd_message.raise_error;
3396 end if;
3397 --
3398 close c149;
3399
3400 --
3401 -- Testing for values in BEN_LEE_RSN_F
3402 --
3403 open c150(p_bg_id);
3404 --
3405 fetch c150 into l_temp;
3406 if c150%found then
3407 close c150;
3408 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3409 fnd_message.set_token('TABLE_NAME','BEN_LEE_RSN_F');
3410 fnd_message.raise_error;
3411 end if;
3412 --
3413 close c150;
3414
3415 --
3416 -- Testing for values in BEN_PL_R_OIPL_ASSET_F
3417 --
3418 open c151(p_bg_id);
3419 --
3420 fetch c151 into l_temp;
3421 if c151%found then
3422 close c151;
3423 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3424 fnd_message.set_token('TABLE_NAME','BEN_PL_R_OIPL_ASSET_F');
3425 fnd_message.raise_error;
3426 end if;
3427 --
3428 close c151;
3429
3430 --
3431 -- Testing for values in BEN_POPL_RPTG_GRP_F
3432 --
3433 open c152(p_bg_id);
3434 --
3435 fetch c152 into l_temp;
3436 if c152%found then
3437 close c152;
3438 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3439 fnd_message.set_token('TABLE_NAME','BEN_POPL_RPTG_GRP_F');
3440 fnd_message.raise_error;
3441 end if;
3442 --
3443 close c152;
3444
3445 --
3446 -- Testing for values in BEN_POPL_YR_PERD
3447 --
3448 open c153(p_bg_id);
3449 --
3450 fetch c153 into l_temp;
3451 if c153%found then
3452 close c153;
3453 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3454 fnd_message.set_token('TABLE_NAME','BEN_POPL_YR_PERD');
3455 fnd_message.raise_error;
3456 end if;
3457 --
3458 close c153;
3459
3460 --
3461 -- Testing for values in BEN_PRTN_ELIG_F
3462 --
3463 open c154(p_bg_id);
3464 --
3465 fetch c154 into l_temp;
3466 if c154%found then
3467 close c154;
3468 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3469 fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIG_F');
3470 fnd_message.raise_error;
3471 end if;
3472 --
3473 close c154;
3474
3475 --
3476 -- Testing for values in BEN_VALD_RLSHP_FOR_REIMB_F
3477 --
3478 open c155(p_bg_id);
3479 --
3480 fetch c155 into l_temp;
3481 if c155%found then
3482 close c155;
3483 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3484 fnd_message.set_token('TABLE_NAME','BEN_VALD_RLSHP_FOR_REIMB_F');
3485 fnd_message.raise_error;
3486 end if;
3487 --
3488 close c155;
3489
3490 --
3491 -- Testing for values in BEN_VRBL_RT_PRFL_F
3492 --
3493 open c156(p_bg_id);
3494 --
3495 fetch c156 into l_temp;
3496 if c156%found then
3497 close c156;
3498 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3499 fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_PRFL_F');
3500 fnd_message.raise_error;
3501 end if;
3502 --
3503 close c156;
3504
3505 --
3506 -- Testing for values in BEN_BNFT_RSTRN_CTFN_F
3507 --
3508 open c157(p_bg_id);
3509 --
3510 fetch c157 into l_temp;
3511 if c157%found then
3512 close c157;
3513 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3514 fnd_message.set_token('TABLE_NAME','BEN_BNFT_RSTRN_CTFN_F');
3515 fnd_message.raise_error;
3516 end if;
3517 --
3518 close c157;
3519
3520 --
3521 -- Testing for values in BEN_BRGNG_UNIT_RT_F
3522 --
3523 open c158(p_bg_id);
3524 --
3525 fetch c158 into l_temp;
3526 if c158%found then
3527 close c158;
3528 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3529 fnd_message.set_token('TABLE_NAME','BEN_BRGNG_UNIT_RT_F');
3530 fnd_message.raise_error;
3531 end if;
3532 --
3533 close c158;
3534
3535 --
3536 -- Testing for values in BEN_CMBN_AGE_LOS_RT_F
3537 --
3538 open c159(p_bg_id);
3539 --
3540 fetch c159 into l_temp;
3541 if c159%found then
3542 close c159;
3543 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3544 fnd_message.set_token('TABLE_NAME','BEN_CMBN_AGE_LOS_RT_F');
3545 fnd_message.raise_error;
3546 end if;
3547 --
3548 close c159;
3549
3550 --
3551 -- Testing for values in BEN_COMP_LVL_RT_F
3552 --
3553 open c160(p_bg_id);
3554 --
3555 fetch c160 into l_temp;
3556 if c160%found then
3557 close c160;
3558 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3559 fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_RT_F');
3560 fnd_message.raise_error;
3561 end if;
3562 --
3563 close c160;
3564
3565 --
3566 -- Testing for values in BEN_DSGN_RQMT_RLSHP_TYP
3567 --
3568 open c161(p_bg_id);
3569 --
3570 fetch c161 into l_temp;
3571 if c161%found then
3572 close c161;
3576 end if;
3573 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3574 fnd_message.set_token('TABLE_NAME','BEN_DSGN_RQMT_RLSHP_TYP');
3575 fnd_message.raise_error;
3577 --
3578 close c161;
3579
3580 --
3581 -- Testing for values in BEN_ENRT_PERD_FOR_PL_F
3582 --
3583 open c162(p_bg_id);
3584 --
3585 fetch c162 into l_temp;
3586 if c162%found then
3587 close c162;
3588 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3589 fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD_FOR_PL_F');
3590 fnd_message.raise_error;
3591 end if;
3592 --
3593 close c162;
3594
3595 --
3596 -- Testing for values in BEN_LGL_ENTY_RT_F
3597 --
3598 open c163(p_bg_id);
3599 --
3600 fetch c163 into l_temp;
3601 if c163%found then
3602 close c163;
3603 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3604 fnd_message.set_token('TABLE_NAME','BEN_LGL_ENTY_RT_F');
3605 fnd_message.raise_error;
3606 end if;
3607 --
3608 close c163;
3609
3610 --
3611 -- Testing for values in BEN_LOS_RT_F
3612 --
3613 open c164(p_bg_id);
3614 --
3615 fetch c164 into l_temp;
3616 if c164%found then
3617 close c164;
3618 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3619 fnd_message.set_token('TABLE_NAME','BEN_LOS_RT_F');
3620 fnd_message.raise_error;
3621 end if;
3622 --
3623 close c164;
3624
3625 --
3626 -- Testing for values in BEN_ORG_UNIT_RT_F
3627 --
3628 open c165(p_bg_id);
3629 --
3630 fetch c165 into l_temp;
3631 if c165%found then
3632 close c165;
3633 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3634 fnd_message.set_token('TABLE_NAME','BEN_ORG_UNIT_RT_F');
3635 fnd_message.raise_error;
3636 end if;
3637 --
3638 close c165;
3639
3640 --
3641 -- Testing for values in BEN_PCT_FL_TM_RT_F
3642 --
3643 open c166(p_bg_id);
3644 --
3645 fetch c166 into l_temp;
3646 if c166%found then
3647 close c166;
3648 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3649 fnd_message.set_token('TABLE_NAME','BEN_PCT_FL_TM_RT_F');
3650 fnd_message.raise_error;
3651 end if;
3652 --
3653 close c166;
3654
3655 --
3656 -- Testing for values in BEN_PER_TYP_RT_F
3657 --
3658 open c167(p_bg_id);
3659 --
3660 fetch c167 into l_temp;
3661 if c167%found then
3662 close c167;
3663 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3664 fnd_message.set_token('TABLE_NAME','BEN_PER_TYP_RT_F');
3665 fnd_message.raise_error;
3666 end if;
3667 --
3668 close c167;
3669
3670 --
3671 -- Testing for values in BEN_PPL_GRP_RT_F
3672 --
3673 open c168(p_bg_id);
3674 --
3675 fetch c168 into l_temp;
3676 if c168%found then
3677 close c168;
3678 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3679 fnd_message.set_token('TABLE_NAME','BEN_PPL_GRP_RT_F');
3680 fnd_message.raise_error;
3681 end if;
3682 --
3683 close c168;
3684
3685 --
3686 -- Testing for values in BEN_PSTL_ZIP_RT_F
3687 --
3688 open c169(p_bg_id);
3689 --
3690 fetch c169 into l_temp;
3691 if c169%found then
3692 close c169;
3693 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3694 fnd_message.set_token('TABLE_NAME','BEN_PSTL_ZIP_RT_F');
3695 fnd_message.raise_error;
3696 end if;
3697 --
3698 close c169;
3699
3700 --
3701 -- Testing for values in BEN_PYRL_RT_F
3702 --
3703 open c170(p_bg_id);
3704 --
3705 fetch c170 into l_temp;
3706 if c170%found then
3707 close c170;
3708 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3709 fnd_message.set_token('TABLE_NAME','BEN_PYRL_RT_F');
3710 fnd_message.raise_error;
3711 end if;
3712 --
3713 close c170;
3714
3715 --
3716 -- Testing for values in BEN_SCHEDD_HRS_RT_F
3717 --
3718 open c171(p_bg_id);
3719 --
3720 fetch c171 into l_temp;
3721 if c171%found then
3722 close c171;
3723 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3724 fnd_message.set_token('TABLE_NAME','BEN_SCHEDD_HRS_RT_F');
3725 fnd_message.raise_error;
3726 end if;
3727 --
3728 close c171;
3729
3730 --
3731 -- Testing for values in BEN_SVC_AREA_RT_F
3732 --
3733 open c172(p_bg_id);
3734 --
3735 fetch c172 into l_temp;
3736 if c172%found then
3737 close c172;
3738 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3739 fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_RT_F');
3740 fnd_message.raise_error;
3741 end if;
3742 --
3743 close c172;
3744
3745 --
3746 -- Testing for values in BEN_TBCO_USE_RT_F
3747 --
3748 open c173(p_bg_id);
3749 --
3750 fetch c173 into l_temp;
3751 if c173%found then
3752 close c173;
3753 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3754 fnd_message.set_token('TABLE_NAME','BEN_TBCO_USE_RT_F');
3755 fnd_message.raise_error;
3756 end if;
3757 --
3758 close c173;
3759
3760 --
3764 --
3761 -- Testing for values in BEN_TTL_CVG_VOL_RT_F
3762 --
3763 open c174(p_bg_id);
3765 fetch c174 into l_temp;
3766 if c174%found then
3767 close c174;
3768 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3769 fnd_message.set_token('TABLE_NAME','BEN_TTL_CVG_VOL_RT_F');
3770 fnd_message.raise_error;
3771 end if;
3772 --
3773 close c174;
3774
3775 --
3776 -- Testing for values in BEN_TTL_PRTT_RT_F
3777 --
3778 open c175(p_bg_id);
3779 --
3780 fetch c175 into l_temp;
3781 if c175%found then
3782 close c175;
3783 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3784 fnd_message.set_token('TABLE_NAME','BEN_TTL_PRTT_RT_F');
3785 fnd_message.raise_error;
3786 end if;
3787 --
3788 close c175;
3789
3790 --
3791 -- Testing for values in BEN_VRBL_MTCHG_RT_F
3792 --
3793 open c176(p_bg_id);
3794 --
3795 fetch c176 into l_temp;
3796 if c176%found then
3797 close c176;
3798 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3799 fnd_message.set_token('TABLE_NAME','BEN_VRBL_MTCHG_RT_F');
3800 fnd_message.raise_error;
3801 end if;
3802 --
3803 close c176;
3804
3805 --
3806 -- Testing for values in BEN_VRBL_RT_PRFL_RL_F
3807 --
3808 open c177(p_bg_id);
3809 --
3810 fetch c177 into l_temp;
3811 if c177%found then
3812 close c177;
3813 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3814 fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_PRFL_RL_F');
3815 fnd_message.raise_error;
3816 end if;
3817 --
3818 close c177;
3819
3820 --
3821 -- Testing for values in BEN_WK_LOC_RT_F
3822 --
3823 open c178(p_bg_id);
3824 --
3825 fetch c178 into l_temp;
3826 if c178%found then
3827 close c178;
3828 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3829 fnd_message.set_token('TABLE_NAME','BEN_WK_LOC_RT_F');
3830 fnd_message.raise_error;
3831 end if;
3832 --
3833 close c178;
3834
3835 --
3836 -- Testing for values in BEN_ACTL_PREM_F
3837 --
3838 open c179(p_bg_id);
3839 --
3840 fetch c179 into l_temp;
3841 if c179%found then
3842 close c179;
3843 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3844 fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_F');
3845 fnd_message.raise_error;
3846 end if;
3847 --
3848 close c179;
3849
3850 --
3851 -- Testing for values in BEN_CRT_ORDR_CVRD_PER
3852 --
3853 open c180(p_bg_id);
3854 --
3855 fetch c180 into l_temp;
3856 if c180%found then
3857 close c180;
3858 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3859 fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR_CVRD_PER');
3860 fnd_message.raise_error;
3861 end if;
3862 --
3863 close c180;
3864
3865 --
3866 -- Testing for values in BEN_FL_TM_PT_TM_RT_F
3867 --
3868 open c181(p_bg_id);
3869 --
3870 fetch c181 into l_temp;
3871 if c181%found then
3872 close c181;
3873 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3874 fnd_message.set_token('TABLE_NAME','BEN_FL_TM_PT_TM_RT_F');
3875 fnd_message.raise_error;
3876 end if;
3877 --
3878 close c181;
3879
3880 --
3881 -- Testing for values in BEN_GNDR_RT_F
3882 --
3883 open c182(p_bg_id);
3884 --
3885 fetch c182 into l_temp;
3886 if c182%found then
3887 close c182;
3888 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3889 fnd_message.set_token('TABLE_NAME','BEN_GNDR_RT_F');
3890 fnd_message.raise_error;
3891 end if;
3892 --
3893 close c182;
3894
3895 --
3896 -- Testing for values in BEN_GRADE_RT_F
3897 --
3898 open c183(p_bg_id);
3899 --
3900 fetch c183 into l_temp;
3901 if c183%found then
3902 close c183;
3903 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3904 fnd_message.set_token('TABLE_NAME','BEN_GRADE_RT_F');
3905 fnd_message.raise_error;
3906 end if;
3907 --
3908 close c183;
3909
3910 --
3911 -- Testing for values in BEN_HRLY_SLRD_RT_F
3912 --
3913 open c184(p_bg_id);
3914 --
3915 fetch c184 into l_temp;
3916 if c184%found then
3917 close c184;
3918 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3919 fnd_message.set_token('TABLE_NAME','BEN_HRLY_SLRD_RT_F');
3920 fnd_message.raise_error;
3921 end if;
3922 --
3923 close c184;
3924
3925 --
3926 -- Testing for values in BEN_HRS_WKD_IN_PERD_RT_F
3927 --
3928 open c185(p_bg_id);
3929 --
3930 fetch c185 into l_temp;
3931 if c185%found then
3932 close c185;
3933 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3934 fnd_message.set_token('TABLE_NAME','BEN_HRS_WKD_IN_PERD_RT_F');
3935 fnd_message.raise_error;
3936 end if;
3937 --
3938 close c185;
3939
3940 --
3941 -- Testing for values in BEN_LBR_MMBR_RT_F
3942 --
3943 open c186(p_bg_id);
3944 --
3945 fetch c186 into l_temp;
3946 if c186%found then
3947 close c186;
3951 end if;
3948 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3949 fnd_message.set_token('TABLE_NAME','BEN_LBR_MMBR_RT_F');
3950 fnd_message.raise_error;
3952 --
3953 close c186;
3954
3955 --
3956 -- Testing for values in BEN_LER_BNFT_RSTRN_F
3957 --
3958 open c187(p_bg_id);
3959 --
3960 fetch c187 into l_temp;
3961 if c187%found then
3962 close c187;
3963 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3964 fnd_message.set_token('TABLE_NAME','BEN_LER_BNFT_RSTRN_F');
3965 fnd_message.raise_error;
3966 end if;
3967 --
3968 close c187;
3969
3970 --
3971 -- Testing for values in BEN_LER_RQRS_ENRT_CTFN_F
3972 --
3973 open c188(p_bg_id);
3974 --
3975 fetch c188 into l_temp;
3976 if c188%found then
3977 close c188;
3978 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3979 fnd_message.set_token('TABLE_NAME','BEN_LER_RQRS_ENRT_CTFN_F');
3980 fnd_message.raise_error;
3981 end if;
3982 --
3983 close c188;
3984
3985 --
3986 -- Testing for values in BEN_LER_BNFT_RSTRN_CTFN_F
3987 --
3988 open c189(p_bg_id);
3989 --
3990 fetch c189 into l_temp;
3991 if c189%found then
3992 close c189;
3993 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3994 fnd_message.set_token('TABLE_NAME','BEN_LER_BNFT_RSTRN_CTFN_F');
3995 fnd_message.raise_error;
3996 end if;
3997 --
3998 close c189;
3999
4000 --
4001 -- Testing for values in BEN_APLD_DPNT_CVG_ELIG_PRFL_F
4002 --
4003 open c190(p_bg_id);
4004 --
4005 fetch c190 into l_temp;
4006 if c190%found then
4007 close c190;
4008 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4009 fnd_message.set_token('TABLE_NAME','BEN_APLD_DPNT_CVG_ELIG_PRFL_F');
4010 fnd_message.raise_error;
4011 end if;
4012 --
4013 close c190;
4014
4015 --
4016 -- Testing for values in BEN_CVG_AMT_CALC_MTHD_F
4017 --
4018 open c191(p_bg_id);
4019 --
4020 fetch c191 into l_temp;
4021 if c191%found then
4022 close c191;
4023 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4024 fnd_message.set_token('TABLE_NAME','BEN_CVG_AMT_CALC_MTHD_F');
4025 fnd_message.raise_error;
4026 end if;
4027 --
4028 close c191;
4029
4030 --
4031 -- Testing for values in BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
4032 --
4033 open c192(p_bg_id);
4034 --
4035 fetch c192 into l_temp;
4036 if c192%found then
4037 close c192;
4038 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4039 fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F');
4040 fnd_message.raise_error;
4041 end if;
4042 --
4043 close c192;
4044
4045 --
4046 -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
4047 --
4048 open c193(p_bg_id);
4049 --
4050 fetch c193 into l_temp;
4051 if c193%found then
4052 close c193;
4053 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4054 fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F');
4055 fnd_message.raise_error;
4056 end if;
4057 --
4058 close c193;
4059
4060 --
4061 -- Testing for values in BEN_ELIG_PER_F
4062 --
4063 open c194(p_bg_id);
4064 --
4065 fetch c194 into l_temp;
4066 if c194%found then
4067 close c194;
4068 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4069 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_F');
4070 fnd_message.raise_error;
4071 end if;
4072 --
4073 close c194;
4074
4075 --
4076 -- Testing for values in BEN_ENRT_ENRLD_ANTHR_OIPL_F
4077 --
4078 open c195(p_bg_id);
4079 --
4080 fetch c195 into l_temp;
4081 if c195%found then
4082 close c195;
4083 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4084 fnd_message.set_token('TABLE_NAME','BEN_ENRT_ENRLD_ANTHR_OIPL_F');
4085 fnd_message.raise_error;
4086 end if;
4087 --
4088 close c195;
4089
4090 --
4091 -- Testing for values in BEN_LER_CHG_DPNT_CVG_F
4092 --
4093 open c196(p_bg_id);
4094 --
4095 fetch c196 into l_temp;
4096 if c196%found then
4097 close c196;
4098 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4099 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_DPNT_CVG_F');
4100 fnd_message.raise_error;
4101 end if;
4102 --
4103 close c196;
4104
4105 --
4106 -- Testing for values in BEN_LER_CHG_OIPL_ENRT_F
4107 --
4108 open c197(p_bg_id);
4109 --
4110 fetch c197 into l_temp;
4111 if c197%found then
4112 close c197;
4113 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4114 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_OIPL_ENRT_F');
4115 fnd_message.raise_error;
4116 end if;
4117 --
4118 close c197;
4119
4120 --
4121 -- Testing for values in BEN_LER_CHG_PL_NIP_ENRT_F
4122 --
4123 open c198(p_bg_id);
4124 --
4125 fetch c198 into l_temp;
4126 if c198%found then
4127 close c198;
4128 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4132 --
4129 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PL_NIP_ENRT_F');
4130 fnd_message.raise_error;
4131 end if;
4133 close c198;
4134
4135 --
4136 -- Testing for values in BEN_PIL_ELCTBL_CHC_POPL
4137 --
4138 open c199(p_bg_id);
4139 --
4140 fetch c199 into l_temp;
4141 if c199%found then
4142 close c199;
4143 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4144 fnd_message.set_token('TABLE_NAME','BEN_PIL_ELCTBL_CHC_POPL');
4145 fnd_message.raise_error;
4146 end if;
4147 --
4148 close c199;
4149
4150 --
4151 -- Testing for values in BEN_AGE_RT_F
4152 --
4153 open c200(p_bg_id);
4154 --
4155 fetch c200 into l_temp;
4156 if c200%found then
4157 close c200;
4158 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4159 fnd_message.set_token('TABLE_NAME','BEN_AGE_RT_F');
4160 fnd_message.raise_error;
4161 end if;
4162 --
4163 close c200;
4164
4165 --
4166 -- Testing for values in BEN_ASNT_SET_RT_F
4167 --
4168 open c201(p_bg_id);
4169 --
4170 fetch c201 into l_temp;
4171 if c201%found then
4172 close c201;
4173 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4174 fnd_message.set_token('TABLE_NAME','BEN_ASNT_SET_RT_F');
4175 fnd_message.raise_error;
4176 end if;
4177 --
4178 close c201;
4179
4180 --
4181 -- Testing for values in BEN_BENFTS_GRP_RT_F
4182 --
4183 open c202(p_bg_id);
4184 --
4185 fetch c202 into l_temp;
4186 if c202%found then
4187 close c202;
4188 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4189 fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP_RT_F');
4190 fnd_message.raise_error;
4191 end if;
4192 --
4193 close c202;
4194
4195 --
4196 -- Testing for values in BEN_PRTT_ENRT_RSLT_F
4197 --
4198 open c203(p_bg_id);
4199 --
4200 fetch c203 into l_temp;
4201 if c203%found then
4202 close c203;
4203 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4204 fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_RSLT_F');
4205 fnd_message.raise_error;
4206 end if;
4207 --
4208 close c203;
4209
4210 --
4211 -- Testing for values in BEN_BNFT_VRBL_RT_F
4212 --
4213 open c204(p_bg_id);
4214 --
4215 fetch c204 into l_temp;
4216 if c204%found then
4217 close c204;
4218 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4219 fnd_message.set_token('TABLE_NAME','BEN_BNFT_VRBL_RT_F');
4220 fnd_message.raise_error;
4221 end if;
4222 --
4223 close c204;
4224
4225 --
4226 -- Testing for values in BEN_ELIG_CVRD_DPNT_F
4227 --
4228 open c205(p_bg_id);
4229 --
4230 fetch c205 into l_temp;
4231 if c205%found then
4232 close c205;
4233 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4234 fnd_message.set_token('TABLE_NAME','BEN_ELIG_CVRD_DPNT_F');
4235 fnd_message.raise_error;
4236 end if;
4237 --
4238 close c205;
4239
4240 --
4241 -- Testing for values in BEN_ELIG_PER_ELCTBL_CHC
4242 --
4243 open c206(p_bg_id);
4244 --
4245 fetch c206 into l_temp;
4246 if c206%found then
4247 close c206;
4248 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4249 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_ELCTBL_CHC');
4250 fnd_message.raise_error;
4251 end if;
4252 --
4253 close c206;
4254
4255 --
4256 -- Testing for values in BEN_ENRT_BNFT
4257 --
4258 open c207(p_bg_id);
4259 --
4260 fetch c207 into l_temp;
4261 if c207%found then
4262 close c207;
4263 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4264 fnd_message.set_token('TABLE_NAME','BEN_ENRT_BNFT');
4265 fnd_message.raise_error;
4266 end if;
4267 --
4268 close c207;
4269
4270 --
4271 -- Testing for values in BEN_PL_BNF_F
4272 --
4273 open c208(p_bg_id);
4274 --
4275 fetch c208 into l_temp;
4276 if c208%found then
4277 close c208;
4278 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4279 fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_F');
4280 fnd_message.raise_error;
4281 end if;
4282 --
4283 close c208;
4284
4285 --
4286 -- Testing for values in BEN_PL_R_OIPL_PREM_BY_MO_F
4287 --
4288 open c209(p_bg_id);
4289 --
4290 fetch c209 into l_temp;
4291 if c209%found then
4292 close c209;
4293 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4294 fnd_message.set_token('TABLE_NAME','BEN_PL_R_OIPL_PREM_BY_MO_F');
4295 fnd_message.raise_error;
4296 end if;
4297 --
4298 close c209;
4299
4300 --
4301 -- Testing for values in BEN_PRTT_PREM_F
4302 --
4303 open c210(p_bg_id);
4304 --
4305 fetch c210 into l_temp;
4306 if c210%found then
4307 close c210;
4308 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4309 fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_F');
4310 fnd_message.raise_error;
4311 end if;
4312 --
4313 close c210;
4314
4315 --
4319 --
4316 -- Testing for values in BEN_ENRT_PREM
4317 --
4318 open c211(p_bg_id);
4320 fetch c211 into l_temp;
4321 if c211%found then
4322 close c211;
4323 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4324 fnd_message.set_token('TABLE_NAME','BEN_ENRT_PREM');
4325 fnd_message.raise_error;
4326 end if;
4327 --
4328 close c211;
4329
4330 --
4331 -- Testing for values in BEN_PRTN_ELIGY_RL_F
4332 --
4333 open c212(p_bg_id);
4334 --
4335 fetch c212 into l_temp;
4336 if c212%found then
4337 close c212;
4338 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4339 fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIGY_RL_F');
4340 fnd_message.raise_error;
4341 end if;
4342 --
4343 close c212;
4344
4345 --
4346 -- Testing for values in BEN_ELCTBL_CHC_CTFN
4347 --
4348 open c213(p_bg_id);
4349 --
4350 fetch c213 into l_temp;
4351 if c213%found then
4352 close c213;
4353 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4354 fnd_message.set_token('TABLE_NAME','BEN_ELCTBL_CHC_CTFN');
4355 fnd_message.raise_error;
4356 end if;
4357 --
4358 close c213;
4359
4360 --
4361 -- Testing for values in BEN_ACTL_PREM_VRBL_RT_RL_F
4362 --
4363 open c214(p_bg_id);
4364 --
4365 fetch c214 into l_temp;
4366 if c214%found then
4367 close c214;
4368 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4369 fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_VRBL_RT_RL_F');
4370 fnd_message.raise_error;
4371 end if;
4372 --
4373 close c214;
4374
4375 --
4376 -- Testing for values in BEN_BNFT_VRBL_RT_RL_F
4377 --
4378 open c215(p_bg_id);
4379 --
4380 fetch c215 into l_temp;
4381 if c215%found then
4382 close c215;
4383 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4384 fnd_message.set_token('TABLE_NAME','BEN_BNFT_VRBL_RT_RL_F');
4385 fnd_message.raise_error;
4386 end if;
4387 --
4388 close c215;
4389
4390 --
4391 -- Testing for values in BEN_ELIG_PPL_GRP_PRTE_F
4392 --
4393 open c216(p_bg_id);
4394 --
4395 fetch c216 into l_temp;
4396 if c216%found then
4397 close c216;
4398 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4399 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PPL_GRP_PRTE_F');
4400 fnd_message.raise_error;
4401 end if;
4402 --
4403 close c216;
4404
4405 --
4406 -- Testing for values in BEN_PRTN_ELIG_PRFL_F
4407 --
4408 open c217(p_bg_id);
4409 --
4410 fetch c217 into l_temp;
4411 if c217%found then
4412 close c217;
4413 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4414 fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIG_PRFL_F');
4415 fnd_message.raise_error;
4416 end if;
4417 --
4418 close c217;
4419
4420 --
4421 -- Testing for values in BEN_WV_PRTN_RSN_CTFN_PL_F
4422 --
4423 open c218(p_bg_id);
4424 --
4425 fetch c218 into l_temp;
4426 if c218%found then
4427 close c218;
4428 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4429 fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_CTFN_PL_F');
4430 fnd_message.raise_error;
4431 end if;
4432 --
4433 close c218;
4434
4435 --
4436 -- Testing for values in BEN_ACTL_PREM_VRBL_RT_F
4437 --
4438 open c219(p_bg_id);
4439 --
4440 fetch c219 into l_temp;
4441 if c219%found then
4442 close c219;
4443 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4444 fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_VRBL_RT_F');
4445 fnd_message.raise_error;
4446 end if;
4447 --
4448 close c219;
4449
4450 --
4451 -- Testing for values in BEN_ELIG_PER_OPT_F
4452 --
4453 open c220(p_bg_id);
4454 --
4455 fetch c220 into l_temp;
4456 if c220%found then
4457 close c220;
4458 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4459 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_OPT_F');
4460 fnd_message.raise_error;
4461 end if;
4462 --
4463 close c220;
4464
4465 --
4466 -- Testing for values in BEN_ELIG_PER_WV_PL_TYP_F
4467 --
4468 open c221(p_bg_id);
4469 --
4470 fetch c221 into l_temp;
4471 if c221%found then
4472 close c221;
4473 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4474 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_WV_PL_TYP_F');
4475 fnd_message.raise_error;
4476 end if;
4477 --
4478 close c221;
4479
4480 --
4481 -- Testing for values in BEN_PL_GD_R_SVC_CTFN_F
4482 --
4483 open c222(p_bg_id);
4484 --
4485 fetch c222 into l_temp;
4486 if c222%found then
4487 close c222;
4488 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4489 fnd_message.set_token('TABLE_NAME','BEN_PL_GD_R_SVC_CTFN_F');
4490 fnd_message.raise_error;
4491 end if;
4492 --
4493 close c222;
4494
4495 --
4496 -- Testing for values in BEN_PRMRY_CARE_PRVDR_F
4497 --
4498 open c223(p_bg_id);
4499 --
4500 fetch c223 into l_temp;
4504 fnd_message.set_token('TABLE_NAME','BEN_PRMRY_CARE_PRVDR_F');
4501 if c223%found then
4502 close c223;
4503 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4505 fnd_message.raise_error;
4506 end if;
4507 --
4508 close c223;
4509
4510 --
4511 -- Testing for values in BEN_PRTT_ENRT_ACTN_F
4512 --
4513 open c224(p_bg_id);
4514 --
4515 fetch c224 into l_temp;
4516 if c224%found then
4517 close c224;
4518 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4519 fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_ACTN_F');
4520 fnd_message.raise_error;
4521 end if;
4522 --
4523 close c224;
4524
4525 --
4526 -- Testing for values in BEN_PRTT_ENRT_CTFN_PRVDD_F
4527 --
4528 open c225(p_bg_id);
4529 --
4530 fetch c225 into l_temp;
4531 if c225%found then
4532 close c225;
4533 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4534 fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_CTFN_PRVDD_F');
4535 fnd_message.raise_error;
4536 end if;
4537 --
4538 close c225;
4539
4540 --
4541 -- Testing for values in BEN_ELIG_DPNT
4542 --
4543 open c226(p_bg_id);
4544 --
4545 fetch c226 into l_temp;
4546 if c226%found then
4547 close c226;
4548 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4549 fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT');
4550 fnd_message.raise_error;
4551 end if;
4552 --
4553 close c226;
4554
4555 --
4556 -- Testing for values in BEN_LEE_RSN_RL_F
4557 --
4558 open c227(p_bg_id);
4559 --
4560 fetch c227 into l_temp;
4561 if c227%found then
4562 close c227;
4563 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4564 fnd_message.set_token('TABLE_NAME','BEN_LEE_RSN_RL_F');
4565 fnd_message.raise_error;
4566 end if;
4567 --
4568 close c227;
4569
4570 --
4571 -- Testing for values in BEN_PL_REGY_PRP_F
4572 --
4573 open c228(p_bg_id);
4574 --
4575 fetch c228 into l_temp;
4576 if c228%found then
4577 close c228;
4578 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4579 fnd_message.set_token('TABLE_NAME','BEN_PL_REGY_PRP_F');
4580 fnd_message.raise_error;
4581 end if;
4582 --
4583 close c228;
4584
4585 --
4586 -- Testing for values in BEN_SCHEDD_ENRT_RL_F
4587 --
4588 open c229(p_bg_id);
4589 --
4590 fetch c229 into l_temp;
4591 if c229%found then
4592 close c229;
4593 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4594 fnd_message.set_token('TABLE_NAME','BEN_SCHEDD_ENRT_RL_F');
4595 fnd_message.raise_error;
4596 end if;
4597 --
4598 close c229;
4599
4600 --
4601 -- Testing for values in BEN_ELIG_OTHR_PTIP_PRTE_F
4602 --
4603 open c230(p_bg_id);
4604 --
4605 fetch c230 into l_temp;
4606 if c230%found then
4607 close c230;
4608 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4609 fnd_message.set_token('TABLE_NAME','BEN_ELIG_OTHR_PTIP_PRTE_F');
4610 fnd_message.raise_error;
4611 end if;
4612 --
4613 close c230;
4614
4615 --
4616 -- Testing for values in BEN_LER_CHG_PTIP_ENRT_F
4617 --
4618 open c231(p_bg_id);
4619 --
4620 fetch c231 into l_temp;
4621 if c231%found then
4622 close c231;
4623 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4624 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PTIP_ENRT_F');
4625 fnd_message.raise_error;
4626 end if;
4627 --
4628 close c231;
4629
4630 --
4631 -- Testing for values in BEN_LER_CHG_DPNT_CVG_CTFN_F
4632 --
4633 open c232(p_bg_id);
4634 --
4635 fetch c232 into l_temp;
4636 if c232%found then
4637 close c232;
4638 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4639 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_DPNT_CVG_CTFN_F');
4640 fnd_message.raise_error;
4641 end if;
4642 --
4643 close c232;
4644
4645 --
4646 -- Testing for values in BEN_LER_CHG_OIPL_ENRT_RL_F
4647 --
4648 open c233(p_bg_id);
4649 --
4650 fetch c233 into l_temp;
4651 if c233%found then
4652 close c233;
4653 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4654 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_OIPL_ENRT_RL_F');
4655 fnd_message.raise_error;
4656 end if;
4657 --
4658 close c233;
4659
4660 --
4661 -- Testing for values in BEN_LER_CHG_PLIP_ENRT_F
4662 --
4663 open c234(p_bg_id);
4664 --
4665 fetch c234 into l_temp;
4666 if c234%found then
4667 close c234;
4668 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4669 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PLIP_ENRT_F');
4670 fnd_message.raise_error;
4671 end if;
4672 --
4673 close c234;
4674
4675 --
4676 -- Testing for values in BEN_LER_ENRT_CTFN_F
4677 --
4678 open c235(p_bg_id);
4679 --
4680 fetch c235 into l_temp;
4681 if c235%found then
4682 close c235;
4683 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4687 --
4684 fnd_message.set_token('TABLE_NAME','BEN_LER_ENRT_CTFN_F');
4685 fnd_message.raise_error;
4686 end if;
4688 close c235;
4689
4690 --
4691 -- Testing for values in BEN_LER_CHG_PLIP_ENRT_RL_F
4692 --
4693 open c236(p_bg_id);
4694 --
4695 fetch c236 into l_temp;
4696 if c236%found then
4697 close c236;
4698 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4699 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PLIP_ENRT_RL_F');
4700 fnd_message.raise_error;
4701 end if;
4702 --
4703 close c236;
4704
4705 --
4706 -- Testing for values in BEN_LER_CHG_PL_NIP_RL_F
4707 --
4708 open c237(p_bg_id);
4709 --
4710 fetch c237 into l_temp;
4711 if c237%found then
4712 close c237;
4713 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4714 fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PL_NIP_RL_F');
4715 fnd_message.raise_error;
4716 end if;
4717 --
4718 close c237;
4719
4720 --
4721 -- Testing for values in BEN_PER_CM_F
4722 --
4723 open c238(p_bg_id);
4724 --
4725 fetch c238 into l_temp;
4726 if c238%found then
4727 close c238;
4728 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4729 fnd_message.set_token('TABLE_NAME','BEN_PER_CM_F');
4730 fnd_message.raise_error;
4731 end if;
4732 --
4733 close c238;
4734
4735 --
4736 -- Testing for values in BEN_PER_CM_TRGR_F
4737 --
4738 open c239(p_bg_id);
4739 --
4740 fetch c239 into l_temp;
4741 if c239%found then
4742 close c239;
4743 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4744 fnd_message.set_token('TABLE_NAME','BEN_PER_CM_TRGR_F');
4745 fnd_message.raise_error;
4746 end if;
4747 --
4748 close c239;
4749
4750 --
4751 -- Testing for values in BEN_PL_BNF_CTFN_PRVDD_F
4752 --
4753 open c240(p_bg_id);
4754 --
4755 fetch c240 into l_temp;
4756 if c240%found then
4757 close c240;
4758 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4759 fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_CTFN_PRVDD_F');
4760 fnd_message.raise_error;
4761 end if;
4762 --
4763 close c240;
4764
4765 --
4766 -- Testing for values in BEN_PTIP_DPNT_CVG_CTFN_F
4767 --
4768 open c241(p_bg_id);
4769 --
4770 fetch c241 into l_temp;
4771 if c241%found then
4772 close c241;
4773 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4774 fnd_message.set_token('TABLE_NAME','BEN_PTIP_DPNT_CVG_CTFN_F');
4775 fnd_message.raise_error;
4776 end if;
4777 --
4778 close c241;
4779
4780 --
4781 -- Testing for values in BEN_WV_PRTN_RSN_PTIP_F
4782 --
4783 open c242(p_bg_id);
4784 --
4785 fetch c242 into l_temp;
4786 if c242%found then
4787 close c242;
4788 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4789 fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_PTIP_F');
4790 fnd_message.raise_error;
4791 end if;
4792 --
4793 close c242;
4794
4795 --
4796 -- Testing for values in BEN_CVRD_DPNT_CTFN_PRVDD_F
4797 --
4798 open c243(p_bg_id);
4799 --
4800 fetch c243 into l_temp;
4801 if c243%found then
4802 close c243;
4803 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4804 fnd_message.set_token('TABLE_NAME','BEN_CVRD_DPNT_CTFN_PRVDD_F');
4805 fnd_message.raise_error;
4806 end if;
4807 --
4808 close c243;
4809
4810 --
4811 -- Testing for values in BEN_PER_CM_USG_F
4812 --
4813 open c244(p_bg_id);
4814 --
4815 fetch c244 into l_temp;
4816 if c244%found then
4817 close c244;
4818 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4819 fnd_message.set_token('TABLE_NAME','BEN_PER_CM_USG_F');
4820 fnd_message.raise_error;
4821 end if;
4822 --
4823 close c244;
4824
4825 --
4826 -- Testing for values in BEN_POPL_ORG_ROLE_F
4827 --
4828 open c245(p_bg_id);
4829 --
4830 fetch c245 into l_temp;
4831 if c245%found then
4832 close c245;
4833 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4834 fnd_message.set_token('TABLE_NAME','BEN_POPL_ORG_ROLE_F');
4835 fnd_message.raise_error;
4836 end if;
4837 --
4838 close c245;
4839
4840 --
4841 -- Testing for values in BEN_ELIG_JOB_PRTE_F
4842 --
4843 open c246(p_bg_id);
4844 --
4845 fetch c246 into l_temp;
4846 if c246%found then
4847 close c246;
4848 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4849 fnd_message.set_token('TABLE_NAME','BEN_ELIG_JOB_PRTE_F');
4850 fnd_message.raise_error;
4851 end if;
4852 --
4853 close c246;
4854
4855 --
4856 -- Testing for values in BEN_WV_PRTN_RSN_CTFN_PTIP_F
4857 --
4858 open c247(p_bg_id);
4859 --
4860 fetch c247 into l_temp;
4861 if c247%found then
4862 close c247;
4863 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4864 fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_CTFN_PTIP_F');
4865 fnd_message.raise_error;
4866 end if;
4867 --
4868 close c247;
4872 --
4869
4870 --
4871 -- Testing for values in BEN_BATCH_COMMU_INFO
4873 open c248(p_bg_id);
4874 --
4875 fetch c248 into l_temp;
4876 if c248%found then
4877 close c248;
4878 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4879 fnd_message.set_token('TABLE_NAME','BEN_BATCH_COMMU_INFO');
4880 fnd_message.raise_error;
4881 end if;
4882 --
4883 close c248;
4884
4885 --
4886 -- Testing for values in BEN_BATCH_DPNT_INFO
4887 --
4888 open c249(p_bg_id);
4889 --
4890 fetch c249 into l_temp;
4891 if c249%found then
4892 close c249;
4893 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4894 fnd_message.set_token('TABLE_NAME','BEN_BATCH_DPNT_INFO');
4895 fnd_message.raise_error;
4896 end if;
4897 --
4898 close c249;
4899
4900 --
4901 -- Testing for values in BEN_BATCH_ELCTBL_CHC_INFO
4902 --
4903 open c250(p_bg_id);
4904 --
4905 fetch c250 into l_temp;
4906 if c250%found then
4907 close c250;
4908 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4909 fnd_message.set_token('TABLE_NAME','BEN_BATCH_ELCTBL_CHC_INFO');
4910 fnd_message.raise_error;
4911 end if;
4912 --
4913 close c250;
4914
4915 --
4916 -- Testing for values in BEN_BATCH_ELIG_INFO
4917 --
4918 open c251(p_bg_id);
4919 --
4920 fetch c251 into l_temp;
4921 if c251%found then
4922 close c251;
4923 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4924 fnd_message.set_token('TABLE_NAME','BEN_BATCH_ELIG_INFO');
4925 fnd_message.raise_error;
4926 end if;
4927 --
4928 close c251;
4929
4930 --
4931 -- Testing for values in BEN_BATCH_LER_INFO
4932 --
4933 open c252(p_bg_id);
4934 --
4935 fetch c252 into l_temp;
4936 if c252%found then
4937 close c252;
4938 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4939 fnd_message.set_token('TABLE_NAME','BEN_BATCH_LER_INFO');
4940 fnd_message.raise_error;
4941 end if;
4942 --
4943 close c252;
4944
4945 --
4946 -- Testing for values in BEN_BATCH_RATE_INFO
4947 --
4948 open c253(p_bg_id);
4949 --
4950 fetch c253 into l_temp;
4951 if c253%found then
4952 close c253;
4953 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4954 fnd_message.set_token('TABLE_NAME','BEN_BATCH_RATE_INFO');
4955 fnd_message.raise_error;
4956 end if;
4957 --
4958 close c253;
4959
4960 --
4961 -- Testing for values in BEN_BENEFIT_ACTIONS
4962 --
4963 open c254(p_bg_id);
4964 --
4965 fetch c254 into l_temp;
4966 if c254%found then
4967 close c254;
4968 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4969 fnd_message.set_token('TABLE_NAME','BEN_BENEFIT_ACTIONS');
4970 fnd_message.raise_error;
4971 end if;
4972 --
4973 close c254;
4974
4975 --
4976 -- Testing for values in BEN_CLPSE_LF_EVT_F
4977 --
4978 open c255(p_bg_id);
4979 --
4980 fetch c255 into l_temp;
4981 if c255%found then
4982 close c255;
4983 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4984 fnd_message.set_token('TABLE_NAME','BEN_CLPSE_LF_EVT_F');
4985 fnd_message.raise_error;
4986 end if;
4987 --
4988 close c255;
4989
4990 --
4991 -- Testing for values in BEN_PREM_CSTG_BY_SGMT_F
4992 --
4993 open c256(p_bg_id);
4994 --
4995 fetch c256 into l_temp;
4996 if c256%found then
4997 close c256;
4998 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4999 fnd_message.set_token('TABLE_NAME','BEN_PREM_CSTG_BY_SGMT_F');
5000 fnd_message.raise_error;
5001 end if;
5002 --
5003 close c256;
5004
5005 --
5006 -- Testing for values in BEN_BATCH_PROC_INFO
5007 --
5008 open c257(p_bg_id);
5009 --
5010 fetch c257 into l_temp;
5011 if c257%found then
5012 close c257;
5013 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5014 fnd_message.set_token('TABLE_NAME','BEN_BATCH_PROC_INFO');
5015 fnd_message.raise_error;
5016 end if;
5017 --
5018 close c257;
5019
5020 --
5021 -- Testing for values in BEN_PRTT_PREM_BY_MO_F
5022 --
5023 open c258(p_bg_id);
5024 --
5025 fetch c258 into l_temp;
5026 if c258%found then
5027 close c258;
5028 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5029 fnd_message.set_token('TABLE_NAME','BEN_PRTT_PREM_BY_MO_F');
5030 fnd_message.raise_error;
5031 end if;
5032 --
5033 close c258;
5034
5035 --
5036 -- Testing for values in BEN_PER_CM_PRVDD_F
5037 --
5038 open c259(p_bg_id);
5039 --
5040 fetch c259 into l_temp;
5041 if c259%found then
5042 close c259;
5043 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5044 fnd_message.set_token('TABLE_NAME','BEN_PER_CM_PRVDD_F');
5045 fnd_message.raise_error;
5046 end if;
5047 --
5048 close c259;
5049
5050 --
5051 -- Testing for values in BEN_PRTT_REIMBMT_RQST_F
5052 --
5053 open c260(p_bg_id);
5054 --
5055 fetch c260 into l_temp;
5059 fnd_message.set_token('TABLE_NAME','BEN_PRTT_REIMBMT_RQST_F');
5056 if c260%found then
5057 close c260;
5058 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5060 fnd_message.raise_error;
5061 end if;
5062 --
5063 close c260;
5064
5065 --
5066 -- Testing for values in BEN_PRTT_CLM_GD_OR_SVC_TYP
5067 --
5068 open c261(p_bg_id);
5069 --
5070 fetch c261 into l_temp;
5071 if c261%found then
5072 close c261;
5073 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5074 fnd_message.set_token('TABLE_NAME','BEN_PRTT_CLM_GD_OR_SVC_TYP');
5075 fnd_message.raise_error;
5076 end if;
5077 --
5078 close c261;
5079
5080 --
5081 -- Testing for values in BEN_ROLL_REIMB_RQST
5082 --
5083 open c262(p_bg_id);
5084 --
5085 fetch c262 into l_temp;
5086 if c262%found then
5087 close c262;
5088 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5089 fnd_message.set_token('TABLE_NAME','BEN_ROLL_REIMB_RQST');
5090 fnd_message.raise_error;
5091 end if;
5092 --
5093 close c262;
5094
5095 --
5096 -- Testing for values in BEN_ELIG_EE_STAT_PRTE_F
5097 --
5098 open c263(p_bg_id);
5099 --
5100 fetch c263 into l_temp;
5101 if c263%found then
5102 close c263;
5103 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5104 fnd_message.set_token('TABLE_NAME','BEN_ELIG_EE_STAT_PRTE_F');
5105 fnd_message.raise_error;
5106 end if;
5107 --
5108 close c263;
5109
5110 --
5111 -- Testing for values in BEN_EE_STAT_RT_F
5112 --
5113 open c264(p_bg_id);
5114 --
5115 fetch c264 into l_temp;
5116 if c264%found then
5117 close c264;
5118 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5119 fnd_message.set_token('TABLE_NAME','BEN_EE_STAT_RT_F');
5120 fnd_message.raise_error;
5121 end if;
5122 --
5123 close c264;
5124
5125 --
5126 -- Testing for values in BEN_ELIG_ASNT_SET_PRTE_F
5127 --
5128 open c265(p_bg_id);
5129 --
5130 fetch c265 into l_temp;
5131 if c265%found then
5132 close c265;
5133 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5134 fnd_message.set_token('TABLE_NAME','BEN_ELIG_ASNT_SET_PRTE_F');
5135 fnd_message.raise_error;
5136 end if;
5137 --
5138 close c265;
5139
5140 --
5141 -- Testing for values in BEN_ACTY_BASE_RT_F
5142 --
5143 open c266(p_bg_id);
5144 --
5145 fetch c266 into l_temp;
5146 if c266%found then
5147 close c266;
5148 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5149 fnd_message.set_token('TABLE_NAME','BEN_ACTY_BASE_RT_F');
5150 fnd_message.raise_error;
5151 end if;
5152 --
5153 close c266;
5154
5155 --
5156 -- Testing for values in BEN_ACTY_RT_PTD_LMT_F
5157 --
5158 open c267(p_bg_id);
5159 --
5160 fetch c267 into l_temp;
5161 if c267%found then
5162 close c267;
5163 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5164 fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_PTD_LMT_F');
5165 fnd_message.raise_error;
5166 end if;
5167 --
5168 close c267;
5169
5170 --
5171 -- Testing for values in BEN_ACTY_RT_PYMT_SCHED_F
5172 --
5173 open c268(p_bg_id);
5174 --
5175 fetch c268 into l_temp;
5176 if c268%found then
5177 close c268;
5178 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5179 fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_PYMT_SCHED_F');
5180 fnd_message.raise_error;
5181 end if;
5182 --
5183 close c268;
5184
5185 --
5186 -- Testing for values in BEN_ACTY_VRBL_RT_F
5187 --
5188 open c269(p_bg_id);
5189 --
5190 fetch c269 into l_temp;
5191 if c269%found then
5192 close c269;
5193 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5194 fnd_message.set_token('TABLE_NAME','BEN_ACTY_VRBL_RT_F');
5195 fnd_message.raise_error;
5196 end if;
5197 --
5198 close c269;
5199
5200 --
5201 -- Testing for values in BEN_APLCN_TO_BNFT_POOL_F
5202 --
5203 open c270(p_bg_id);
5204 --
5205 fetch c270 into l_temp;
5206 if c270%found then
5207 close c270;
5208 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5209 fnd_message.set_token('TABLE_NAME','BEN_APLCN_TO_BNFT_POOL_F');
5210 fnd_message.raise_error;
5211 end if;
5212 --
5213 close c270;
5214
5215 --
5216 -- Testing for values in BEN_BNFT_POOL_RLOVR_RQMT_F
5217 --
5218 open c271(p_bg_id);
5219 --
5220 fetch c271 into l_temp;
5221 if c271%found then
5222 close c271;
5223 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5224 fnd_message.set_token('TABLE_NAME','BEN_BNFT_POOL_RLOVR_RQMT_F');
5225 fnd_message.raise_error;
5226 end if;
5227 --
5228 close c271;
5229
5230 --
5231 -- Testing for values in BEN_BNFT_PRVDD_LDGR_F
5232 --
5233 open c272(p_bg_id);
5234 --
5235 fetch c272 into l_temp;
5236 if c272%found then
5237 close c272;
5238 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5242 --
5239 fnd_message.set_token('TABLE_NAME','BEN_BNFT_PRVDD_LDGR_F');
5240 fnd_message.raise_error;
5241 end if;
5243 close c272;
5244
5245 --
5246 -- Testing for values in BEN_COMP_LVL_ACTY_RT_F
5247 --
5248 open c273(p_bg_id);
5249 --
5250 fetch c273 into l_temp;
5251 if c273%found then
5252 close c273;
5253 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5254 fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_ACTY_RT_F');
5255 fnd_message.raise_error;
5256 end if;
5257 --
5258 close c273;
5259
5260 --
5261 -- Testing for values in BEN_MTCHG_RT_F
5262 --
5263 open c274(p_bg_id);
5264 --
5265 fetch c274 into l_temp;
5266 if c274%found then
5267 close c274;
5268 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5269 fnd_message.set_token('TABLE_NAME','BEN_MTCHG_RT_F');
5270 fnd_message.raise_error;
5271 end if;
5272 --
5273 close c274;
5274
5275 --
5276 -- Testing for values in BEN_PAIRD_RT_F
5277 --
5278 open c275(p_bg_id);
5279 --
5280 fetch c275 into l_temp;
5281 if c275%found then
5282 close c275;
5283 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5284 fnd_message.set_token('TABLE_NAME','BEN_PAIRD_RT_F');
5285 fnd_message.raise_error;
5286 end if;
5287 --
5288 close c275;
5289
5290 --
5291 -- Testing for values in BEN_PRTL_MO_RT_PRTN_VAL_F
5292 --
5293 open c276(p_bg_id);
5294 --
5295 fetch c276 into l_temp;
5296 if c276%found then
5297 close c276;
5298 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5299 fnd_message.set_token('TABLE_NAME','BEN_PRTL_MO_RT_PRTN_VAL_F');
5300 fnd_message.raise_error;
5301 end if;
5302 --
5303 close c276;
5304
5305 --
5306 -- Testing for values in BEN_VRBL_RT_RL_F
5307 --
5308 open c277(p_bg_id);
5309 --
5310 fetch c277 into l_temp;
5311 if c277%found then
5312 close c277;
5313 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5314 fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_RL_F');
5315 fnd_message.raise_error;
5316 end if;
5317 --
5318 close c277;
5319
5320 --
5321 -- Testing for values in BEN_DED_SCHED_PY_FREQ
5322 --
5323 open c278(p_bg_id);
5324 --
5325 fetch c278 into l_temp;
5326 if c278%found then
5327 close c278;
5328 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5329 fnd_message.set_token('TABLE_NAME','BEN_DED_SCHED_PY_FREQ');
5330 fnd_message.raise_error;
5331 end if;
5332 --
5333 close c278;
5334
5335 --
5336 -- Testing for values in BEN_ACTY_RT_DED_SCHED_F
5337 --
5338 open c279(p_bg_id);
5339 --
5340 fetch c279 into l_temp;
5341 if c279%found then
5342 close c279;
5343 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5344 fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_DED_SCHED_F');
5345 fnd_message.raise_error;
5346 end if;
5347 --
5348 close c279;
5349
5350 --
5351 -- Testing for values in BEN_PERD_TO_PROC
5352 --
5353 open c280(p_bg_id);
5354 --
5355 fetch c280 into l_temp;
5356 if c280%found then
5357 close c280;
5358 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5359 fnd_message.set_token('TABLE_NAME','BEN_PERD_TO_PROC');
5360 fnd_message.raise_error;
5361 end if;
5362 --
5363 close c280;
5364
5365 --
5366 -- Testing for values in BEN_PYMT_SCHED_PY_FREQ
5367 --
5368 open c281(p_bg_id);
5369 --
5370 fetch c281 into l_temp;
5371 if c281%found then
5372 close c281;
5373 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5374 fnd_message.set_token('TABLE_NAME','BEN_PYMT_SCHED_PY_FREQ');
5375 fnd_message.raise_error;
5376 end if;
5377 --
5378 close c281;
5379
5380 --
5381 -- Testing for values in BEN_PRTT_ASSOCD_INSTN_F
5382 --
5383 open c282(p_bg_id);
5384 --
5385 fetch c282 into l_temp;
5386 if c282%found then
5387 close c282;
5388 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5389 fnd_message.set_token('TABLE_NAME','BEN_PRTT_ASSOCD_INSTN_F');
5390 fnd_message.raise_error;
5391 end if;
5392 --
5393 close c282;
5394
5395 --
5396 -- Testing for values in BEN_PRTT_RT_VAL
5397 --
5398 open c283(p_bg_id);
5399 --
5400 fetch c283 into l_temp;
5401 if c283%found then
5402 close c283;
5403 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5404 fnd_message.set_token('TABLE_NAME','BEN_PRTT_RT_VAL');
5405 fnd_message.raise_error;
5406 end if;
5407 --
5408 close c283;
5409
5410 --
5411 -- Testing for values in BEN_PRTT_VSTG_F
5412 --
5413 open c284(p_bg_id);
5414 --
5415 fetch c284 into l_temp;
5416 if c284%found then
5417 close c284;
5418 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5419 fnd_message.set_token('TABLE_NAME','BEN_PRTT_VSTG_F');
5420 fnd_message.raise_error;
5421 end if;
5422 --
5423 close c284;
5424
5425 --
5426 -- Testing for values in BEN_ENRT_RT
5427 --
5428 open c285(p_bg_id);
5429 --
5433 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5430 fetch c285 into l_temp;
5431 if c285%found then
5432 close c285;
5434 fnd_message.set_token('TABLE_NAME','BEN_ENRT_RT');
5435 fnd_message.raise_error;
5436 end if;
5437 --
5438 close c285;
5439
5440 --
5441 -- Testing for values in BEN_PRTT_REIMBMT_RECON
5442 --
5443 open c286(p_bg_id);
5444 --
5445 fetch c286 into l_temp;
5446 if c286%found then
5447 close c286;
5448 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5449 fnd_message.set_token('TABLE_NAME','BEN_PRTT_REIMBMT_RECON');
5450 fnd_message.raise_error;
5451 end if;
5452 --
5453 close c286;
5454
5455 --
5456 -- Testing for values in BEN_ELIG_LOA_RSN_PRTE_F
5457 --
5458 open c287(p_bg_id);
5459 --
5460 fetch c287 into l_temp;
5461 if c287%found then
5462 close c287;
5463 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5464 fnd_message.set_token('TABLE_NAME','BEN_ELIG_LOA_RSN_PRTE_F');
5465 fnd_message.raise_error;
5466 end if;
5467 --
5468 close c287;
5469
5470 --
5471 -- Testing for values in BEN_LOA_RSN_RT_F
5472 --
5473 open c288(p_bg_id);
5474 --
5475 fetch c288 into l_temp;
5476 if c288%found then
5477 close c288;
5478 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5479 fnd_message.set_token('TABLE_NAME','BEN_LOA_RSN_RT_F');
5480 fnd_message.raise_error;
5481 end if;
5482 --
5483 close c288;
5484
5485 --
5486 -- Testing for values in BEN_ELIG_PY_BSS_PRTE_F
5487 --
5488 open c289(p_bg_id);
5489 --
5490 fetch c289 into l_temp;
5491 if c289%found then
5492 close c289;
5493 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5494 fnd_message.set_token('TABLE_NAME','BEN_ELIG_PY_BSS_PRTE_F');
5495 fnd_message.raise_error;
5496 end if;
5497 --
5498 close c289;
5499
5500 --
5501 -- Testing for values in BEN_PY_BSS_RT_F
5502 --
5503 open c290(p_bg_id);
5504 --
5505 fetch c290 into l_temp;
5506 if c290%found then
5507 close c290;
5508 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5509 fnd_message.set_token('TABLE_NAME','BEN_PY_BSS_RT_F');
5510 fnd_message.raise_error;
5511 end if;
5512 --
5513 close c290;
5514
5515 --
5516 -- Testing for values in BEN_ELIG_ENRLD_ANTHR_OIPL_F
5517 --
5518 open c291(p_bg_id);
5519 --
5520 fetch c291 into l_temp;
5521 if c291%found then
5522 close c291;
5523 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5524 fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_OIPL_F');
5525 fnd_message.raise_error;
5526 end if;
5527 --
5528 close c291;
5529 --
5530 -- Testing for values in BEN_PL_PCP
5531 --
5532 open c292(p_bg_id);
5533 --
5534 fetch c292 into l_temp;
5535 if c292%found then
5536 close c292;
5537 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5538 fnd_message.set_token('TABLE_NAME','BEN_PL_PCP');
5539 fnd_message.raise_error;
5540 end if;
5541 --
5542 close c292;
5543 --
5544 -- Testing for values in BEN_PL_PCP_TYP
5545 --
5546 open c293(p_bg_id);
5547 --
5548 fetch c293 into l_temp;
5549 if c293%found then
5550 close c293;
5551 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5552 fnd_message.set_token('TABLE_NAME','BEN_PL_PCP_TYP');
5553 fnd_message.raise_error;
5554 end if;
5555 --
5556 close c293;
5557
5558 -- Testing for values in BEN_OPTIP_F
5559 --
5560 open c294(p_bg_id);
5561 --
5562 fetch c294 into l_temp;
5563 if c294%found then
5564 close c294;
5565 fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5566 fnd_message.set_token('TABLE_NAME','BEN_OPTIP_F');
5567 fnd_message.raise_error;
5568 end if;
5569 --
5570 close c294;
5571
5572
5573 end perform_ri_check;
5574
5575 procedure delete_below_bg(p_bg_id NUMBER) is
5576 BEGIN
5577 delete from BEN_CBR_QUALD_BNF
5578 where business_group_id = p_bg_id;
5579
5580 --delete from BEN_HLTH_CVG_SLCTD_RT_F
5581 --where business_group_id = p_bg_id;
5582
5583 delete from BEN_PER_INFO_CHG_CS_LER_F
5584 where business_group_id = p_bg_id;
5585
5586 --delete from BEN_PRTN_IN_ANTHR_PL_RT_F
5587 --where business_group_id = p_bg_id;
5588
5589 --delete from BEN_PRTT_PREM_BY_MO_CR_F
5590 --where business_group_id = p_bg_id;
5591
5592 delete from BEN_RLTD_PER_CHG_CS_LER_F
5593 where business_group_id = p_bg_id;
5594
5595 delete from BEN_PCT_FL_TM_FCTR
5596 where business_group_id = p_bg_id;
5597
5598 delete from BEN_AGE_FCTR
5599 where business_group_id = p_bg_id;
5600
5601 delete from BEN_BENFTS_GRP
5602 where business_group_id = p_bg_id;
5603
5604 delete from BEN_GD_OR_SVC_TYP
5605 where business_group_id = p_bg_id;
5606
5607 delete from BEN_LOS_FCTR
5608 where business_group_id = p_bg_id;
5609
5610 delete from BEN_ELIGY_PRFL_F
5611 where business_group_id = p_bg_id;
5612
5613 delete from BEN_ELIG_LVG_RSN_PRTE_F
5614 where business_group_id = p_bg_id;
5618
5615
5616 delete from BEN_ELIG_NO_OTHR_CVG_PRTE_F
5617 where business_group_id = p_bg_id;
5619 delete from BEN_ELIG_OPTD_MDCR_PRTE_F
5620 where business_group_id = p_bg_id;
5621
5622 delete from BEN_ACTN_TYP
5623 where business_group_id = p_bg_id;
5624
5625 delete from BEN_BATCH_ACTN_ITEM_INFO
5626 where business_group_id = p_bg_id;
5627
5628 delete from BEN_BATCH_PARAMETER
5629 where business_group_id = p_bg_id;
5630
5631 delete from BEN_BNFTS_BAL_F
5632 where business_group_id = p_bg_id;
5633
5634 delete from BEN_CM_TYP_F
5635 where business_group_id = p_bg_id;
5636
5637 delete from BEN_CM_TYP_TRGR_F
5638 where business_group_id = p_bg_id;
5639
5640 delete from BEN_CNTNG_PRTN_ELIG_PRFL_F
5641 where business_group_id = p_bg_id;
5642
5643 delete from BEN_COMP_ASSET
5644 where business_group_id = p_bg_id;
5645
5646 delete from BEN_CSR_ACTIVITIES
5647 where business_group_id = p_bg_id;
5648
5649 delete from BEN_ELIG_BRGNG_UNIT_PRTE_F
5650 where business_group_id = p_bg_id;
5651
5652 delete from BEN_ELIG_FL_TM_PT_TM_PRTE_F
5653 where business_group_id = p_bg_id;
5654
5655 delete from BEN_ELIG_HRLY_SLRD_PRTE_F
5656 where business_group_id = p_bg_id;
5657
5658 delete from BEN_ELIG_LBR_MMBR_PRTE_F
5659 where business_group_id = p_bg_id;
5660
5661 delete from BEN_ELIG_PER_TYP_PRTE_F
5662 where business_group_id = p_bg_id;
5663
5664 delete from BEN_ELIG_PYRL_PRTE_F
5665 where business_group_id = p_bg_id;
5666
5667 delete from BEN_ELIG_SCHEDD_HRS_PRTE_F
5668 where business_group_id = p_bg_id;
5669
5670 delete from BEN_EXT_CHG_EVT_LOG
5671 where business_group_id = p_bg_id;
5672
5673 delete from BEN_EXT_CRIT_PRFL
5674 where business_group_id = p_bg_id;
5675
5676 delete from BEN_EXT_FILE
5677 where business_group_id = p_bg_id;
5678
5679 delete from BEN_EXT_FLD
5680 where business_group_id = p_bg_id;
5681
5682 delete from BEN_EXT_RCD
5683 where business_group_id = p_bg_id;
5684
5685 delete from BEN_PIN
5686 where business_group_id = p_bg_id;
5687
5688 delete from BEN_PL_TYP_F
5689 where business_group_id = p_bg_id;
5690
5691 delete from BEN_POP_UP_MESSAGES
5692 where business_group_id = p_bg_id;
5693
5694 delete from BEN_PSTL_ZIP_RNG_F
5695 where business_group_id = p_bg_id;
5696
5697 delete from BEN_VSTG_SCHED_F
5698 where business_group_id = p_bg_id;
5699
5700 delete from BEN_YR_PERD
5701 where business_group_id = p_bg_id;
5702
5703 delete from BEN_CMBN_AGE_LOS_FCTR
5704 where business_group_id = p_bg_id;
5705
5706 delete from BEN_CM_DLVRY_MTHD_TYP
5707 where business_group_id = p_bg_id;
5708
5709 delete from BEN_CNTNU_PRTN_CTFN_TYP_F
5710 where business_group_id = p_bg_id;
5711
5712 delete from BEN_ELIGY_PRFL_RL_F
5713 where business_group_id = p_bg_id;
5714
5715 delete from BEN_ELIG_AGE_PRTE_F
5716 where business_group_id = p_bg_id;
5717
5718 delete from BEN_ELIG_BENFTS_GRP_PRTE_F
5719 where business_group_id = p_bg_id;
5720
5721 delete from BEN_ELIG_LOS_PRTE_F
5722 where business_group_id = p_bg_id;
5723
5724 delete from BEN_ELIG_PCT_FL_TM_PRTE_F
5725 where business_group_id = p_bg_id;
5726
5727 delete from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
5728 where business_group_id = p_bg_id;
5729
5730 delete from BEN_ELIG_WK_LOC_PRTE_F
5731 where business_group_id = p_bg_id;
5732
5733 delete from BEN_EXT_CRIT_TYP
5734 where business_group_id = p_bg_id;
5735
5736 delete from BEN_EXT_DFN
5737 where business_group_id = p_bg_id;
5738
5739 delete from BEN_ORG_UNIT_PRDCT_F
5740 where business_group_id = p_bg_id;
5741
5742 delete from BEN_PER_BNFTS_BAL_F
5743 where business_group_id = p_bg_id;
5744
5745 delete from BEN_PER_PIN_F
5746 where business_group_id = p_bg_id;
5747
5748 delete from BEN_VSTG_AGE_RQMT
5749 where business_group_id = p_bg_id;
5750
5751 delete from BEN_VSTG_FOR_ACTY_RT_F
5752 where business_group_id = p_bg_id;
5753
5754 delete from BEN_WTHN_YR_PERD
5755 where business_group_id = p_bg_id;
5756
5757 delete from BEN_CM_DLVRY_MED_TYP
5758 where business_group_id = p_bg_id;
5759
5760 delete from BEN_ELIG_SVC_AREA_PRTE_F
5761 where business_group_id = p_bg_id;
5762
5763 delete from BEN_EXT_CRIT_VAL
5764 where business_group_id = p_bg_id;
5765
5766 delete from BEN_EXT_DATA_ELMT
5767 where business_group_id = p_bg_id;
5768
5769 delete from BEN_EXT_RSLT
5770 where business_group_id = p_bg_id;
5771
5772 delete from BEN_SVC_AREA_F
5773 where business_group_id = p_bg_id;
5774
5775 delete from BEN_VSTG_LOS_RQMT
5776 where business_group_id = p_bg_id;
5777
5778 delete from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
5779 where business_group_id = p_bg_id;
5780
5781 delete from BEN_EXT_CRIT_CMBN
5782 where business_group_id = p_bg_id;
5783
5784 delete from BEN_EXT_DATA_ELMT_DECD
5785 where business_group_id = p_bg_id;
5786
5787 delete from BEN_EXT_DATA_ELMT_IN_RCD
5788 where business_group_id = p_bg_id;
5789
5790 delete from BEN_EXT_RSLT_DTL
5794 where business_group_id = p_bg_id;
5791 where business_group_id = p_bg_id;
5792
5793 delete from BEN_SVC_AREA_PSTL_ZIP_RNG_F
5795
5796 delete from BEN_COMP_LVL_FCTR
5797 where business_group_id = p_bg_id;
5798
5799 delete from BEN_ELIG_LGL_ENTY_PRTE_F
5800 where business_group_id = p_bg_id;
5801
5802 delete from BEN_ELIG_ORG_UNIT_PRTE_F
5803 where business_group_id = p_bg_id;
5804
5805 delete from BEN_EXT_RSLT_ERR
5806 where business_group_id = p_bg_id;
5807
5808 delete from BEN_REGN_F
5809 where business_group_id = p_bg_id;
5810
5811 delete from BEN_EXT_INCL_DATA_ELMT
5812 where business_group_id = p_bg_id;
5813
5814 delete from BEN_EXT_RCD_IN_FILE
5815 where business_group_id = p_bg_id;
5816
5817 delete from BEN_REGN_FOR_REGY_BODY_F
5818 where business_group_id = p_bg_id;
5819
5820 delete from BEN_EXT_INCL_CHG
5821 where business_group_id = p_bg_id;
5822
5823 delete from BEN_EXT_WHERE_CLAUSE
5824 where business_group_id = p_bg_id;
5825
5826 delete from BEN_RPTG_GRP
5827 where business_group_id = p_bg_id;
5828
5829 delete from BEN_DPNT_CVG_ELIGY_PRFL_F
5830 where business_group_id = p_bg_id;
5831
5832 delete from BEN_HRS_WKD_IN_PERD_FCTR
5833 where business_group_id = p_bg_id;
5834
5835 delete from BEN_DPNT_CVG_RQD_RLSHP_F
5836 where business_group_id = p_bg_id;
5837
5838 delete from BEN_DSGNTR_ENRLD_CVG_F
5839 where business_group_id = p_bg_id;
5840
5841 delete from BEN_ELIG_COMP_LVL_PRTE_F
5842 where business_group_id = p_bg_id;
5843
5844 delete from BEN_ELIG_DSBLD_STAT_CVG_F
5845 where business_group_id = p_bg_id;
5846
5847 delete from BEN_ELIG_HRS_WKD_PRTE_F
5848 where business_group_id = p_bg_id;
5849
5850 delete from BEN_ELIG_MLTRY_STAT_CVG_F
5851 where business_group_id = p_bg_id;
5852
5853 delete from BEN_ELIG_MRTL_STAT_CVG_F
5854 where business_group_id = p_bg_id;
5855
5856 delete from BEN_ELIG_STDNT_STAT_CVG_F
5857 where business_group_id = p_bg_id;
5858
5859 delete from BEN_ELIG_AGE_CVG_F
5860 where business_group_id = p_bg_id;
5861
5862 delete from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
5863 where business_group_id = p_bg_id;
5864
5865 delete from BEN_PTD_LMT_F
5866 where business_group_id = p_bg_id;
5867
5868 delete from BEN_PTD_BAL_TYP_F
5869 where business_group_id = p_bg_id;
5870
5871 delete from BEN_ELIG_GRD_PRTE_F
5872 where business_group_id = p_bg_id;
5873
5874 delete from BEN_PER_DLVRY_MTHD_F
5875 where business_group_id = p_bg_id;
5876
5877 delete from BEN_PER_IN_LGL_ENTY_F
5878 where business_group_id = p_bg_id;
5879
5880 delete from BEN_PER_IN_ORG_UNIT_F
5881 where business_group_id = p_bg_id;
5882
5883 delete from BEN_PER_IN_ORG_ROLE_F
5884 where business_group_id = p_bg_id;
5885
5886 delete from BEN_ACRS_PTIP_CVG_F
5887 where business_group_id = p_bg_id;
5888
5889 delete from BEN_PL_TYP_OPT_TYP_F
5890 where business_group_id = p_bg_id;
5891
5892 delete from BEN_ENRT_PERD
5893 where business_group_id = p_bg_id;
5894
5895 delete from BEN_OPT_F
5896 where business_group_id = p_bg_id;
5897
5898 delete from BEN_LER_F
5899 where business_group_id = p_bg_id;
5900
5901 delete from BEN_LER_RLTD_PER_CS_LER_F
5902 where business_group_id = p_bg_id;
5903
5904 delete from BEN_CBR_PER_IN_LER
5905 where business_group_id = p_bg_id;
5906
5907 delete from BEN_CSS_RLTD_PER_PER_IN_LER_F
5908 where business_group_id = p_bg_id;
5909
5910 delete from BEN_LER_PER_INFO_CS_LER_F
5911 where business_group_id = p_bg_id;
5912
5913 delete from BEN_LE_CLSN_N_RSTR
5914 where business_group_id = p_bg_id;
5915
5916 delete from BEN_PER_IN_LER
5917 where business_group_id = p_bg_id;
5918
5919 delete from BEN_PTNL_LER_FOR_PER
5920 where business_group_id = p_bg_id;
5921
5922 delete from BEN_PGM_F
5923 where business_group_id = p_bg_id;
5924
5925 delete from BEN_ELIG_ENRLD_ANTHR_PGM_F
5926 where business_group_id = p_bg_id;
5927
5928 delete from BEN_ELIG_PRTT_ANTHR_PGM_F
5929 where business_group_id = p_bg_id;
5930
5931 delete from BEN_PLIP_F
5932 where business_group_id = p_bg_id;
5933
5934 delete from BEN_PL_F
5935 where business_group_id = p_bg_id;
5936
5937 delete from BEN_PTIP_F
5938 where business_group_id = p_bg_id;
5939
5940 delete from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
5941 where business_group_id = p_bg_id;
5942
5943 delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5944 where business_group_id = p_bg_id;
5945
5946 delete from BEN_ELIG_ENRLD_ANTHR_PL_F
5947 where business_group_id = p_bg_id;
5948
5949 delete from BEN_ENRT_ENRLD_ANTHR_PL_F
5950 where business_group_id = p_bg_id;
5951
5952 delete from BEN_OIPLIP_F
5953 where business_group_id = p_bg_id;
5954
5955 delete from BEN_OIPL_F
5956 where business_group_id = p_bg_id;
5957
5958 delete from BEN_PGM_DPNT_CVG_CTFN_F
5959 where business_group_id = p_bg_id;
5960
5961 delete from BEN_BNFT_PRVDR_POOL_F
5962 where business_group_id = p_bg_id;
5963
5964 delete from BEN_CMBN_PLIP_F
5968 where business_group_id = p_bg_id;
5965 where business_group_id = p_bg_id;
5966
5967 delete from BEN_CMBN_PTIP_F
5969
5970 delete from BEN_CMBN_PTIP_OPT_F
5971 where business_group_id = p_bg_id;
5972
5973 delete from BEN_CM_TYP_USG_F
5974 where business_group_id = p_bg_id;
5975
5976 delete from BEN_DSGN_RQMT_F
5977 where business_group_id = p_bg_id;
5978
5979 delete from BEN_ELIG_TO_PRTE_RSN_F
5980 where business_group_id = p_bg_id;
5981
5982 delete from BEN_LER_CHG_PGM_ENRT_F
5983 where business_group_id = p_bg_id;
5984
5985 delete from BEN_PL_BNF_CTFN_F
5986 where business_group_id = p_bg_id;
5987
5988 delete from BEN_PL_DPNT_CVG_CTFN_F
5989 where business_group_id = p_bg_id;
5990
5991 delete from BEN_PL_GD_OR_SVC_F
5992 where business_group_id = p_bg_id;
5993
5994 delete from BEN_PL_REGN_F
5995 where business_group_id = p_bg_id;
5996
5997 delete from BEN_PL_REGY_BOD_F
5998 where business_group_id = p_bg_id;
5999
6000 delete from BEN_POPL_ACTN_TYP_F
6001 where business_group_id = p_bg_id;
6002
6003 delete from BEN_POPL_ENRT_TYP_CYCL_F
6004 where business_group_id = p_bg_id;
6005
6006 delete from BEN_POPL_ORG_F
6007 where business_group_id = p_bg_id;
6008
6009 delete from BEN_WV_PRTN_RSN_PL_F
6010 where business_group_id = p_bg_id;
6011
6012 delete from BEN_CRT_ORDR
6013 where business_group_id = p_bg_id;
6014
6015 delete from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
6016 where business_group_id = p_bg_id;
6017
6018 delete from BEN_ENRT_CTFN_F
6019 where business_group_id = p_bg_id;
6020
6021 delete from BEN_LEE_RSN_F
6022 where business_group_id = p_bg_id;
6023
6024 delete from BEN_PL_R_OIPL_ASSET_F
6025 where business_group_id = p_bg_id;
6026
6027 delete from BEN_POPL_RPTG_GRP_F
6028 where business_group_id = p_bg_id;
6029
6030 delete from BEN_POPL_YR_PERD
6031 where business_group_id = p_bg_id;
6032
6033 delete from BEN_PRTN_ELIG_F
6034 where business_group_id = p_bg_id;
6035
6036 delete from BEN_VALD_RLSHP_FOR_REIMB_F
6037 where business_group_id = p_bg_id;
6038
6039 delete from BEN_VRBL_RT_PRFL_F
6040 where business_group_id = p_bg_id;
6041
6042 delete from BEN_BNFT_RSTRN_CTFN_F
6043 where business_group_id = p_bg_id;
6044
6045 delete from BEN_BRGNG_UNIT_RT_F
6046 where business_group_id = p_bg_id;
6047
6048 delete from BEN_CMBN_AGE_LOS_RT_F
6049 where business_group_id = p_bg_id;
6050
6051 delete from BEN_COMP_LVL_RT_F
6052 where business_group_id = p_bg_id;
6053
6054 delete from BEN_DSGN_RQMT_RLSHP_TYP
6055 where business_group_id = p_bg_id;
6056
6057 delete from BEN_ENRT_PERD_FOR_PL_F
6058 where business_group_id = p_bg_id;
6059
6060 delete from BEN_LGL_ENTY_RT_F
6061 where business_group_id = p_bg_id;
6062
6063 delete from BEN_LOS_RT_F
6064 where business_group_id = p_bg_id;
6065
6066 delete from BEN_ORG_UNIT_RT_F
6067 where business_group_id = p_bg_id;
6068
6069 delete from BEN_PCT_FL_TM_RT_F
6070 where business_group_id = p_bg_id;
6071
6072 delete from BEN_PER_TYP_RT_F
6073 where business_group_id = p_bg_id;
6074
6075 delete from BEN_PPL_GRP_RT_F
6076 where business_group_id = p_bg_id;
6077
6078 delete from BEN_PSTL_ZIP_RT_F
6079 where business_group_id = p_bg_id;
6080
6081 delete from BEN_PYRL_RT_F
6082 where business_group_id = p_bg_id;
6083
6084 delete from BEN_SCHEDD_HRS_RT_F
6085 where business_group_id = p_bg_id;
6086
6087 delete from BEN_SVC_AREA_RT_F
6088 where business_group_id = p_bg_id;
6089
6090 delete from BEN_TBCO_USE_RT_F
6091 where business_group_id = p_bg_id;
6092
6093 delete from BEN_TTL_CVG_VOL_RT_F
6094 where business_group_id = p_bg_id;
6095
6096 delete from BEN_TTL_PRTT_RT_F
6097 where business_group_id = p_bg_id;
6098
6099 delete from BEN_VRBL_MTCHG_RT_F
6100 where business_group_id = p_bg_id;
6101
6102 delete from BEN_VRBL_RT_PRFL_RL_F
6103 where business_group_id = p_bg_id;
6104
6105 delete from BEN_WK_LOC_RT_F
6106 where business_group_id = p_bg_id;
6107
6108 delete from BEN_ACTL_PREM_F
6109 where business_group_id = p_bg_id;
6110
6111 delete from BEN_CRT_ORDR_CVRD_PER
6112 where business_group_id = p_bg_id;
6113
6114 delete from BEN_FL_TM_PT_TM_RT_F
6115 where business_group_id = p_bg_id;
6116
6117 delete from BEN_GNDR_RT_F
6118 where business_group_id = p_bg_id;
6119
6120 delete from BEN_GRADE_RT_F
6121 where business_group_id = p_bg_id;
6122
6123 delete from BEN_HRLY_SLRD_RT_F
6124 where business_group_id = p_bg_id;
6125
6126 delete from BEN_HRS_WKD_IN_PERD_RT_F
6127 where business_group_id = p_bg_id;
6128
6129 delete from BEN_LBR_MMBR_RT_F
6130 where business_group_id = p_bg_id;
6131
6132 delete from BEN_LER_BNFT_RSTRN_F
6133 where business_group_id = p_bg_id;
6134
6135 delete from BEN_LER_RQRS_ENRT_CTFN_F
6136 where business_group_id = p_bg_id;
6137
6138 delete from BEN_LER_BNFT_RSTRN_CTFN_F
6139 where business_group_id = p_bg_id;
6140
6141 delete from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
6145 where business_group_id = p_bg_id;
6142 where business_group_id = p_bg_id;
6143
6144 delete from BEN_CVG_AMT_CALC_MTHD_F
6146
6147 delete from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
6148 where business_group_id = p_bg_id;
6149
6150 delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
6151 where business_group_id = p_bg_id;
6152
6153 delete from BEN_ELIG_PER_F
6154 where business_group_id = p_bg_id;
6155
6156 delete from BEN_ENRT_ENRLD_ANTHR_OIPL_F
6157 where business_group_id = p_bg_id;
6158
6159 delete from BEN_LER_CHG_DPNT_CVG_F
6160 where business_group_id = p_bg_id;
6161
6162 delete from BEN_LER_CHG_OIPL_ENRT_F
6163 where business_group_id = p_bg_id;
6164
6165 delete from BEN_LER_CHG_PL_NIP_ENRT_F
6166 where business_group_id = p_bg_id;
6167
6168 delete from BEN_PIL_ELCTBL_CHC_POPL
6169 where business_group_id = p_bg_id;
6170
6171 delete from BEN_AGE_RT_F
6172 where business_group_id = p_bg_id;
6173
6174 delete from BEN_ASNT_SET_RT_F
6175 where business_group_id = p_bg_id;
6176
6177 delete from BEN_BENFTS_GRP_RT_F
6178 where business_group_id = p_bg_id;
6179
6180 delete from BEN_PRTT_ENRT_RSLT_F
6181 where business_group_id = p_bg_id;
6182
6183 delete from BEN_BNFT_VRBL_RT_F
6184 where business_group_id = p_bg_id;
6185
6186 delete from BEN_ELIG_CVRD_DPNT_F
6187 where business_group_id = p_bg_id;
6188
6189 delete from BEN_ELIG_PER_ELCTBL_CHC
6190 where business_group_id = p_bg_id;
6191
6192 delete from BEN_ENRT_BNFT
6193 where business_group_id = p_bg_id;
6194
6195 delete from BEN_PL_BNF_F
6196 where business_group_id = p_bg_id;
6197
6198 delete from BEN_PL_R_OIPL_PREM_BY_MO_F
6199 where business_group_id = p_bg_id;
6200
6201 delete from BEN_PRTT_PREM_F
6202 where business_group_id = p_bg_id;
6203
6204 delete from BEN_ENRT_PREM
6205 where business_group_id = p_bg_id;
6206
6207 delete from BEN_PRTN_ELIGY_RL_F
6208 where business_group_id = p_bg_id;
6209
6210 delete from BEN_ELCTBL_CHC_CTFN
6211 where business_group_id = p_bg_id;
6212
6213 delete from BEN_ACTL_PREM_VRBL_RT_RL_F
6214 where business_group_id = p_bg_id;
6215
6216 delete from BEN_BNFT_VRBL_RT_RL_F
6217 where business_group_id = p_bg_id;
6218
6219 delete from BEN_ELIG_PPL_GRP_PRTE_F
6220 where business_group_id = p_bg_id;
6221
6222 delete from BEN_PRTN_ELIG_PRFL_F
6223 where business_group_id = p_bg_id;
6224
6225 delete from BEN_WV_PRTN_RSN_CTFN_PL_F
6226 where business_group_id = p_bg_id;
6227
6228 delete from BEN_ACTL_PREM_VRBL_RT_F
6229 where business_group_id = p_bg_id;
6230
6231 delete from BEN_ELIG_PER_OPT_F
6232 where business_group_id = p_bg_id;
6233
6234 delete from BEN_ELIG_PER_WV_PL_TYP_F
6235 where business_group_id = p_bg_id;
6236
6237 delete from BEN_PL_GD_R_SVC_CTFN_F
6238 where business_group_id = p_bg_id;
6239
6240 delete from BEN_PRMRY_CARE_PRVDR_F
6241 where business_group_id = p_bg_id;
6242
6243 delete from BEN_PRTT_ENRT_ACTN_F
6244 where business_group_id = p_bg_id;
6245
6246 delete from BEN_PRTT_ENRT_CTFN_PRVDD_F
6247 where business_group_id = p_bg_id;
6248
6249 delete from BEN_ELIG_DPNT
6250 where business_group_id = p_bg_id;
6251
6252 delete from BEN_LEE_RSN_RL_F
6253 where business_group_id = p_bg_id;
6254
6255 delete from BEN_PL_REGY_PRP_F
6256 where business_group_id = p_bg_id;
6257
6258 delete from BEN_SCHEDD_ENRT_RL_F
6259 where business_group_id = p_bg_id;
6260
6261 delete from BEN_ELIG_OTHR_PTIP_PRTE_F
6262 where business_group_id = p_bg_id;
6263
6264 delete from BEN_LER_CHG_PTIP_ENRT_F
6265 where business_group_id = p_bg_id;
6266
6267 delete from BEN_LER_CHG_DPNT_CVG_CTFN_F
6268 where business_group_id = p_bg_id;
6269
6270 delete from BEN_LER_CHG_OIPL_ENRT_RL_F
6271 where business_group_id = p_bg_id;
6272
6273 delete from BEN_LER_CHG_PLIP_ENRT_F
6274 where business_group_id = p_bg_id;
6275
6276 delete from BEN_LER_ENRT_CTFN_F
6277 where business_group_id = p_bg_id;
6278
6279 delete from BEN_LER_CHG_PLIP_ENRT_RL_F
6280 where business_group_id = p_bg_id;
6281
6282 delete from BEN_LER_CHG_PL_NIP_RL_F
6283 where business_group_id = p_bg_id;
6284
6285 delete from BEN_PER_CM_F
6286 where business_group_id = p_bg_id;
6287
6288 delete from BEN_PER_CM_TRGR_F
6289 where business_group_id = p_bg_id;
6290
6291 delete from BEN_PL_BNF_CTFN_PRVDD_F
6292 where business_group_id = p_bg_id;
6293
6294 delete from BEN_PTIP_DPNT_CVG_CTFN_F
6295 where business_group_id = p_bg_id;
6296
6297 delete from BEN_WV_PRTN_RSN_PTIP_F
6298 where business_group_id = p_bg_id;
6299
6300 delete from BEN_CVRD_DPNT_CTFN_PRVDD_F
6301 where business_group_id = p_bg_id;
6302
6303 delete from BEN_PER_CM_USG_F
6304 where business_group_id = p_bg_id;
6305
6306 delete from BEN_POPL_ORG_ROLE_F
6307 where business_group_id = p_bg_id;
6308
6309 delete from BEN_ELIG_JOB_PRTE_F
6310 where business_group_id = p_bg_id;
6311
6312 delete from BEN_WV_PRTN_RSN_CTFN_PTIP_F
6313 where business_group_id = p_bg_id;
6314
6318 delete from BEN_BATCH_DPNT_INFO
6315 delete from BEN_BATCH_COMMU_INFO
6316 where business_group_id = p_bg_id;
6317
6319 where business_group_id = p_bg_id;
6320
6321 delete from BEN_BATCH_ELCTBL_CHC_INFO
6322 where business_group_id = p_bg_id;
6323
6324 delete from BEN_BATCH_ELIG_INFO
6325 where business_group_id = p_bg_id;
6326
6327 delete from BEN_BATCH_LER_INFO
6328 where business_group_id = p_bg_id;
6329
6330 delete from BEN_BATCH_RATE_INFO
6331 where business_group_id = p_bg_id;
6332
6333 delete from BEN_BENEFIT_ACTIONS
6334 where business_group_id = p_bg_id;
6335
6336 delete from BEN_CLPSE_LF_EVT_F
6337 where business_group_id = p_bg_id;
6338
6339 delete from BEN_PREM_CSTG_BY_SGMT_F
6340 where business_group_id = p_bg_id;
6341
6342 delete from BEN_BATCH_PROC_INFO
6343 where business_group_id = p_bg_id;
6344
6345 delete from BEN_PRTT_PREM_BY_MO_F
6346 where business_group_id = p_bg_id;
6347
6348 delete from BEN_PER_CM_PRVDD_F
6349 where business_group_id = p_bg_id;
6350
6351 delete from BEN_PRTT_REIMBMT_RQST_F
6352 where business_group_id = p_bg_id;
6353
6354 delete from BEN_PRTT_CLM_GD_OR_SVC_TYP
6355 where business_group_id = p_bg_id;
6356
6357 delete from BEN_ROLL_REIMB_RQST
6358 where business_group_id = p_bg_id;
6359
6360 delete from BEN_ELIG_EE_STAT_PRTE_F
6361 where business_group_id = p_bg_id;
6362
6363 delete from BEN_EE_STAT_RT_F
6364 where business_group_id = p_bg_id;
6365
6366 delete from BEN_ELIG_ASNT_SET_PRTE_F
6367 where business_group_id = p_bg_id;
6368
6369 delete from BEN_ACTY_BASE_RT_F
6370 where business_group_id = p_bg_id;
6371
6372 delete from BEN_ACTY_RT_PTD_LMT_F
6373 where business_group_id = p_bg_id;
6374
6375 delete from BEN_ACTY_RT_PYMT_SCHED_F
6376 where business_group_id = p_bg_id;
6377
6378 delete from BEN_ACTY_VRBL_RT_F
6379 where business_group_id = p_bg_id;
6380
6381 delete from BEN_APLCN_TO_BNFT_POOL_F
6382 where business_group_id = p_bg_id;
6383
6384 delete from BEN_BNFT_POOL_RLOVR_RQMT_F
6385 where business_group_id = p_bg_id;
6386
6387 delete from BEN_BNFT_PRVDD_LDGR_F
6388 where business_group_id = p_bg_id;
6389
6390 delete from BEN_COMP_LVL_ACTY_RT_F
6391 where business_group_id = p_bg_id;
6392
6393 delete from BEN_MTCHG_RT_F
6394 where business_group_id = p_bg_id;
6395
6396 delete from BEN_PAIRD_RT_F
6397 where business_group_id = p_bg_id;
6398
6399 delete from BEN_PRTL_MO_RT_PRTN_VAL_F
6400 where business_group_id = p_bg_id;
6401
6402 delete from BEN_VRBL_RT_RL_F
6403 where business_group_id = p_bg_id;
6404
6405 delete from BEN_DED_SCHED_PY_FREQ
6406 where business_group_id = p_bg_id;
6407
6408 delete from BEN_ACTY_RT_DED_SCHED_F
6409 where business_group_id = p_bg_id;
6410
6411 delete from BEN_PERD_TO_PROC
6412 where business_group_id = p_bg_id;
6413
6414 delete from BEN_PYMT_SCHED_PY_FREQ
6415 where business_group_id = p_bg_id;
6416
6417 delete from BEN_PRTT_ASSOCD_INSTN_F
6418 where business_group_id = p_bg_id;
6419
6420 delete from BEN_PRTT_RT_VAL
6421 where business_group_id = p_bg_id;
6422
6423 delete from BEN_PRTT_VSTG_F
6424 where business_group_id = p_bg_id;
6425
6426 delete from BEN_ENRT_RT
6427 where business_group_id = p_bg_id;
6428
6429 delete from BEN_PRTT_REIMBMT_RECON
6430 where business_group_id = p_bg_id;
6431
6432 delete from BEN_ELIG_LOA_RSN_PRTE_F
6433 where business_group_id = p_bg_id;
6434
6435 delete from BEN_LOA_RSN_RT_F
6436 where business_group_id = p_bg_id;
6437
6438 delete from BEN_ELIG_PY_BSS_PRTE_F
6439 where business_group_id = p_bg_id;
6440
6441 delete from BEN_PY_BSS_RT_F
6442 where business_group_id = p_bg_id;
6443
6444 delete from BEN_ELIG_ENRLD_ANTHR_OIPL_F
6445 where business_group_id = p_bg_id;
6446
6447 delete from BEN_PL_PCP
6448 where business_group_id = p_bg_id;
6449
6450 delete from BEN_PL_PCP_TYP
6451 where business_group_id = p_bg_id;
6452
6453 delete from BEN_OPTIP_F
6454 where business_group_id = p_bg_id;
6455
6456 end delete_below_bg;
6457 procedure delete_below_org(p_org_id NUMBER) is
6458 BEGIN
6459 delete from BEN_ORG_UNIT_PRDCT_F
6460 where organization_id = p_org_id;
6461
6462 delete from BEN_ELIG_LGL_ENTY_PRTE_F
6463 where organization_id = p_org_id;
6464
6465 delete from BEN_ELIG_ORG_UNIT_PRTE_F
6466 where organization_id = p_org_id;
6467
6468 delete from BEN_REGN_F
6469 where organization_id = p_org_id;
6470
6471 delete from BEN_REGN_FOR_REGY_BODY_F
6472 where organization_id = p_org_id;
6473
6474 delete from BEN_PER_IN_LGL_ENTY_F
6475 where organization_id = p_org_id;
6476
6477 delete from BEN_PER_IN_ORG_UNIT_F
6478 where organization_id = p_org_id;
6479
6480 delete from BEN_LE_CLSN_N_RSTR
6481 where organization_id = p_org_id;
6482
6483 delete from BEN_PL_REGY_BOD_F
6484 where organization_id = p_org_id;
6485
6486 delete from BEN_POPL_ORG_F
6487 where organization_id = p_org_id;
6488
6489 delete from BEN_LGL_ENTY_RT_F
6490 where organization_id = p_org_id;
6491
6492 delete from BEN_ORG_UNIT_RT_F
6493 where organization_id = p_org_id;
6494
6495 delete from BEN_ACTL_PREM_F
6496 where organization_id = p_org_id;
6497
6498 delete from BEN_PL_BNF_F
6499 where organization_id = p_org_id;
6500
6501 delete from BEN_BENEFIT_ACTIONS
6502 where organization_id = p_org_id;
6503
6504 end delete_below_org;
6505 end ben_org_delete;
[Home] [Help]