APPS.BEN_ORG_DELETE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

is select 1 from BEN_PER_INFO_CHG_CS_LER_F
where business_group_id = p_bg_id;

Line: 26

is select 1 from BEN_RLTD_PER_CHG_CS_LER_F
where business_group_id = p_bg_id;

Line: 30

is select 1 from BEN_PCT_FL_TM_FCTR
where business_group_id = p_bg_id;

Line: 34

is select 1 from BEN_AGE_FCTR
where business_group_id = p_bg_id;

Line: 38

is select 1 from BEN_BENFTS_GRP
where business_group_id = p_bg_id;

Line: 42

is select 1 from BEN_GD_OR_SVC_TYP
where business_group_id = p_bg_id;

Line: 46

is select 1 from BEN_LOS_FCTR
where business_group_id = p_bg_id;

Line: 50

is select 1 from BEN_ELIGY_PRFL_F
where business_group_id = p_bg_id;

Line: 54

is select 1 from BEN_ELIG_LVG_RSN_PRTE_F
where business_group_id = p_bg_id;

Line: 58

is select 1 from BEN_ELIG_NO_OTHR_CVG_PRTE_F
where business_group_id = p_bg_id;

Line: 62

is select 1 from BEN_ELIG_OPTD_MDCR_PRTE_F
where business_group_id = p_bg_id;

Line: 66

is select 1 from BEN_ACTN_TYP
where business_group_id = p_bg_id;

Line: 70

is select 1 from BEN_BATCH_ACTN_ITEM_INFO
where business_group_id = p_bg_id;

Line: 74

is select 1 from BEN_BATCH_PARAMETER
where business_group_id = p_bg_id;

Line: 78

is select 1 from BEN_BNFTS_BAL_F
where business_group_id = p_bg_id;

Line: 82

is select 1 from BEN_CM_TYP_F
where business_group_id = p_bg_id;

Line: 86

is select 1 from BEN_CM_TYP_TRGR_F
where business_group_id = p_bg_id;

Line: 90

is select 1 from BEN_CNTNG_PRTN_ELIG_PRFL_F
where business_group_id = p_bg_id;

Line: 94

is select 1 from BEN_COMP_ASSET
where business_group_id = p_bg_id;

Line: 98

is select 1 from BEN_CSR_ACTIVITIES
where business_group_id = p_bg_id;

Line: 102

is select 1 from BEN_ELIG_BRGNG_UNIT_PRTE_F
where business_group_id = p_bg_id;

Line: 106

is select 1 from BEN_ELIG_FL_TM_PT_TM_PRTE_F
where business_group_id = p_bg_id;

Line: 110

is select 1 from BEN_ELIG_HRLY_SLRD_PRTE_F
where business_group_id = p_bg_id;

Line: 114

is select 1 from BEN_ELIG_LBR_MMBR_PRTE_F
where business_group_id = p_bg_id;

Line: 118

is select 1 from BEN_ELIG_PER_TYP_PRTE_F
where business_group_id = p_bg_id;

Line: 122

is select 1 from BEN_ELIG_PYRL_PRTE_F
where business_group_id = p_bg_id;

Line: 126

is select 1 from BEN_ELIG_SCHEDD_HRS_PRTE_F
where business_group_id = p_bg_id;

Line: 130

is select 1 from BEN_EXT_CHG_EVT_LOG
where business_group_id = p_bg_id;

Line: 134

is select 1 from BEN_EXT_CRIT_PRFL
where business_group_id = p_bg_id;

Line: 138

is select 1 from BEN_EXT_FILE
where business_group_id = p_bg_id;

Line: 142

is select 1 from BEN_EXT_FLD
where business_group_id = p_bg_id;

Line: 146

is select 1 from BEN_EXT_RCD
where business_group_id = p_bg_id;

Line: 150

is select 1 from BEN_PIN
where business_group_id = p_bg_id;

Line: 154

is select 1 from BEN_PL_TYP_F
where business_group_id = p_bg_id;

Line: 158

is select 1 from BEN_POP_UP_MESSAGES
where business_group_id = p_bg_id;

Line: 162

is select 1 from BEN_PSTL_ZIP_RNG_F
where business_group_id = p_bg_id;

Line: 166

is select 1 from BEN_VSTG_SCHED_F
where business_group_id = p_bg_id;

Line: 170

is select 1 from BEN_YR_PERD
where business_group_id = p_bg_id;

Line: 174

is select 1 from BEN_CMBN_AGE_LOS_FCTR
where business_group_id = p_bg_id;

Line: 178

is select 1 from BEN_CM_DLVRY_MTHD_TYP
where business_group_id = p_bg_id;

Line: 182

is select 1 from BEN_CNTNU_PRTN_CTFN_TYP_F
where business_group_id = p_bg_id;

Line: 186

is select 1 from BEN_ELIGY_PRFL_RL_F
where business_group_id = p_bg_id;

Line: 190

is select 1 from BEN_ELIG_AGE_PRTE_F
where business_group_id = p_bg_id;

Line: 194

is select 1 from BEN_ELIG_BENFTS_GRP_PRTE_F
where business_group_id = p_bg_id;

Line: 198

is select 1 from BEN_ELIG_LOS_PRTE_F
where business_group_id = p_bg_id;

Line: 202

is select 1 from BEN_ELIG_PCT_FL_TM_PRTE_F
where business_group_id = p_bg_id;

Line: 206

is select 1 from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
where business_group_id = p_bg_id;

Line: 210

is select 1 from BEN_ELIG_WK_LOC_PRTE_F
where business_group_id = p_bg_id;

Line: 214

is select 1 from BEN_EXT_CRIT_TYP
where business_group_id = p_bg_id;

Line: 218

is select 1 from BEN_EXT_DFN
where business_group_id = p_bg_id;

Line: 222

is select 1 from BEN_ORG_UNIT_PRDCT_F
where business_group_id = p_bg_id;

Line: 226

is select 1 from BEN_PER_BNFTS_BAL_F
where business_group_id = p_bg_id;

Line: 230

is select 1 from BEN_PER_PIN_F
where business_group_id = p_bg_id;

Line: 234

is select 1 from BEN_VSTG_AGE_RQMT
where business_group_id = p_bg_id;

Line: 238

is select 1 from BEN_VSTG_FOR_ACTY_RT_F
where business_group_id = p_bg_id;

Line: 242

is select 1 from BEN_WTHN_YR_PERD
where business_group_id = p_bg_id;

Line: 246

is select 1 from BEN_CM_DLVRY_MED_TYP
where business_group_id = p_bg_id;

Line: 250

is select 1 from BEN_ELIG_SVC_AREA_PRTE_F
where business_group_id = p_bg_id;

Line: 254

is select 1 from BEN_EXT_CRIT_VAL
where business_group_id = p_bg_id;

Line: 258

is select 1 from BEN_EXT_DATA_ELMT
where business_group_id = p_bg_id;

Line: 262

is select 1 from BEN_EXT_RSLT
where business_group_id = p_bg_id;

Line: 266

is select 1 from BEN_SVC_AREA_F
where business_group_id = p_bg_id;

Line: 270

is select 1 from BEN_VSTG_LOS_RQMT
where business_group_id = p_bg_id;

Line: 274

is select 1 from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
where business_group_id = p_bg_id;

Line: 278

is select 1 from BEN_EXT_CRIT_CMBN
where business_group_id = p_bg_id;

Line: 282

is select 1 from BEN_EXT_DATA_ELMT_DECD
where business_group_id = p_bg_id;

Line: 286

is select 1 from BEN_EXT_DATA_ELMT_IN_RCD
where business_group_id = p_bg_id;

Line: 290

is select 1 from BEN_EXT_RSLT_DTL
where business_group_id = p_bg_id;

Line: 294

is select 1 from BEN_SVC_AREA_PSTL_ZIP_RNG_F
where business_group_id = p_bg_id;

Line: 298

is select 1 from BEN_COMP_LVL_FCTR
where business_group_id = p_bg_id;

Line: 302

is select 1 from BEN_ELIG_LGL_ENTY_PRTE_F
where business_group_id = p_bg_id;

Line: 306

is select 1 from BEN_ELIG_ORG_UNIT_PRTE_F
where business_group_id = p_bg_id;

