[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
epe.alws_dpnt_dsgn_flag
,epe.approval_status_cd
,epe.assignment_id
,epe.auto_enrt_flag
,epe.bnft_prvdr_pool_id
,epe.business_group_id
,epe.cmbn_plip_id
,epe.cmbn_ptip_id
,epe.cmbn_ptip_opt_id
,epe.comp_lvl_cd
,epe.crntly_enrd_flag
,epe.cryfwd_elig_dpnt_cd
,epe.ctfn_rqd_flag
,epe.dflt_flag
,epe.dpnt_cvg_strt_dt_cd
,epe.dpnt_cvg_strt_dt_rl
,epe.dpnt_dsgn_cd
,epe.elctbl_flag
,epe.elig_flag
,epe.elig_ovrid_dt
,epe.elig_ovrid_person_id
,epe.elig_per_elctbl_chc_id
,epe.enrt_cvg_strt_dt
,epe.enrt_cvg_strt_dt_cd
,epe.enrt_cvg_strt_dt_rl
,epe.erlst_deenrt_dt
,epe.fonm_cvg_strt_dt
,epe.inelig_rsn_cd
,epe.interim_elig_per_elctbl_chc_id
,epe.in_pndg_wkflow_flag
,epe.ler_chg_dpnt_cvg_cd
,epe.mgr_ovrid_dt
,epe.mgr_ovrid_person_id
,epe.mndtry_flag
,epe.must_enrl_anthr_pl_id
,epe.object_version_number
,epe.oiplip_id
,epe.oipl_id
,epe.oipl_ordr_num
,epe.per_in_ler_id
,epe.pgm_id
,epe.pil_elctbl_chc_popl_id
,epe.plip_id
,epe.plip_ordr_num
,epe.pl_id
,epe.pl_ordr_num
,epe.pl_typ_id
,epe.procg_end_dt
,epe.prtt_enrt_rslt_id
,epe.ptip_id
,epe.ptip_ordr_num
,epe.roll_crs_flag
,epe.spcl_rt_oipl_id
,epe.spcl_rt_pl_id
,epe.ws_mgr_id
,epe.yr_perd_id
FROM ben_elig_per_elctbl_chc epe
WHERE epe.per_in_ler_id = c_per_in_ler_id
order by epe.PTIP_ORDR_NUM,
epe.PLIP_ORDR_NUM,
decode(PL_ORDR_NUM, null, OIPL_ORDR_NUM, PL_ORDR_NUM),
PL_ORDR_NUM,
decode(PL_ORDR_NUM, null, null, OIPL_ORDR_NUM);
g_pilepe_instance.delete;
SELECT
epe.alws_dpnt_dsgn_flag
,epe.approval_status_cd
,epe.assignment_id
,epe.auto_enrt_flag
,epe.bnft_prvdr_pool_id
,epe.business_group_id
,epe.cmbn_plip_id
,epe.cmbn_ptip_id
,epe.cmbn_ptip_opt_id
,epe.comp_lvl_cd
,epe.crntly_enrd_flag
,epe.cryfwd_elig_dpnt_cd
,epe.ctfn_rqd_flag
,epe.dflt_flag
,epe.dpnt_cvg_strt_dt_cd
,epe.dpnt_cvg_strt_dt_rl
,epe.dpnt_dsgn_cd
,epe.elctbl_flag
,epe.elig_flag
,epe.elig_ovrid_dt
,epe.elig_ovrid_person_id
,epe.elig_per_elctbl_chc_id
,epe.enrt_cvg_strt_dt
,epe.enrt_cvg_strt_dt_cd
,epe.enrt_cvg_strt_dt_rl
,epe.erlst_deenrt_dt
,epe.fonm_cvg_strt_dt
,epe.inelig_rsn_cd
,epe.interim_elig_per_elctbl_chc_id
,epe.in_pndg_wkflow_flag
,epe.ler_chg_dpnt_cvg_cd
,epe.mgr_ovrid_dt
,epe.mgr_ovrid_person_id
,epe.mndtry_flag
,epe.must_enrl_anthr_pl_id
,epe.object_version_number
,epe.oiplip_id
,epe.oipl_id
,epe.oipl_ordr_num
,epe.per_in_ler_id
,epe.pgm_id
,epe.pil_elctbl_chc_popl_id
,epe.plip_id
,epe.plip_ordr_num
,epe.pl_id
,epe.pl_ordr_num
,epe.pl_typ_id
,epe.procg_end_dt
,epe.prtt_enrt_rslt_id
,epe.ptip_id
,epe.ptip_ordr_num
,epe.roll_crs_flag
,epe.spcl_rt_oipl_id
,epe.spcl_rt_pl_id
,epe.ws_mgr_id
,epe.yr_perd_id
FROM ben_elig_per_elctbl_chc epe
WHERE epe.per_in_ler_id = c_per_in_ler_id
order by epe.PTIP_ORDR_NUM,
epe.PLIP_ORDR_NUM,
decode(epe.PL_ORDR_NUM, null, epe.OIPL_ORDR_NUM, epe.PL_ORDR_NUM),
epe.PL_ORDR_NUM,
decode(epe.PL_ORDR_NUM, null, null, epe.OIPL_ORDR_NUM);
g_epe_instance.delete;
g_epe_instance.delete;
SELECT epe.elig_per_elctbl_chc_id
FROM ben_elig_per_elctbl_chc epe
WHERE epe.oipl_id = c_oipl_id
AND epe.pgm_id = c_pgm_id
AND epe.per_in_ler_id = c_per_in_ler_id;
SELECT epe.elig_per_elctbl_chc_id
FROM ben_elig_per_elctbl_chc epe
WHERE epe.oipl_id = c_oipl_id
AND epe.pgm_id IS NULL
AND epe.per_in_ler_id = c_per_in_ler_id;
SELECT epe.elig_per_elctbl_chc_id
FROM ben_elig_per_elctbl_chc epe
WHERE epe.pl_id = c_pl_id
AND epe.oipl_id IS NULL
AND epe.pgm_id = c_pgm_id
AND epe.per_in_ler_id = c_per_in_ler_id;
SELECT epe.elig_per_elctbl_chc_id
FROM ben_elig_per_elctbl_chc epe
WHERE epe.pl_id = c_pl_id
AND epe.oipl_id IS NULL
AND epe.pgm_id IS NULL
AND epe.per_in_ler_id = c_per_in_ler_id;
g_pilepe_instance.delete;
g_epe_instance.delete;