APPS.BEN_ECR_SHD SQL Statements

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

Line: 104

    select
	enrt_rt_id            ,
	ordr_num,
	acty_typ_cd           ,
	tx_typ_cd             ,
	ctfn_rqd_flag         ,
	dflt_flag             ,
	dflt_pndg_ctfn_flag   ,
	dsply_on_enrt_flag    ,
	use_to_calc_net_flx_cr_flag,
	entr_val_at_enrt_flag ,
	asn_on_enrt_flag      ,
	rl_crs_only_flag      ,
	dflt_val              ,
	ann_val               ,
	ann_mn_elcn_val       ,
	ann_mx_elcn_val       ,
	val                   ,
	nnmntry_uom           ,
	mx_elcn_val           ,
	mn_elcn_val           ,
	incrmt_elcn_val       ,
	cmcd_acty_ref_perd_cd ,
	cmcd_mn_elcn_val      ,
	cmcd_mx_elcn_val      ,
	cmcd_val              ,
	cmcd_dflt_val         ,
	rt_usg_cd             ,
	ann_dflt_val          ,
	bnft_rt_typ_cd        ,
	rt_mlt_cd             ,
	dsply_mn_elcn_val     ,
	dsply_mx_elcn_val     ,
	entr_ann_val_flag     ,
	rt_strt_dt            ,
	rt_strt_dt_cd         ,
	rt_strt_dt_rl         ,
	rt_typ_cd             ,
	elig_per_elctbl_chc_id,
	acty_base_rt_id       ,
	spcl_rt_enrt_rt_id    ,
	enrt_bnft_id          ,
	prtt_rt_val_id        ,
	decr_bnft_prvdr_pool_id,
	cvg_amt_calc_mthd_id  ,
	actl_prem_id          ,
	comp_lvl_fctr_id      ,
	ptd_comp_lvl_fctr_id  ,
	clm_comp_lvl_fctr_id  ,
	business_group_id     ,
        --cwb
        iss_val               ,
        val_last_upd_date     ,
        val_last_upd_person_id,
        --cwb
        pp_in_yr_used_num,
	ecr_attribute_category,
	ecr_attribute1        ,
	ecr_attribute2        ,
	ecr_attribute3        ,
	ecr_attribute4        ,
	ecr_attribute5        ,
	ecr_attribute6        ,
	ecr_attribute7        ,
	ecr_attribute8        ,
	ecr_attribute9        ,
	ecr_attribute10       ,
	ecr_attribute11       ,
	ecr_attribute12       ,
	ecr_attribute13       ,
	ecr_attribute14       ,
	ecr_attribute15       ,
	ecr_attribute16       ,
	ecr_attribute17       ,
	ecr_attribute18       ,
	ecr_attribute19       ,
	ecr_attribute20       ,
	ecr_attribute21       ,
	ecr_attribute22       ,
    ecr_attribute23       ,
    ecr_attribute24       ,
    ecr_attribute25       ,
    ecr_attribute26       ,
    ecr_attribute27       ,
    ecr_attribute28       ,
    ecr_attribute29       ,
    ecr_attribute30       ,
    last_update_login     ,
    created_by            ,
    creation_date         ,
    last_updated_by       ,
    last_update_date      ,
    request_id            ,
    program_application_id,
    program_id            ,
    program_update_date   ,
    object_version_number
    from	ben_enrt_rt
    where	enrt_rt_id = p_enrt_rt_id;

Line: 270

    select
	enrt_rt_id            ,
	ordr_num,
	acty_typ_cd           ,
	tx_typ_cd             ,
	ctfn_rqd_flag         ,
	dflt_flag             ,
	dflt_pndg_ctfn_flag   ,
	dsply_on_enrt_flag    ,
	use_to_calc_net_flx_cr_flag,
	entr_val_at_enrt_flag ,
	asn_on_enrt_flag      ,
	rl_crs_only_flag      ,
	dflt_val              ,
	ann_val               ,
	ann_mn_elcn_val       ,
	ann_mx_elcn_val       ,
	val                   ,
	nnmntry_uom           ,
	mx_elcn_val           ,
	mn_elcn_val           ,
	incrmt_elcn_val       ,
	cmcd_acty_ref_perd_cd ,
	cmcd_mn_elcn_val      ,
	cmcd_mx_elcn_val      ,
	cmcd_val              ,
	cmcd_dflt_val         ,
	rt_usg_cd             ,
	ann_dflt_val          ,
	bnft_rt_typ_cd        ,
	rt_mlt_cd             ,
	dsply_mn_elcn_val     ,
	dsply_mx_elcn_val     ,
	entr_ann_val_flag     ,
	rt_strt_dt            ,
	rt_strt_dt_cd         ,
	rt_strt_dt_rl         ,
	rt_typ_cd             ,
	elig_per_elctbl_chc_id,
	acty_base_rt_id       ,
	spcl_rt_enrt_rt_id    ,
	enrt_bnft_id          ,
	prtt_rt_val_id        ,
	decr_bnft_prvdr_pool_id,
	cvg_amt_calc_mthd_id  ,
	actl_prem_id          ,
	comp_lvl_fctr_id      ,
	ptd_comp_lvl_fctr_id  ,
	clm_comp_lvl_fctr_id  ,
	business_group_id     ,
        --cwb
        iss_val               ,
        val_last_upd_date     ,
        val_last_upd_person_id,
        --cwb
        pp_in_yr_used_num,
	ecr_attribute_category,
	ecr_attribute1        ,
	ecr_attribute2        ,
	ecr_attribute3        ,
	ecr_attribute4        ,
	ecr_attribute5        ,
	ecr_attribute6        ,
	ecr_attribute7        ,
	ecr_attribute8        ,
	ecr_attribute9        ,
	ecr_attribute10       ,
	ecr_attribute11       ,
	ecr_attribute12       ,
	ecr_attribute13       ,
	ecr_attribute14       ,
	ecr_attribute15       ,
	ecr_attribute16       ,
	ecr_attribute17       ,
	ecr_attribute18       ,
	ecr_attribute19       ,
	ecr_attribute20       ,
	ecr_attribute21       ,
	ecr_attribute22       ,
    ecr_attribute23       ,
    ecr_attribute24       ,
    ecr_attribute25       ,
    ecr_attribute26       ,
    ecr_attribute27       ,
    ecr_attribute28       ,
    ecr_attribute29       ,
    ecr_attribute30       ,
    last_update_login     ,
    created_by            ,
    creation_date         ,
    last_updated_by       ,
    last_update_date      ,
    request_id            ,
    program_application_id,
    program_id            ,
    program_update_date   ,
    object_version_number
    from	ben_enrt_rt
    where	enrt_rt_id = p_enrt_rt_id
    for	update nowait;

Line: 505

    p_last_update_login           in  NUMBER,
    p_created_by                  in  NUMBER,
    p_creation_date               in  DATE,
    p_last_updated_by             in  NUMBER,
    p_last_update_date            in  DATE,
    p_request_id                  in  NUMBER,
    p_program_application_id      in  NUMBER,
    p_program_id                  in  NUMBER,
    p_program_update_date         in  DATE,
    p_object_version_number       in  NUMBER
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 613

  l_rec.last_update_login            := p_last_update_login;

Line: 616

  l_rec.last_updated_by              := p_last_updated_by;

Line: 617

  l_rec.last_update_date             := p_last_update_date;

Line: 621

  l_rec.program_update_date          := p_program_update_date;