Line: 310

is select 1 from BEN_EXT_RSLT_ERR
where business_group_id = p_bg_id;

Line: 314

is select 1 from BEN_REGN_F
where business_group_id = p_bg_id;

Line: 318

is select 1 from BEN_EXT_INCL_DATA_ELMT
where business_group_id = p_bg_id;

Line: 322

is select 1 from BEN_EXT_RCD_IN_FILE
where business_group_id = p_bg_id;

Line: 326

is select 1 from BEN_REGN_FOR_REGY_BODY_F
where business_group_id = p_bg_id;

Line: 330

is select 1 from BEN_EXT_INCL_CHG
where business_group_id = p_bg_id;

Line: 334

is select 1 from BEN_EXT_WHERE_CLAUSE
where business_group_id = p_bg_id;

Line: 338

is select 1 from BEN_RPTG_GRP
where business_group_id = p_bg_id;

Line: 342

is select 1 from BEN_DPNT_CVG_ELIGY_PRFL_F
where business_group_id = p_bg_id;

Line: 346

is select 1 from BEN_HRS_WKD_IN_PERD_FCTR
where business_group_id = p_bg_id;

Line: 350

is select 1 from BEN_DPNT_CVG_RQD_RLSHP_F
where business_group_id = p_bg_id;

Line: 354

is select 1 from BEN_DSGNTR_ENRLD_CVG_F
where business_group_id = p_bg_id;

Line: 358

is select 1 from BEN_ELIG_COMP_LVL_PRTE_F
where business_group_id = p_bg_id;

Line: 362

is select 1 from BEN_ELIG_DSBLD_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 366

is select 1 from BEN_ELIG_HRS_WKD_PRTE_F
where business_group_id = p_bg_id;

Line: 370

is select 1 from BEN_ELIG_MLTRY_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 374

is select 1 from BEN_ELIG_MRTL_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 378

is select 1 from BEN_ELIG_STDNT_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 382

is select 1 from BEN_ELIG_AGE_CVG_F
where business_group_id = p_bg_id;

Line: 386

is select 1 from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
where business_group_id = p_bg_id;

Line: 390

is select 1 from BEN_PTD_LMT_F
where business_group_id = p_bg_id;

Line: 394

is select 1 from BEN_PTD_BAL_TYP_F
where business_group_id = p_bg_id;

Line: 398

is select 1 from BEN_ELIG_GRD_PRTE_F
where business_group_id = p_bg_id;

Line: 402

is select 1 from BEN_PER_DLVRY_MTHD_F
where business_group_id = p_bg_id;

Line: 406

is select 1 from BEN_PER_IN_LGL_ENTY_F
where business_group_id = p_bg_id;

Line: 410

is select 1 from BEN_PER_IN_ORG_UNIT_F
where business_group_id = p_bg_id;

Line: 414

is select 1 from BEN_PER_IN_ORG_ROLE_F
where business_group_id = p_bg_id;

Line: 418

is select 1 from BEN_ACRS_PTIP_CVG_F
where business_group_id = p_bg_id;

Line: 422

is select 1 from BEN_PL_TYP_OPT_TYP_F
where business_group_id = p_bg_id;

Line: 426

is select 1 from BEN_ENRT_PERD
where business_group_id = p_bg_id;

Line: 430

is select 1 from BEN_OPT_F
where business_group_id = p_bg_id;

Line: 434

is select 1 from BEN_LER_F
where business_group_id = p_bg_id;

Line: 438

is select 1 from BEN_LER_RLTD_PER_CS_LER_F
where business_group_id = p_bg_id;

Line: 442

is select 1 from BEN_CBR_PER_IN_LER
where business_group_id = p_bg_id;

Line: 446

is select 1 from BEN_CSS_RLTD_PER_PER_IN_LER_F
where business_group_id = p_bg_id;

Line: 450

is select 1 from BEN_LER_PER_INFO_CS_LER_F
where business_group_id = p_bg_id;

Line: 454

is select 1 from BEN_LE_CLSN_N_RSTR
where business_group_id = p_bg_id;

Line: 458

is select 1 from BEN_PER_IN_LER
where business_group_id = p_bg_id;

Line: 462

is select 1 from BEN_PTNL_LER_FOR_PER
where business_group_id = p_bg_id;

Line: 466

is select 1 from BEN_PGM_F
where business_group_id = p_bg_id;

Line: 470

is select 1 from BEN_ELIG_ENRLD_ANTHR_PGM_F
where business_group_id = p_bg_id;

Line: 474

is select 1 from BEN_ELIG_PRTT_ANTHR_PGM_F
where business_group_id = p_bg_id;

Line: 478

is select 1 from BEN_PLIP_F
where business_group_id = p_bg_id;

Line: 482

is select 1 from BEN_PL_F
where business_group_id = p_bg_id;

Line: 486

is select 1 from BEN_PTIP_F
where business_group_id = p_bg_id;

Line: 490

is select 1 from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
where business_group_id = p_bg_id;

Line: 494

is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
where business_group_id = p_bg_id;

Line: 498

is select 1 from BEN_ELIG_ENRLD_ANTHR_PL_F
where business_group_id = p_bg_id;

Line: 502

is select 1 from BEN_ENRT_ENRLD_ANTHR_PL_F
where business_group_id = p_bg_id;

Line: 506

is select 1 from BEN_OIPLIP_F
where business_group_id = p_bg_id;

Line: 510

is select 1 from BEN_OIPL_F
where business_group_id = p_bg_id;

Line: 514

is select 1 from BEN_PGM_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 518

is select 1 from BEN_BNFT_PRVDR_POOL_F
where business_group_id = p_bg_id;

Line: 522

is select 1 from BEN_CMBN_PLIP_F
where business_group_id = p_bg_id;

Line: 526

is select 1 from BEN_CMBN_PTIP_F
where business_group_id = p_bg_id;

Line: 530

is select 1 from BEN_CMBN_PTIP_OPT_F
where business_group_id = p_bg_id;

Line: 534

is select 1 from BEN_CM_TYP_USG_F
where business_group_id = p_bg_id;

Line: 538

is select 1 from BEN_DSGN_RQMT_F
where business_group_id = p_bg_id;

Line: 542

is select 1 from BEN_ELIG_TO_PRTE_RSN_F
where business_group_id = p_bg_id;

Line: 546

is select 1 from BEN_LER_CHG_PGM_ENRT_F
where business_group_id = p_bg_id;

Line: 550

is select 1 from BEN_PL_BNF_CTFN_F
where business_group_id = p_bg_id;

Line: 554

is select 1 from BEN_PL_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 558

is select 1 from BEN_PL_GD_OR_SVC_F
where business_group_id = p_bg_id;

Line: 562

is select 1 from BEN_PL_REGN_F
where business_group_id = p_bg_id;

Line: 566

is select 1 from BEN_PL_REGY_BOD_F
where business_group_id = p_bg_id;

Line: 570

is select 1 from BEN_POPL_ACTN_TYP_F
where business_group_id = p_bg_id;

Line: 574

is select 1 from BEN_POPL_ENRT_TYP_CYCL_F
where business_group_id = p_bg_id;

Line: 578

is select 1 from BEN_POPL_ORG_F
where business_group_id = p_bg_id;

Line: 582

is select 1 from BEN_WV_PRTN_RSN_PL_F
where business_group_id = p_bg_id;

Line: 586

is select 1 from BEN_CRT_ORDR
where business_group_id = p_bg_id;

Line: 590

is select 1 from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
where business_group_id = p_bg_id;

Line: 594

is select 1 from BEN_ENRT_CTFN_F
where business_group_id = p_bg_id;

Line: 598

is select 1 from BEN_LEE_RSN_F
where business_group_id = p_bg_id;

Line: 602

is select 1 from BEN_PL_R_OIPL_ASSET_F
where business_group_id = p_bg_id;

Line: 606

is select 1 from BEN_POPL_RPTG_GRP_F
where business_group_id = p_bg_id;

Line: 610

is select 1 from BEN_POPL_YR_PERD
where business_group_id = p_bg_id;

Line: 614

is select 1 from BEN_PRTN_ELIG_F
where business_group_id = p_bg_id;

Line: 618

