eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_COBJ_CACHE SQL Statements

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

Line: 53


    SELECT TAB1.OIPLIP_ID,
           TAB1.PLIP_ID,
           TAB1.OIPL_ID
    FROM BEN_OIPLIP_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 102


    SELECT TAB1.OIPLIP_ID,
           TAB1.PLIP_ID,
           TAB1.OIPL_ID
    FROM BEN_OIPLIP_F TAB1
    WHERE TAB1.oiplip_id = c_oiplip_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 183


    SELECT tab1.opt_id
          ,tab1.name
          ,tab1.effective_start_date
          ,tab1.effective_end_date
          ,tab1.rqd_perd_enrt_nenrt_uom
          ,tab1.rqd_perd_enrt_nenrt_val
          ,tab1.rqd_perd_enrt_nenrt_rl
    FROM BEN_OPT_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 236


    SELECT tab1.opt_id
          ,tab1.name
          ,tab1.effective_start_date
          ,tab1.effective_end_date
          ,tab1.rqd_perd_enrt_nenrt_uom
          ,tab1.rqd_perd_enrt_nenrt_val
          ,tab1.rqd_perd_enrt_nenrt_rl
    FROM BEN_OPT_F TAB1
    WHERE TAB1.opt_id = c_opt_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 323


    SELECT tab1.oipl_id
          ,tab1.effective_start_date
          ,tab1.effective_end_date
          ,tab1.opt_id
          ,tab1.pl_id
          ,tab1.trk_inelig_per_flag
          ,tab1.ordr_num
          ,tab1.elig_apls_flag
          ,tab1.prtn_elig_ovrid_alwd_flag
          ,tab1.vrfy_fmly_mmbr_cd
          ,tab1.vrfy_fmly_mmbr_rl
          ,tab1.per_cvrd_cd
          ,tab1.dflt_flag
          ,tab1.mndtry_flag
          ,tab1.mndtry_rl
          ,tab1.auto_enrt_flag
          ,tab1.auto_enrt_mthd_rl
          ,tab1.enrt_cd
          ,tab1.enrt_rl
          ,tab1.dflt_enrt_cd
          ,tab1.dflt_enrt_det_rl
          ,tab1.rqd_perd_enrt_nenrt_uom
          ,tab1.rqd_perd_enrt_nenrt_val
          ,tab1.rqd_perd_enrt_nenrt_rl
          ,tab1.actl_prem_id
          ,tab1.postelcn_edit_rl
    FROM BEN_OIPL_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 395


    SELECT tab1.oipl_id
          ,tab1.effective_start_date
          ,tab1.effective_end_date
          ,tab1.opt_id
          ,tab1.pl_id
          ,tab1.trk_inelig_per_flag
          ,tab1.ordr_num
          ,tab1.elig_apls_flag
          ,tab1.prtn_elig_ovrid_alwd_flag
          ,tab1.vrfy_fmly_mmbr_cd
          ,tab1.vrfy_fmly_mmbr_rl
          ,tab1.per_cvrd_cd
          ,tab1.dflt_flag
          ,tab1.mndtry_flag
          ,tab1.mndtry_rl
          ,tab1.auto_enrt_flag
          ,tab1.auto_enrt_mthd_rl
          ,tab1.enrt_cd
          ,tab1.enrt_rl
          ,tab1.dflt_enrt_cd
          ,tab1.dflt_enrt_det_rl
          ,tab1.rqd_perd_enrt_nenrt_uom
          ,tab1.rqd_perd_enrt_nenrt_val
          ,tab1.rqd_perd_enrt_nenrt_rl
          ,tab1.actl_prem_id
          ,tab1.postelcn_edit_rl
    FROM BEN_OIPL_F TAB1
    WHERE TAB1.oipl_id = c_oipl_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 501


    SELECT tab1.pgm_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.trk_inelig_per_flag,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.dpnt_dsgn_lvl_cd,
           tab1.dpnt_dsgn_cd,
           tab1.dpnt_cvg_strt_dt_cd,
           tab1.dpnt_cvg_strt_dt_rl,
           tab1.dpnt_cvg_end_dt_cd,
           tab1.dpnt_cvg_end_dt_rl,
           tab1.pgm_typ_cd
    FROM BEN_PGM_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 570


    SELECT tab1.pgm_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.trk_inelig_per_flag,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.dpnt_dsgn_lvl_cd,
           tab1.dpnt_dsgn_cd,
           tab1.dpnt_cvg_strt_dt_cd,
           tab1.dpnt_cvg_strt_dt_rl,
           tab1.dpnt_cvg_end_dt_cd,
           tab1.dpnt_cvg_end_dt_rl,
           tab1.pgm_typ_cd
    FROM BEN_PGM_F TAB1
    WHERE TAB1.pgm_id = c_pgm_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 673


    SELECT tab1.ptip_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.trk_inelig_per_flag,
           tab1.ordr_num,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.rqd_perd_enrt_nenrt_tm_uom,
           tab1.rqd_perd_enrt_nenrt_val,
           tab1.rqd_perd_enrt_nenrt_rl,
           tab1.dpnt_dsgn_cd,
           tab1.dpnt_cvg_strt_dt_cd,
           tab1.dpnt_cvg_strt_dt_rl,
           tab1.dpnt_cvg_end_dt_cd,
           tab1.dpnt_cvg_end_dt_rl,
           tab1.postelcn_edit_rl
    FROM BEN_PTIP_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 745


    SELECT tab1.ptip_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.trk_inelig_per_flag,
           tab1.ordr_num,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.rqd_perd_enrt_nenrt_tm_uom,
           tab1.rqd_perd_enrt_nenrt_val,
           tab1.rqd_perd_enrt_nenrt_rl,
           tab1.dpnt_dsgn_cd,
           tab1.dpnt_cvg_strt_dt_cd,
           tab1.dpnt_cvg_strt_dt_rl,
           tab1.dpnt_cvg_end_dt_cd,
           tab1.dpnt_cvg_end_dt_rl,
           tab1.postelcn_edit_rl
    FROM BEN_PTIP_F TAB1
    WHERE TAB1.ptip_id = c_ptip_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 851


    SELECT tab1.plip_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.trk_inelig_per_flag,
           tab1.ordr_num,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.bnft_or_option_rstrctn_cd,
           tab1.pl_id,
           tab1.pgm_id,
           tab1.cvg_incr_r_decr_only_cd,
           tab1.mx_cvg_mlt_incr_num,
           tab1.mx_cvg_mlt_incr_wcf_num,
           tab1.postelcn_edit_rl
    FROM BEN_PLIP_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 921


    SELECT tab1.plip_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.trk_inelig_per_flag,
           tab1.ordr_num,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.bnft_or_option_rstrctn_cd,
           tab1.pl_id,
           tab1.pgm_id,
           tab1.cvg_incr_r_decr_only_cd,
           tab1.mx_cvg_mlt_incr_num,
           tab1.mx_cvg_mlt_incr_wcf_num,
           tab1.postelcn_edit_rl
    FROM BEN_PLIP_F TAB1
    WHERE TAB1.plip_id = c_plip_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 1025


    SELECT tab1.pl_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.per_cvrd_cd,
           tab1.pl_typ_id,
           tab1.trk_inelig_per_flag,
           tab1.ordr_num,
           tab1.mx_wtg_dt_to_use_cd,
           tab1.mx_wtg_dt_to_use_rl,
           tab1.mx_wtg_perd_rl,
           tab1.mx_wtg_perd_prte_uom,
           tab1.mx_wtg_perd_prte_val,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.bnft_or_option_rstrctn_cd,
           tab1.nip_dflt_enrt_cd,
           tab1.nip_dflt_enrt_det_rl,
           tab1.rqd_perd_enrt_nenrt_uom,
           tab1.rqd_perd_enrt_nenrt_val,
           tab1.rqd_perd_enrt_nenrt_rl,
           tab1.cvg_incr_r_decr_only_cd,
           tab1.mx_cvg_mlt_incr_num,
           tab1.mx_cvg_mlt_incr_wcf_num,
           tab1.name,
           tab1.actl_prem_id,
           tab1.bnf_dsgn_cd,
           tab1.enrt_pl_opt_flag,
           tab1.dpnt_cvg_strt_dt_cd,
           tab1.dpnt_cvg_strt_dt_rl,
           tab1.dpnt_cvg_end_dt_cd,
           tab1.dpnt_cvg_end_dt_rl,
           tab1.alws_qmcso_flag,
           tab1.alws_qdro_flag, /* Bug 4766118 */
           tab1.dpnt_dsgn_cd,
           tab1.postelcn_edit_rl,
           tab1.dpnt_cvd_by_othr_apls_flag,
           tab1.nip_dflt_flag,
           tab1.svgs_pl_flag
    FROM BEN_PL_F TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 1119


    SELECT tab1.pl_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.enrt_cvg_strt_dt_cd,
           tab1.enrt_cvg_strt_dt_rl,
           tab1.enrt_cvg_end_dt_cd,
           tab1.enrt_cvg_end_dt_rl,
           tab1.rt_strt_dt_cd,
           tab1.rt_strt_dt_rl,
           tab1.rt_end_dt_cd,
           tab1.rt_end_dt_rl,
           tab1.elig_apls_flag,
           tab1.prtn_elig_ovrid_alwd_flag,
           tab1.per_cvrd_cd,
           tab1.pl_typ_id,
           tab1.trk_inelig_per_flag,
           tab1.ordr_num,
           tab1.mx_wtg_dt_to_use_cd,
           tab1.mx_wtg_dt_to_use_rl,
           tab1.mx_wtg_perd_rl,
           tab1.mx_wtg_perd_prte_uom,
           tab1.mx_wtg_perd_prte_val,
           tab1.vrfy_fmly_mmbr_cd,
           tab1.vrfy_fmly_mmbr_rl,
           tab1.bnft_or_option_rstrctn_cd,
           tab1.nip_dflt_enrt_cd,
           tab1.nip_dflt_enrt_det_rl,
           tab1.rqd_perd_enrt_nenrt_uom,
           tab1.rqd_perd_enrt_nenrt_val,
           tab1.rqd_perd_enrt_nenrt_rl,
           tab1.cvg_incr_r_decr_only_cd,
           tab1.mx_cvg_mlt_incr_num,
           tab1.mx_cvg_mlt_incr_wcf_num,
           tab1.name,
           tab1.actl_prem_id,
           tab1.bnf_dsgn_cd,
           tab1.enrt_pl_opt_flag,
           tab1.dpnt_cvg_strt_dt_cd,
           tab1.dpnt_cvg_strt_dt_rl,
           tab1.dpnt_cvg_end_dt_cd,
           tab1.dpnt_cvg_end_dt_rl,
           tab1.alws_qmcso_flag,
           tab1.alws_qdro_flag,   /* Bug 4766118 */
           tab1.dpnt_dsgn_cd,
           tab1.postelcn_edit_rl,
           tab1.dpnt_cvd_by_othr_apls_flag,
           tab1.nip_dflt_flag,
           tab1.SVGS_PL_FLAG
    FROM BEN_PL_F TAB1
    WHERE TAB1.pl_id = c_pl_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 1245


    SELECT tab1.elig_to_prte_rsn_id
          ,tab1.effective_start_date
          ,tab1.effective_end_date
          ,tab1.ler_id
          ,tab1.pgm_id
          ,tab1.ptip_id
          ,tab1.plip_id
          ,tab1.pl_id
          ,tab1.oipl_id
          ,tab1.wait_perd_dt_to_use_cd
          ,tab1.wait_perd_dt_to_use_rl
          ,tab1.wait_perd_rl
          ,tab1.wait_perd_uom
          ,tab1.wait_perd_val
          ,tab1.prtn_eff_strt_dt_rl
          ,tab1.prtn_eff_end_dt_rl
          ,tab1.prtn_eff_strt_dt_cd
          ,tab1.prtn_eff_end_dt_cd
          ,tab1.elig_inelig_cd
          ,tab1.ignr_prtn_ovrid_flag
          ,tab1.vrfy_fmly_mmbr_cd
          ,tab1.vrfy_fmly_mmbr_rl
    FROM ben_elig_to_prte_rsn_f TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 1402


    SELECT tab1.prtn_elig_id,
           tab1.effective_start_date,
           tab1.effective_end_date,
           tab1.pgm_id,
           tab1.ptip_id,
           tab1.plip_id,
           tab1.pl_id,
           tab1.oipl_id,
           tab1.wait_perd_dt_to_use_cd,
           tab1.wait_perd_dt_to_use_rl,
           tab1.wait_perd_rl,
           tab1.wait_perd_uom,
           tab1.wait_perd_val,
           tab1.prtn_eff_strt_dt_rl,
           tab1.prtn_eff_end_dt_rl,
           tab1.prtn_eff_strt_dt_cd,
           tab1.prtn_eff_end_dt_cd
    FROM ben_prtn_elig_f TAB1
    WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
    AND   c_effective_date
      BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;

Line: 1557


  g_oiplip_instance.delete;

Line: 1561


  g_opt_instance.delete;

Line: 1565


  g_oipl_instance.delete;

Line: 1569


  g_pgm_instance.delete;

Line: 1573


  g_ptip_instance.delete;

Line: 1577


  g_plip_instance.delete;

Line: 1581


  g_pl_instance.delete;

Line: 1585


  g_etpr_instance.delete;

Line: 1594


  g_prel_instance.delete;

Line: 1618


  g_oiplip_instance.delete;

Line: 1622


  g_opt_instance.delete;

Line: 1626


  g_oipl_instance.delete;

Line: 1630


  g_pgm_instance.delete;

Line: 1634


  g_ptip_instance.delete;

Line: 1638


  g_plip_instance.delete;

Line: 1642


  g_pl_instance.delete;

Line: 1646


  g_etpr_instance.delete;

Line: 1655


  g_prel_instance.delete;