APPS.BEN_PEL_SHD SQL Statements

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

Line: 74

    select
    pil_elctbl_chc_popl_id,
    dflt_enrt_dt,
    dflt_asnd_dt,
    elcns_made_dt,
    cls_enrt_dt_to_use_cd,
    enrt_typ_cycl_cd,
    enrt_perd_end_dt,
    enrt_perd_strt_dt,
    procg_end_dt,
    pil_elctbl_popl_stat_cd,
    acty_ref_perd_cd,
    uom,
    comments,
    mgr_ovrid_dt,
    ws_mgr_id,
    mgr_ovrid_person_id,
    assignment_id,
        --cwb
        bdgt_acc_cd,
        pop_cd,
        bdgt_due_dt,
        bdgt_export_flag,
        bdgt_iss_dt,
        bdgt_stat_cd,
        ws_acc_cd,
        ws_due_dt,
        ws_export_flag,
        ws_iss_dt,
        ws_stat_cd,
        --cwb
        reinstate_cd,
        reinstate_ovrdn_cd,
	reopen_le_on_reprocess,
    auto_asnd_dt,
        cbr_elig_perd_strt_dt,
        cbr_elig_perd_end_dt,
    lee_rsn_id,
    enrt_perd_id,
    per_in_ler_id,
    pgm_id,
    pl_id,
    business_group_id,
    pel_attribute_category,
    pel_attribute1,
    pel_attribute2,
    pel_attribute3,
    pel_attribute4,
    pel_attribute5,
    pel_attribute6,
    pel_attribute7,
    pel_attribute8,
    pel_attribute9,
    pel_attribute10,
    pel_attribute11,
    pel_attribute12,
    pel_attribute13,
    pel_attribute14,
    pel_attribute15,
    pel_attribute16,
    pel_attribute17,
    pel_attribute18,
    pel_attribute19,
    pel_attribute20,
    pel_attribute21,
    pel_attribute22,
    pel_attribute23,
    pel_attribute24,
    pel_attribute25,
    pel_attribute26,
    pel_attribute27,
    pel_attribute28,
    pel_attribute29,
    pel_attribute30,
    request_id,
    program_application_id,
    program_id,
    program_update_date,
    object_version_number,
    defer_deenrol_flag,
    deenrol_made_dt
    from    ben_pil_elctbl_chc_popl
    where   pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;

Line: 224

    select  pil_elctbl_chc_popl_id,
    dflt_enrt_dt,
    dflt_asnd_dt,
    elcns_made_dt,
    cls_enrt_dt_to_use_cd,
    enrt_typ_cycl_cd,
    enrt_perd_end_dt,
    enrt_perd_strt_dt,
    procg_end_dt,
    pil_elctbl_popl_stat_cd,
    acty_ref_perd_cd,
    uom,
    comments,
    mgr_ovrid_dt,
    ws_mgr_id,
    mgr_ovrid_person_id,
    assignment_id,
        --cwb
        bdgt_acc_cd,
        pop_cd,
        bdgt_due_dt,
        bdgt_export_flag,
        bdgt_iss_dt,
        bdgt_stat_cd,
        ws_acc_cd,
        ws_due_dt,
        ws_export_flag,
        ws_iss_dt,
        ws_stat_cd,
        --cwb
        reinstate_cd,
        reinstate_ovrdn_cd,
	reopen_le_on_reprocess,
    auto_asnd_dt,
        cbr_elig_perd_strt_dt,
        cbr_elig_perd_end_dt,
    lee_rsn_id,
    enrt_perd_id,
    per_in_ler_id,
    pgm_id,
    pl_id,
    business_group_id,
    pel_attribute_category,
    pel_attribute1,
    pel_attribute2,
    pel_attribute3,
    pel_attribute4,
    pel_attribute5,
    pel_attribute6,
    pel_attribute7,
    pel_attribute8,
    pel_attribute9,
    pel_attribute10,
    pel_attribute11,
    pel_attribute12,
    pel_attribute13,
    pel_attribute14,
    pel_attribute15,
    pel_attribute16,
    pel_attribute17,
    pel_attribute18,
    pel_attribute19,
    pel_attribute20,
    pel_attribute21,
    pel_attribute22,
    pel_attribute23,
    pel_attribute24,
    pel_attribute25,
    pel_attribute26,
    pel_attribute27,
    pel_attribute28,
    pel_attribute29,
    pel_attribute30,
    request_id,
    program_application_id,
    program_id,
    program_update_date,
    object_version_number,
    defer_deenrol_flag,
    deenrol_made_dt
    from    ben_pil_elctbl_chc_popl
    where   pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
    for update nowait;

Line: 432

    p_program_update_date           in date,
    p_object_version_number         in number,
    p_defer_deenrol_flag            in varchar2,
    p_deenrol_made_dt               in date
    )
    Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 524

  l_rec.program_update_date              := p_program_update_date;