is select 1 from BEN_VALD_RLSHP_FOR_REIMB_F
where business_group_id = p_bg_id;

Line: 622

is select 1 from BEN_VRBL_RT_PRFL_F
where business_group_id = p_bg_id;

Line: 626

is select 1 from BEN_BNFT_RSTRN_CTFN_F
where business_group_id = p_bg_id;

Line: 630

is select 1 from BEN_BRGNG_UNIT_RT_F
where business_group_id = p_bg_id;

Line: 634

is select 1 from BEN_CMBN_AGE_LOS_RT_F
where business_group_id = p_bg_id;

Line: 638

is select 1 from BEN_COMP_LVL_RT_F
where business_group_id = p_bg_id;

Line: 642

is select 1 from BEN_DSGN_RQMT_RLSHP_TYP
where business_group_id = p_bg_id;

Line: 646

is select 1 from BEN_ENRT_PERD_FOR_PL_F
where business_group_id = p_bg_id;

Line: 650

is select 1 from BEN_LGL_ENTY_RT_F
where business_group_id = p_bg_id;

Line: 654

is select 1 from BEN_LOS_RT_F
where business_group_id = p_bg_id;

Line: 658

is select 1 from BEN_ORG_UNIT_RT_F
where business_group_id = p_bg_id;

Line: 662

is select 1 from BEN_PCT_FL_TM_RT_F
where business_group_id = p_bg_id;

Line: 666

is select 1 from BEN_PER_TYP_RT_F
where business_group_id = p_bg_id;

Line: 670

is select 1 from BEN_PPL_GRP_RT_F
where business_group_id = p_bg_id;

Line: 674

is select 1 from BEN_PSTL_ZIP_RT_F
where business_group_id = p_bg_id;

Line: 678

is select 1 from BEN_PYRL_RT_F
where business_group_id = p_bg_id;

Line: 682

is select 1 from BEN_SCHEDD_HRS_RT_F
where business_group_id = p_bg_id;

Line: 686

is select 1 from BEN_SVC_AREA_RT_F
where business_group_id = p_bg_id;

Line: 690

is select 1 from BEN_TBCO_USE_RT_F
where business_group_id = p_bg_id;

Line: 694

is select 1 from BEN_TTL_CVG_VOL_RT_F
where business_group_id = p_bg_id;

Line: 698

is select 1 from BEN_TTL_PRTT_RT_F
where business_group_id = p_bg_id;

Line: 702

is select 1 from BEN_VRBL_MTCHG_RT_F
where business_group_id = p_bg_id;

Line: 706

is select 1 from BEN_VRBL_RT_PRFL_RL_F
where business_group_id = p_bg_id;

Line: 710

is select 1 from BEN_WK_LOC_RT_F
where business_group_id = p_bg_id;

Line: 714

is select 1 from BEN_ACTL_PREM_F
where business_group_id = p_bg_id;

Line: 718

is select 1 from BEN_CRT_ORDR_CVRD_PER
where business_group_id = p_bg_id;

Line: 722

is select 1 from BEN_FL_TM_PT_TM_RT_F
where business_group_id = p_bg_id;

Line: 726

is select 1 from BEN_GNDR_RT_F
where business_group_id = p_bg_id;

Line: 730

is select 1 from BEN_GRADE_RT_F
where business_group_id = p_bg_id;

Line: 734

is select 1 from BEN_HRLY_SLRD_RT_F
where business_group_id = p_bg_id;

Line: 738

is select 1 from BEN_HRS_WKD_IN_PERD_RT_F
where business_group_id = p_bg_id;

Line: 742

is select 1 from BEN_LBR_MMBR_RT_F
where business_group_id = p_bg_id;

Line: 746

is select 1 from BEN_LER_BNFT_RSTRN_F
where business_group_id = p_bg_id;

Line: 750

is select 1 from BEN_LER_RQRS_ENRT_CTFN_F
where business_group_id = p_bg_id;

Line: 754

is select 1 from BEN_LER_BNFT_RSTRN_CTFN_F
where business_group_id = p_bg_id;

Line: 758

is select 1 from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
where business_group_id = p_bg_id;

Line: 762

is select 1 from BEN_CVG_AMT_CALC_MTHD_F
where business_group_id = p_bg_id;

Line: 766

is select 1 from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
where business_group_id = p_bg_id;

Line: 770

is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
where business_group_id = p_bg_id;

Line: 774

is select 1 from BEN_ELIG_PER_F
where business_group_id = p_bg_id;

Line: 778

is select 1 from BEN_ENRT_ENRLD_ANTHR_OIPL_F
where business_group_id = p_bg_id;

Line: 782

is select 1 from BEN_LER_CHG_DPNT_CVG_F
where business_group_id = p_bg_id;

Line: 786

is select 1 from BEN_LER_CHG_OIPL_ENRT_F
where business_group_id = p_bg_id;

Line: 790

is select 1 from BEN_LER_CHG_PL_NIP_ENRT_F
where business_group_id = p_bg_id;

Line: 794

is select 1 from BEN_PIL_ELCTBL_CHC_POPL
where business_group_id = p_bg_id;

Line: 798

is select 1 from BEN_AGE_RT_F
where business_group_id = p_bg_id;

Line: 802

is select 1 from BEN_ASNT_SET_RT_F
where business_group_id = p_bg_id;

Line: 806

is select 1 from BEN_BENFTS_GRP_RT_F
where business_group_id = p_bg_id;

Line: 810

is select 1 from BEN_PRTT_ENRT_RSLT_F
where business_group_id = p_bg_id;

Line: 814

is select 1 from BEN_BNFT_VRBL_RT_F
where business_group_id = p_bg_id;

Line: 818

is select 1 from BEN_ELIG_CVRD_DPNT_F
where business_group_id = p_bg_id;

Line: 822

is select 1 from BEN_ELIG_PER_ELCTBL_CHC
where business_group_id = p_bg_id;

Line: 826

is select 1 from BEN_ENRT_BNFT
where business_group_id = p_bg_id;

Line: 830

is select 1 from BEN_PL_BNF_F
where business_group_id = p_bg_id;

Line: 834

is select 1 from BEN_PL_R_OIPL_PREM_BY_MO_F
where business_group_id = p_bg_id;

Line: 838

is select 1 from BEN_PRTT_PREM_F
where business_group_id = p_bg_id;

Line: 842

is select 1 from BEN_ENRT_PREM
where business_group_id = p_bg_id;

Line: 846

is select 1 from BEN_PRTN_ELIGY_RL_F
where business_group_id = p_bg_id;

Line: 850

is select 1 from BEN_ELCTBL_CHC_CTFN
where business_group_id = p_bg_id;

Line: 854

is select 1 from BEN_ACTL_PREM_VRBL_RT_RL_F
where business_group_id = p_bg_id;

Line: 858

is select 1 from BEN_BNFT_VRBL_RT_RL_F
where business_group_id = p_bg_id;

Line: 862

is select 1 from BEN_ELIG_PPL_GRP_PRTE_F
where business_group_id = p_bg_id;

Line: 866

is select 1 from BEN_PRTN_ELIG_PRFL_F
where business_group_id = p_bg_id;

Line: 870

is select 1 from BEN_WV_PRTN_RSN_CTFN_PL_F
where business_group_id = p_bg_id;

Line: 874

is select 1 from BEN_ACTL_PREM_VRBL_RT_F
where business_group_id = p_bg_id;

Line: 878

is select 1 from BEN_ELIG_PER_OPT_F
where business_group_id = p_bg_id;

Line: 882

is select 1 from BEN_ELIG_PER_WV_PL_TYP_F
where business_group_id = p_bg_id;

Line: 886

is select 1 from BEN_PL_GD_R_SVC_CTFN_F
where business_group_id = p_bg_id;

Line: 890

is select 1 from BEN_PRMRY_CARE_PRVDR_F
where business_group_id = p_bg_id;

Line: 894

is select 1 from BEN_PRTT_ENRT_ACTN_F
where business_group_id = p_bg_id;

Line: 898

is select 1 from BEN_PRTT_ENRT_CTFN_PRVDD_F
where business_group_id = p_bg_id;

Line: 902

is select 1 from BEN_ELIG_DPNT
where business_group_id = p_bg_id;

Line: 906

is select 1 from BEN_LEE_RSN_RL_F
where business_group_id = p_bg_id;

Line: 910

is select 1 from BEN_PL_REGY_PRP_F
where business_group_id = p_bg_id;

Line: 914

is select 1 from BEN_SCHEDD_ENRT_RL_F
where business_group_id = p_bg_id;

Line: 918

is select 1 from BEN_ELIG_OTHR_PTIP_PRTE_F
where business_group_id = p_bg_id;

Line: 922

is select 1 from BEN_LER_CHG_PTIP_ENRT_F
where business_group_id = p_bg_id;

Line: 926

is select 1 from BEN_LER_CHG_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 930

is select 1 from BEN_LER_CHG_OIPL_ENRT_RL_F
where business_group_id = p_bg_id;

Line: 934

is select 1 from BEN_LER_CHG_PLIP_ENRT_F
where business_group_id = p_bg_id;

Line: 938

is select 1 from BEN_LER_ENRT_CTFN_F
where business_group_id = p_bg_id;

Line: 942

is select 1 from BEN_LER_CHG_PLIP_ENRT_RL_F
where business_group_id = p_bg_id;

Line: 946

is select 1 from BEN_LER_CHG_PL_NIP_RL_F
where business_group_id = p_bg_id;

Line: 950

is select 1 from BEN_PER_CM_F
where business_group_id = p_bg_id;

Line: 954

is select 1 from BEN_PER_CM_TRGR_F
where business_group_id = p_bg_id;

Line: 958

is select 1 from BEN_PL_BNF_CTFN_PRVDD_F
where business_group_id = p_bg_id;

Line: 962

is select 1 from BEN_PTIP_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 966

is select 1 from BEN_WV_PRTN_RSN_PTIP_F
where business_group_id = p_bg_id;

Line: 970

is select 1 from BEN_CVRD_DPNT_CTFN_PRVDD_F
where business_group_id = p_bg_id;

Line: 974

is select 1 from BEN_PER_CM_USG_F
where business_group_id = p_bg_id;

Line: 978

is select 1 from BEN_POPL_ORG_ROLE_F
where business_group_id = p_bg_id;

Line: 982

is select 1 from BEN_ELIG_JOB_PRTE_F
where business_group_id = p_bg_id;

Line: 986

is select 1 from BEN_WV_PRTN_RSN_CTFN_PTIP_F
where business_group_id = p_bg_id;

Line: 990

is select 1 from BEN_BATCH_COMMU_INFO
where business_group_id = p_bg_id;

Line: 994

is select 1 from BEN_BATCH_DPNT_INFO
where business_group_id = p_bg_id;

Line: 998

is select 1 from BEN_BATCH_ELCTBL_CHC_INFO
where business_group_id = p_bg_id;

Line: 1002

is select 1 from BEN_BATCH_ELIG_INFO
where business_group_id = p_bg_id;

Line: 1006

is select 1 from BEN_BATCH_LER_INFO
where business_group_id = p_bg_id;

Line: 1010

is select 1 from BEN_BATCH_RATE_INFO
where business_group_id = p_bg_id;

Line: 1014

is select 1 from BEN_BENEFIT_ACTIONS
where business_group_id = p_bg_id;

Line: 1018

is select 1 from BEN_CLPSE_LF_EVT_F
where business_group_id = p_bg_id;

Line: 1022

is select 1 from BEN_PREM_CSTG_BY_SGMT_F
where business_group_id = p_bg_id;

Line: 1026

is select 1 from BEN_BATCH_PROC_INFO
where business_group_id = p_bg_id;

Line: 1030

is select 1 from BEN_PRTT_PREM_BY_MO_F
where business_group_id = p_bg_id;

Line: 1034

is select 1 from BEN_PER_CM_PRVDD_F
where business_group_id = p_bg_id;

Line: 1038

is select 1 from BEN_PRTT_REIMBMT_RQST_F
where business_group_id = p_bg_id;

Line: 1042

is select 1 from BEN_PRTT_CLM_GD_OR_SVC_TYP
where business_group_id = p_bg_id;

Line: 1046

is select 1 from BEN_ROLL_REIMB_RQST
where business_group_id = p_bg_id;

Line: 1050

is select 1 from BEN_ELIG_EE_STAT_PRTE_F
where business_group_id = p_bg_id;

Line: 1054

is select 1 from BEN_EE_STAT_RT_F
where business_group_id = p_bg_id;

Line: 1058

is select 1 from BEN_ELIG_ASNT_SET_PRTE_F
where business_group_id = p_bg_id;

Line: 1062

is select 1 from BEN_ACTY_BASE_RT_F
where business_group_id = p_bg_id;

Line: 1066

is select 1 from BEN_ACTY_RT_PTD_LMT_F
where business_group_id = p_bg_id;

Line: 1070

is select 1 from BEN_ACTY_RT_PYMT_SCHED_F
where business_group_id = p_bg_id;

Line: 1074

is select 1 from BEN_ACTY_VRBL_RT_F
where business_group_id = p_bg_id;

Line: 1078

is select 1 from BEN_APLCN_TO_BNFT_POOL_F
where business_group_id = p_bg_id;

Line: 1082

is select 1 from BEN_BNFT_POOL_RLOVR_RQMT_F
where business_group_id = p_bg_id;

Line: 1086

is select 1 from BEN_BNFT_PRVDD_LDGR_F
where business_group_id = p_bg_id;

Line: 1090

is select 1 from BEN_COMP_LVL_ACTY_RT_F
where business_group_id = p_bg_id;

Line: 1094

is select 1 from BEN_MTCHG_RT_F
where business_group_id = p_bg_id;

Line: 1098

is select 1 from BEN_PAIRD_RT_F
where business_group_id = p_bg_id;

Line: 1102

is select 1 from BEN_PRTL_MO_RT_PRTN_VAL_F
where business_group_id = p_bg_id;

Line: 1106

is select 1 from BEN_VRBL_RT_RL_F
where business_group_id = p_bg_id;

Line: 1110

is select 1 from BEN_DED_SCHED_PY_FREQ
where business_group_id = p_bg_id;

Line: 1114

is select 1 from BEN_ACTY_RT_DED_SCHED_F
where business_group_id = p_bg_id;

Line: 1118

is select 1 from BEN_PERD_TO_PROC
where business_group_id = p_bg_id;

Line: 1122

is select 1 from BEN_PYMT_SCHED_PY_FREQ
where business_group_id = p_bg_id;

Line: 1126

is select 1 from BEN_PRTT_ASSOCD_INSTN_F
where business_group_id = p_bg_id;

Line: 1130

is select 1 from BEN_PRTT_RT_VAL
where business_group_id = p_bg_id;

Line: 1134

is select 1 from BEN_PRTT_VSTG_F
where business_group_id = p_bg_id;

Line: 1138

is select 1 from BEN_ENRT_RT
where business_group_id = p_bg_id;

Line: 1142

is select 1 from BEN_PRTT_REIMBMT_RECON
where business_group_id = p_bg_id;

Line: 1146

is select 1 from BEN_ELIG_LOA_RSN_PRTE_F
where business_group_id = p_bg_id;

Line: 1150

is select 1 from BEN_LOA_RSN_RT_F
where business_group_id = p_bg_id;

Line: 1154

is select 1 from BEN_ELIG_PY_BSS_PRTE_F
where business_group_id = p_bg_id;

Line: 1158

is select 1 from BEN_PY_BSS_RT_F
where business_group_id = p_bg_id;

Line: 1162

is select 1 from BEN_ELIG_ENRLD_ANTHR_OIPL_F
where business_group_id = p_bg_id;

Line: 1166

is select 1 from BEN_PL_PCP
where business_group_id = p_bg_id;

Line: 1170

is select 1 from BEN_PL_PCP_TYP
where business_group_id = p_bg_id;

Line: 1174

is select 1 from BEN_OPTIP_F
where business_group_id = p_bg_id;

Line: 5575

procedure delete_below_bg(p_bg_id NUMBER) is
BEGIN
delete from BEN_CBR_QUALD_BNF
where business_group_id = p_bg_id;

Line: 5583

delete from BEN_PER_INFO_CHG_CS_LER_F
where business_group_id = p_bg_id;

Line: 5592

delete from BEN_RLTD_PER_CHG_CS_LER_F
where business_group_id = p_bg_id;

Line: 5595

delete from BEN_PCT_FL_TM_FCTR
where business_group_id = p_bg_id;

Line: 5598

delete from BEN_AGE_FCTR
where business_group_id = p_bg_id;

Line: 5601

delete from BEN_BENFTS_GRP
where business_group_id = p_bg_id;

Line: 5604

delete from BEN_GD_OR_SVC_TYP
where business_group_id = p_bg_id;

Line: 5607

delete from BEN_LOS_FCTR
where business_group_id = p_bg_id;

Line: 5610

delete from BEN_ELIGY_PRFL_F
where business_group_id = p_bg_id;

Line: 5613

delete from BEN_ELIG_LVG_RSN_PRTE_F
where business_group_id = p_bg_id;

Line: 5616

delete from BEN_ELIG_NO_OTHR_CVG_PRTE_F
where business_group_id = p_bg_id;

Line: 5619

delete from BEN_ELIG_OPTD_MDCR_PRTE_F
where business_group_id = p_bg_id;

Line: 5622

delete from BEN_ACTN_TYP
where business_group_id = p_bg_id;

Line: 5625

delete from BEN_BATCH_ACTN_ITEM_INFO
where business_group_id = p_bg_id;

Line: 5628

delete from BEN_BATCH_PARAMETER
where business_group_id = p_bg_id;

Line: 5631

delete from BEN_BNFTS_BAL_F
where business_group_id = p_bg_id;

Line: 5634

delete from BEN_CM_TYP_F
where business_group_id = p_bg_id;

Line: 5637

delete from BEN_CM_TYP_TRGR_F
where business_group_id = p_bg_id;

Line: 5640

delete from BEN_CNTNG_PRTN_ELIG_PRFL_F
where business_group_id = p_bg_id;

Line: 5643

delete from BEN_COMP_ASSET
where business_group_id = p_bg_id;

Line: 5646

delete from BEN_CSR_ACTIVITIES
where business_group_id = p_bg_id;

Line: 5649

delete from BEN_ELIG_BRGNG_UNIT_PRTE_F
where business_group_id = p_bg_id;

Line: 5652

delete from BEN_ELIG_FL_TM_PT_TM_PRTE_F
where business_group_id = p_bg_id;

Line: 5655

delete from BEN_ELIG_HRLY_SLRD_PRTE_F
where business_group_id = p_bg_id;

Line: 5658

delete from BEN_ELIG_LBR_MMBR_PRTE_F
where business_group_id = p_bg_id;

Line: 5661

delete from BEN_ELIG_PER_TYP_PRTE_F
where business_group_id = p_bg_id;

Line: 5664

delete from BEN_ELIG_PYRL_PRTE_F
where business_group_id = p_bg_id;

Line: 5667

delete from BEN_ELIG_SCHEDD_HRS_PRTE_F
where business_group_id = p_bg_id;

Line: 5670

delete from BEN_EXT_CHG_EVT_LOG
where business_group_id = p_bg_id;

Line: 5673

delete from BEN_EXT_CRIT_PRFL
where business_group_id = p_bg_id;

Line: 5676

delete from BEN_EXT_FILE
where business_group_id = p_bg_id;

Line: 5679

delete from BEN_EXT_FLD
where business_group_id = p_bg_id;

Line: 5682

delete from BEN_EXT_RCD
where business_group_id = p_bg_id;

Line: 5685

delete from BEN_PIN
where business_group_id = p_bg_id;

Line: 5688

delete from BEN_PL_TYP_F
where business_group_id = p_bg_id;

Line: 5691

delete from BEN_POP_UP_MESSAGES
where business_group_id = p_bg_id;

Line: 5694

delete from BEN_PSTL_ZIP_RNG_F
where business_group_id = p_bg_id;

Line: 5697

delete from BEN_VSTG_SCHED_F
where business_group_id = p_bg_id;

Line: 5700

delete from BEN_YR_PERD
where business_group_id = p_bg_id;

Line: 5703

delete from BEN_CMBN_AGE_LOS_FCTR
where business_group_id = p_bg_id;

Line: 5706

delete from BEN_CM_DLVRY_MTHD_TYP
where business_group_id = p_bg_id;

Line: 5709

delete from BEN_CNTNU_PRTN_CTFN_TYP_F
where business_group_id = p_bg_id;

Line: 5712

delete from BEN_ELIGY_PRFL_RL_F
where business_group_id = p_bg_id;

Line: 5715

delete from BEN_ELIG_AGE_PRTE_F
where business_group_id = p_bg_id;

Line: 5718

delete from BEN_ELIG_BENFTS_GRP_PRTE_F
where business_group_id = p_bg_id;

Line: 5721

delete from BEN_ELIG_LOS_PRTE_F
where business_group_id = p_bg_id;

Line: 5724

delete from BEN_ELIG_PCT_FL_TM_PRTE_F
where business_group_id = p_bg_id;

Line: 5727

delete from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
where business_group_id = p_bg_id;

Line: 5730

delete from BEN_ELIG_WK_LOC_PRTE_F
where business_group_id = p_bg_id;

Line: 5733

delete from BEN_EXT_CRIT_TYP
where business_group_id = p_bg_id;

Line: 5736

delete from BEN_EXT_DFN
where business_group_id = p_bg_id;

Line: 5739

delete from BEN_ORG_UNIT_PRDCT_F
where business_group_id = p_bg_id;

Line: 5742

delete from BEN_PER_BNFTS_BAL_F
where business_group_id = p_bg_id;

Line: 5745

delete from BEN_PER_PIN_F
where business_group_id = p_bg_id;

Line: 5748

delete from BEN_VSTG_AGE_RQMT
where business_group_id = p_bg_id;

Line: 5751

delete from BEN_VSTG_FOR_ACTY_RT_F
where business_group_id = p_bg_id;

Line: 5754

delete from BEN_WTHN_YR_PERD
where business_group_id = p_bg_id;

Line: 5757

delete from BEN_CM_DLVRY_MED_TYP
where business_group_id = p_bg_id;

Line: 5760

delete from BEN_ELIG_SVC_AREA_PRTE_F
where business_group_id = p_bg_id;

Line: 5763

delete from BEN_EXT_CRIT_VAL
where business_group_id = p_bg_id;

Line: 5766

delete from BEN_EXT_DATA_ELMT
where business_group_id = p_bg_id;

Line: 5769

delete from BEN_EXT_RSLT
where business_group_id = p_bg_id;

Line: 5772

delete from BEN_SVC_AREA_F
where business_group_id = p_bg_id;

Line: 5775

delete from BEN_VSTG_LOS_RQMT
where business_group_id = p_bg_id;

Line: 5778

delete from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
where business_group_id = p_bg_id;

Line: 5781

delete from BEN_EXT_CRIT_CMBN
where business_group_id = p_bg_id;

Line: 5784

delete from BEN_EXT_DATA_ELMT_DECD
where business_group_id = p_bg_id;

Line: 5787

delete from BEN_EXT_DATA_ELMT_IN_RCD
where business_group_id = p_bg_id;

Line: 5790

delete from BEN_EXT_RSLT_DTL
where business_group_id = p_bg_id;

Line: 5793

delete from BEN_SVC_AREA_PSTL_ZIP_RNG_F
where business_group_id = p_bg_id;

Line: 5796

delete from BEN_COMP_LVL_FCTR
where business_group_id = p_bg_id;

Line: 5799

delete from BEN_ELIG_LGL_ENTY_PRTE_F
where business_group_id = p_bg_id;

Line: 5802

delete from BEN_ELIG_ORG_UNIT_PRTE_F
where business_group_id = p_bg_id;

Line: 5805

delete from BEN_EXT_RSLT_ERR
where business_group_id = p_bg_id;

Line: 5808

delete from BEN_REGN_F
where business_group_id = p_bg_id;

Line: 5811

delete from BEN_EXT_INCL_DATA_ELMT
where business_group_id = p_bg_id;

Line: 5814

delete from BEN_EXT_RCD_IN_FILE
where business_group_id = p_bg_id;

Line: 5817

delete from BEN_REGN_FOR_REGY_BODY_F
where business_group_id = p_bg_id;

Line: 5820

delete from BEN_EXT_INCL_CHG
where business_group_id = p_bg_id;

Line: 5823

delete from BEN_EXT_WHERE_CLAUSE
where business_group_id = p_bg_id;

Line: 5826

delete from BEN_RPTG_GRP
where business_group_id = p_bg_id;

Line: 5829

delete from BEN_DPNT_CVG_ELIGY_PRFL_F
where business_group_id = p_bg_id;

Line: 5832

delete from BEN_HRS_WKD_IN_PERD_FCTR
where business_group_id = p_bg_id;

Line: 5835

delete from BEN_DPNT_CVG_RQD_RLSHP_F
where business_group_id = p_bg_id;

Line: 5838

delete from BEN_DSGNTR_ENRLD_CVG_F
where business_group_id = p_bg_id;

Line: 5841

delete from BEN_ELIG_COMP_LVL_PRTE_F
where business_group_id = p_bg_id;

Line: 5844

delete from BEN_ELIG_DSBLD_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 5847

delete from BEN_ELIG_HRS_WKD_PRTE_F
where business_group_id = p_bg_id;

Line: 5850

delete from BEN_ELIG_MLTRY_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 5853

delete from BEN_ELIG_MRTL_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 5856

delete from BEN_ELIG_STDNT_STAT_CVG_F
where business_group_id = p_bg_id;

Line: 5859

delete from BEN_ELIG_AGE_CVG_F
where business_group_id = p_bg_id;

Line: 5862

delete from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
where business_group_id = p_bg_id;

Line: 5865

delete from BEN_PTD_LMT_F
where business_group_id = p_bg_id;

Line: 5868

delete from BEN_PTD_BAL_TYP_F
where business_group_id = p_bg_id;

Line: 5871

delete from BEN_ELIG_GRD_PRTE_F
where business_group_id = p_bg_id;

Line: 5874

delete from BEN_PER_DLVRY_MTHD_F
where business_group_id = p_bg_id;

Line: 5877

delete from BEN_PER_IN_LGL_ENTY_F
where business_group_id = p_bg_id;

Line: 5880

delete from BEN_PER_IN_ORG_UNIT_F
where business_group_id = p_bg_id;

Line: 5883

delete from BEN_PER_IN_ORG_ROLE_F
where business_group_id = p_bg_id;

Line: 5886

delete from BEN_ACRS_PTIP_CVG_F
where business_group_id = p_bg_id;

Line: 5889

delete from BEN_PL_TYP_OPT_TYP_F
where business_group_id = p_bg_id;

Line: 5892

delete from BEN_ENRT_PERD
where business_group_id = p_bg_id;

Line: 5895

delete from BEN_OPT_F
where business_group_id = p_bg_id;

Line: 5898

delete from BEN_LER_F
where business_group_id = p_bg_id;

Line: 5901

delete from BEN_LER_RLTD_PER_CS_LER_F
where business_group_id = p_bg_id;

Line: 5904

delete from BEN_CBR_PER_IN_LER
where business_group_id = p_bg_id;

Line: 5907

delete from BEN_CSS_RLTD_PER_PER_IN_LER_F
where business_group_id = p_bg_id;

Line: 5910

delete from BEN_LER_PER_INFO_CS_LER_F
where business_group_id = p_bg_id;

Line: 5913

delete from BEN_LE_CLSN_N_RSTR
where business_group_id = p_bg_id;

Line: 5916

delete from BEN_PER_IN_LER
where business_group_id = p_bg_id;

Line: 5919

delete from BEN_PTNL_LER_FOR_PER
where business_group_id = p_bg_id;

Line: 5922

delete from BEN_PGM_F
where business_group_id = p_bg_id;

Line: 5925

delete from BEN_ELIG_ENRLD_ANTHR_PGM_F
where business_group_id = p_bg_id;

Line: 5928

delete from BEN_ELIG_PRTT_ANTHR_PGM_F
where business_group_id = p_bg_id;

Line: 5931

delete from BEN_PLIP_F
where business_group_id = p_bg_id;

Line: 5934

delete from BEN_PL_F
where business_group_id = p_bg_id;

Line: 5937

delete from BEN_PTIP_F
where business_group_id = p_bg_id;

Line: 5940

delete from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
where business_group_id = p_bg_id;

Line: 5943

delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
where business_group_id = p_bg_id;

Line: 5946

delete from BEN_ELIG_ENRLD_ANTHR_PL_F
where business_group_id = p_bg_id;

Line: 5949

delete from BEN_ENRT_ENRLD_ANTHR_PL_F
where business_group_id = p_bg_id;

Line: 5952

delete from BEN_OIPLIP_F
where business_group_id = p_bg_id;

Line: 5955

delete from BEN_OIPL_F
where business_group_id = p_bg_id;

Line: 5958

delete from BEN_PGM_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 5961

delete from BEN_BNFT_PRVDR_POOL_F
where business_group_id = p_bg_id;

Line: 5964

delete from BEN_CMBN_PLIP_F
where business_group_id = p_bg_id;

Line: 5967

delete from BEN_CMBN_PTIP_F
where business_group_id = p_bg_id;

Line: 5970

delete from BEN_CMBN_PTIP_OPT_F
where business_group_id = p_bg_id;

Line: 5973

delete from BEN_CM_TYP_USG_F
where business_group_id = p_bg_id;

Line: 5976

delete from BEN_DSGN_RQMT_F
where business_group_id = p_bg_id;

Line: 5979

delete from BEN_ELIG_TO_PRTE_RSN_F
where business_group_id = p_bg_id;

Line: 5982

delete from BEN_LER_CHG_PGM_ENRT_F
where business_group_id = p_bg_id;

Line: 5985

delete from BEN_PL_BNF_CTFN_F
where business_group_id = p_bg_id;

Line: 5988

delete from BEN_PL_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 5991

delete from BEN_PL_GD_OR_SVC_F
where business_group_id = p_bg_id;

Line: 5994

delete from BEN_PL_REGN_F
where business_group_id = p_bg_id;

Line: 5997

delete from BEN_PL_REGY_BOD_F
where business_group_id = p_bg_id;

Line: 6000

delete from BEN_POPL_ACTN_TYP_F
where business_group_id = p_bg_id;

Line: 6003

delete from BEN_POPL_ENRT_TYP_CYCL_F
where business_group_id = p_bg_id;

Line: 6006

delete from BEN_POPL_ORG_F
where business_group_id = p_bg_id;

Line: 6009

delete from BEN_WV_PRTN_RSN_PL_F
where business_group_id = p_bg_id;

Line: 6012

delete from BEN_CRT_ORDR
where business_group_id = p_bg_id;

Line: 6015

delete from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
where business_group_id = p_bg_id;

Line: 6018

delete from BEN_ENRT_CTFN_F
where business_group_id = p_bg_id;

Line: 6021

delete from BEN_LEE_RSN_F
where business_group_id = p_bg_id;

Line: 6024

delete from BEN_PL_R_OIPL_ASSET_F
where business_group_id = p_bg_id;

Line: 6027

delete from BEN_POPL_RPTG_GRP_F
where business_group_id = p_bg_id;

Line: 6030

delete from BEN_POPL_YR_PERD
where business_group_id = p_bg_id;

Line: 6033

delete from BEN_PRTN_ELIG_F
where business_group_id = p_bg_id;

Line: 6036

delete from BEN_VALD_RLSHP_FOR_REIMB_F
where business_group_id = p_bg_id;

Line: 6039

delete from BEN_VRBL_RT_PRFL_F
where business_group_id = p_bg_id;

Line: 6042

delete from BEN_BNFT_RSTRN_CTFN_F
where business_group_id = p_bg_id;

Line: 6045

delete from BEN_BRGNG_UNIT_RT_F
where business_group_id = p_bg_id;

Line: 6048

delete from BEN_CMBN_AGE_LOS_RT_F
where business_group_id = p_bg_id;

Line: 6051

delete from BEN_COMP_LVL_RT_F
where business_group_id = p_bg_id;

Line: 6054

delete from BEN_DSGN_RQMT_RLSHP_TYP
where business_group_id = p_bg_id;

Line: 6057

delete from BEN_ENRT_PERD_FOR_PL_F
where business_group_id = p_bg_id;

Line: 6060

delete from BEN_LGL_ENTY_RT_F
where business_group_id = p_bg_id;

Line: 6063

delete from BEN_LOS_RT_F
where business_group_id = p_bg_id;

Line: 6066

delete from BEN_ORG_UNIT_RT_F
where business_group_id = p_bg_id;

Line: 6069

delete from BEN_PCT_FL_TM_RT_F
where business_group_id = p_bg_id;

Line: 6072

delete from BEN_PER_TYP_RT_F
where business_group_id = p_bg_id;

Line: 6075

delete from BEN_PPL_GRP_RT_F
where business_group_id = p_bg_id;

Line: 6078

delete from BEN_PSTL_ZIP_RT_F
where business_group_id = p_bg_id;

Line: 6081

delete from BEN_PYRL_RT_F
where business_group_id = p_bg_id;

Line: 6084

delete from BEN_SCHEDD_HRS_RT_F
where business_group_id = p_bg_id;

Line: 6087

delete from BEN_SVC_AREA_RT_F
where business_group_id = p_bg_id;

Line: 6090

delete from BEN_TBCO_USE_RT_F
where business_group_id = p_bg_id;

Line: 6093

delete from BEN_TTL_CVG_VOL_RT_F
where business_group_id = p_bg_id;

Line: 6096

delete from BEN_TTL_PRTT_RT_F
where business_group_id = p_bg_id;

Line: 6099

delete from BEN_VRBL_MTCHG_RT_F
where business_group_id = p_bg_id;

Line: 6102

delete from BEN_VRBL_RT_PRFL_RL_F
where business_group_id = p_bg_id;

Line: 6105

delete from BEN_WK_LOC_RT_F
where business_group_id = p_bg_id;

Line: 6108

delete from BEN_ACTL_PREM_F
where business_group_id = p_bg_id;

Line: 6111

delete from BEN_CRT_ORDR_CVRD_PER
where business_group_id = p_bg_id;

Line: 6114

delete from BEN_FL_TM_PT_TM_RT_F
where business_group_id = p_bg_id;

Line: 6117

delete from BEN_GNDR_RT_F
where business_group_id = p_bg_id;

Line: 6120

delete from BEN_GRADE_RT_F
where business_group_id = p_bg_id;

Line: 6123

delete from BEN_HRLY_SLRD_RT_F
where business_group_id = p_bg_id;

Line: 6126

delete from BEN_HRS_WKD_IN_PERD_RT_F
where business_group_id = p_bg_id;

Line: 6129

delete from BEN_LBR_MMBR_RT_F
where business_group_id = p_bg_id;

Line: 6132

delete from BEN_LER_BNFT_RSTRN_F
where business_group_id = p_bg_id;

Line: 6135

delete from BEN_LER_RQRS_ENRT_CTFN_F
where business_group_id = p_bg_id;

Line: 6138

delete from BEN_LER_BNFT_RSTRN_CTFN_F
where business_group_id = p_bg_id;

Line: 6141

delete from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
where business_group_id = p_bg_id;

Line: 6144

delete from BEN_CVG_AMT_CALC_MTHD_F
where business_group_id = p_bg_id;

Line: 6147

delete from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
where business_group_id = p_bg_id;

Line: 6150

delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
where business_group_id = p_bg_id;

Line: 6153

delete from BEN_ELIG_PER_F
where business_group_id = p_bg_id;

Line: 6156

delete from BEN_ENRT_ENRLD_ANTHR_OIPL_F
where business_group_id = p_bg_id;

Line: 6159

delete from BEN_LER_CHG_DPNT_CVG_F
where business_group_id = p_bg_id;

Line: 6162

delete from BEN_LER_CHG_OIPL_ENRT_F
where business_group_id = p_bg_id;

Line: 6165

delete from BEN_LER_CHG_PL_NIP_ENRT_F
where business_group_id = p_bg_id;

Line: 6168

delete from BEN_PIL_ELCTBL_CHC_POPL
where business_group_id = p_bg_id;

Line: 6171

delete from BEN_AGE_RT_F
where business_group_id = p_bg_id;

Line: 6174

delete from BEN_ASNT_SET_RT_F
where business_group_id = p_bg_id;

Line: 6177

delete from BEN_BENFTS_GRP_RT_F
where business_group_id = p_bg_id;

Line: 6180

delete from BEN_PRTT_ENRT_RSLT_F
where business_group_id = p_bg_id;

Line: 6183

delete from BEN_BNFT_VRBL_RT_F
where business_group_id = p_bg_id;

Line: 6186

delete from BEN_ELIG_CVRD_DPNT_F
where business_group_id = p_bg_id;

Line: 6189

delete from BEN_ELIG_PER_ELCTBL_CHC
where business_group_id = p_bg_id;

Line: 6192

delete from BEN_ENRT_BNFT
where business_group_id = p_bg_id;

Line: 6195

delete from BEN_PL_BNF_F
where business_group_id = p_bg_id;

Line: 6198

delete from BEN_PL_R_OIPL_PREM_BY_MO_F
where business_group_id = p_bg_id;

Line: 6201

delete from BEN_PRTT_PREM_F
where business_group_id = p_bg_id;

Line: 6204

delete from BEN_ENRT_PREM
where business_group_id = p_bg_id;

Line: 6207

delete from BEN_PRTN_ELIGY_RL_F
where business_group_id = p_bg_id;

Line: 6210

delete from BEN_ELCTBL_CHC_CTFN
where business_group_id = p_bg_id;

Line: 6213

delete from BEN_ACTL_PREM_VRBL_RT_RL_F
where business_group_id = p_bg_id;

Line: 6216

delete from BEN_BNFT_VRBL_RT_RL_F
where business_group_id = p_bg_id;

Line: 6219

delete from BEN_ELIG_PPL_GRP_PRTE_F
where business_group_id = p_bg_id;

Line: 6222

delete from BEN_PRTN_ELIG_PRFL_F
where business_group_id = p_bg_id;

Line: 6225

delete from BEN_WV_PRTN_RSN_CTFN_PL_F
where business_group_id = p_bg_id;

Line: 6228

delete from BEN_ACTL_PREM_VRBL_RT_F
where business_group_id = p_bg_id;

Line: 6231

delete from BEN_ELIG_PER_OPT_F
where business_group_id = p_bg_id;

Line: 6234

delete from BEN_ELIG_PER_WV_PL_TYP_F
where business_group_id = p_bg_id;

Line: 6237

delete from BEN_PL_GD_R_SVC_CTFN_F
where business_group_id = p_bg_id;

Line: 6240

delete from BEN_PRMRY_CARE_PRVDR_F
where business_group_id = p_bg_id;

Line: 6243

delete from BEN_PRTT_ENRT_ACTN_F
where business_group_id = p_bg_id;

Line: 6246

delete from BEN_PRTT_ENRT_CTFN_PRVDD_F
where business_group_id = p_bg_id;

Line: 6249

delete from BEN_ELIG_DPNT
where business_group_id = p_bg_id;

Line: 6252

delete from BEN_LEE_RSN_RL_F
where business_group_id = p_bg_id;

Line: 6255

delete from BEN_PL_REGY_PRP_F
where business_group_id = p_bg_id;

Line: 6258

delete from BEN_SCHEDD_ENRT_RL_F
where business_group_id = p_bg_id;

Line: 6261

delete from BEN_ELIG_OTHR_PTIP_PRTE_F
where business_group_id = p_bg_id;

Line: 6264

delete from BEN_LER_CHG_PTIP_ENRT_F
where business_group_id = p_bg_id;

Line: 6267

delete from BEN_LER_CHG_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 6270

delete from BEN_LER_CHG_OIPL_ENRT_RL_F
where business_group_id = p_bg_id;

Line: 6273

delete from BEN_LER_CHG_PLIP_ENRT_F
where business_group_id = p_bg_id;

Line: 6276

delete from BEN_LER_ENRT_CTFN_F
where business_group_id = p_bg_id;

Line: 6279

delete from BEN_LER_CHG_PLIP_ENRT_RL_F
where business_group_id = p_bg_id;

Line: 6282

delete from BEN_LER_CHG_PL_NIP_RL_F
where business_group_id = p_bg_id;

Line: 6285

delete from BEN_PER_CM_F
where business_group_id = p_bg_id;

Line: 6288

delete from BEN_PER_CM_TRGR_F
where business_group_id = p_bg_id;

Line: 6291

delete from BEN_PL_BNF_CTFN_PRVDD_F
where business_group_id = p_bg_id;

Line: 6294

delete from BEN_PTIP_DPNT_CVG_CTFN_F
where business_group_id = p_bg_id;

Line: 6297

delete from BEN_WV_PRTN_RSN_PTIP_F
where business_group_id = p_bg_id;

Line: 6300

delete from BEN_CVRD_DPNT_CTFN_PRVDD_F
where business_group_id = p_bg_id;

Line: 6303

delete from BEN_PER_CM_USG_F
where business_group_id = p_bg_id;

Line: 6306

delete from BEN_POPL_ORG_ROLE_F
where business_group_id = p_bg_id;

Line: 6309

delete from BEN_ELIG_JOB_PRTE_F
where business_group_id = p_bg_id;

Line: 6312

delete from BEN_WV_PRTN_RSN_CTFN_PTIP_F
where business_group_id = p_bg_id;

Line: 6315

delete from BEN_BATCH_COMMU_INFO
where business_group_id = p_bg_id;

Line: 6318

delete from BEN_BATCH_DPNT_INFO
where business_group_id = p_bg_id;

Line: 6321

delete from BEN_BATCH_ELCTBL_CHC_INFO
where business_group_id = p_bg_id;

Line: 6324

delete from BEN_BATCH_ELIG_INFO
where business_group_id = p_bg_id;

Line: 6327

delete from BEN_BATCH_LER_INFO
where business_group_id = p_bg_id;

Line: 6330

delete from BEN_BATCH_RATE_INFO
where business_group_id = p_bg_id;

Line: 6333

delete from BEN_BENEFIT_ACTIONS
where business_group_id = p_bg_id;

Line: 6336

delete from BEN_CLPSE_LF_EVT_F
where business_group_id = p_bg_id;

Line: 6339

delete from BEN_PREM_CSTG_BY_SGMT_F
where business_group_id = p_bg_id;

Line: 6342

delete from BEN_BATCH_PROC_INFO
where business_group_id = p_bg_id;

Line: 6345

delete from BEN_PRTT_PREM_BY_MO_F
where business_group_id = p_bg_id;

Line: 6348

delete from BEN_PER_CM_PRVDD_F
where business_group_id = p_bg_id;

Line: 6351

delete from BEN_PRTT_REIMBMT_RQST_F
where business_group_id = p_bg_id;

Line: 6354

delete from BEN_PRTT_CLM_GD_OR_SVC_TYP
where business_group_id = p_bg_id;

Line: 6357

delete from BEN_ROLL_REIMB_RQST
where business_group_id = p_bg_id;

Line: 6360

delete from BEN_ELIG_EE_STAT_PRTE_F
where business_group_id = p_bg_id;

Line: 6363

delete from BEN_EE_STAT_RT_F
where business_group_id = p_bg_id;

Line: 6366

delete from BEN_ELIG_ASNT_SET_PRTE_F
where business_group_id = p_bg_id;

Line: 6369

delete from BEN_ACTY_BASE_RT_F
where business_group_id = p_bg_id;

Line: 6372

delete from BEN_ACTY_RT_PTD_LMT_F
where business_group_id = p_bg_id;

Line: 6375

delete from BEN_ACTY_RT_PYMT_SCHED_F
where business_group_id = p_bg_id;

Line: 6378

delete from BEN_ACTY_VRBL_RT_F
where business_group_id = p_bg_id;

Line: 6381

delete from BEN_APLCN_TO_BNFT_POOL_F
where business_group_id = p_bg_id;

Line: 6384

delete from BEN_BNFT_POOL_RLOVR_RQMT_F
where business_group_id = p_bg_id;

Line: 6387

delete from BEN_BNFT_PRVDD_LDGR_F
where business_group_id = p_bg_id;

Line: 6390

delete from BEN_COMP_LVL_ACTY_RT_F
where business_group_id = p_bg_id;

Line: 6393

delete from BEN_MTCHG_RT_F
where business_group_id = p_bg_id;

Line: 6396

delete from BEN_PAIRD_RT_F
where business_group_id = p_bg_id;

Line: 6399

delete from BEN_PRTL_MO_RT_PRTN_VAL_F
where business_group_id = p_bg_id;

Line: 6402

delete from BEN_VRBL_RT_RL_F
where business_group_id = p_bg_id;

Line: 6405

delete from BEN_DED_SCHED_PY_FREQ
where business_group_id = p_bg_id;

Line: 6408

delete from BEN_ACTY_RT_DED_SCHED_F
where business_group_id = p_bg_id;

Line: 6411

delete from BEN_PERD_TO_PROC
where business_group_id = p_bg_id;

Line: 6414

delete from BEN_PYMT_SCHED_PY_FREQ
where business_group_id = p_bg_id;

Line: 6417

delete from BEN_PRTT_ASSOCD_INSTN_F
where business_group_id = p_bg_id;

Line: 6420

delete from BEN_PRTT_RT_VAL
where business_group_id = p_bg_id;

Line: 6423

delete from BEN_PRTT_VSTG_F
where business_group_id = p_bg_id;

Line: 6426

delete from BEN_ENRT_RT
where business_group_id = p_bg_id;

Line: 6429

delete from BEN_PRTT_REIMBMT_RECON
where business_group_id = p_bg_id;

Line: 6432

delete from BEN_ELIG_LOA_RSN_PRTE_F
where business_group_id = p_bg_id;

Line: 6435

delete from BEN_LOA_RSN_RT_F
where business_group_id = p_bg_id;

Line: 6438

delete from BEN_ELIG_PY_BSS_PRTE_F
where business_group_id = p_bg_id;

Line: 6441

delete from BEN_PY_BSS_RT_F
where business_group_id = p_bg_id;

Line: 6444

delete from BEN_ELIG_ENRLD_ANTHR_OIPL_F
where business_group_id = p_bg_id;

Line: 6447

delete from BEN_PL_PCP
where business_group_id = p_bg_id;

Line: 6450

delete from BEN_PL_PCP_TYP
where business_group_id = p_bg_id;

Line: 6453

delete from BEN_OPTIP_F
where business_group_id = p_bg_id;

Line: 6456

end delete_below_bg;

Line: 6457

procedure delete_below_org(p_org_id NUMBER) is
BEGIN
delete from BEN_ORG_UNIT_PRDCT_F
where organization_id = p_org_id;

Line: 6462

delete from BEN_ELIG_LGL_ENTY_PRTE_F
where organization_id = p_org_id;

Line: 6465

delete from BEN_ELIG_ORG_UNIT_PRTE_F
where organization_id = p_org_id;

Line: 6468

delete from BEN_REGN_F
where organization_id = p_org_id;

Line: 6471

delete from BEN_REGN_FOR_REGY_BODY_F
where organization_id = p_org_id;

Line: 6474

delete from BEN_PER_IN_LGL_ENTY_F
where organization_id = p_org_id;

Line: 6477

delete from BEN_PER_IN_ORG_UNIT_F
where organization_id = p_org_id;

Line: 6480

delete from BEN_LE_CLSN_N_RSTR
where organization_id = p_org_id;

Line: 6483

delete from BEN_PL_REGY_BOD_F
where organization_id = p_org_id;

Line: 6486

delete from BEN_POPL_ORG_F
where organization_id = p_org_id;

Line: 6489

delete from BEN_LGL_ENTY_RT_F
where organization_id = p_org_id;

Line: 6492

delete from BEN_ORG_UNIT_RT_F
where organization_id = p_org_id;

Line: 6495

delete from BEN_ACTL_PREM_F
where organization_id = p_org_id;

Line: 6498

delete from BEN_PL_BNF_F
where organization_id = p_org_id;

Line: 6501

delete from BEN_BENEFIT_ACTIONS
where organization_id = p_org_id;

Line: 6504

end delete_below_org;