APPS.BEN_COLLAPSE_LIFE_EVENT SQL Statements

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

Line: 30

    select ptn.ptnl_ler_for_per_id,
           ptn.ler_id,
           ptn.ptnl_ler_for_per_stat_cd,
           ptn.lf_evt_ocrd_dt,
           ptn.ntfn_dt,
           ptn.object_version_number
    from   ben_ptnl_ler_for_per ptn,
           ben_ler_f      ler
    where  ptn.business_group_id  = p_business_group_id
    and    ptn.person_id = p_person_id
    and    ptn.ler_id = ler.ler_id
    and    p_effective_date
           between ler.effective_start_date
           and     ler.effective_end_date
    -- ABSENCES : Do not consider absence life events
    and    ler.typ_cd not in  ('COMP', 'ABS','GSP', 'IREC')
    and    ptn.ptnl_ler_for_per_stat_cd not in ('VOIDD','MNL')
    and    ptn.lf_evt_ocrd_dt <= decode(ler.typ_cd,  --Bug 5703825
                                        'SCHEDDO',
                                        ptn.lf_evt_ocrd_dt,
					'SCHEDDA',
                                        ptn.lf_evt_ocrd_dt,
                                        p_effective_date)
     order  by ptn.lf_evt_ocrd_dt asc;

Line: 74

  g_events.delete;

Line: 247

    select pil.per_in_ler_id, pil.lf_evt_ocrd_dt
    from   ben_per_in_ler pil
    where  pil.ptnl_ler_for_per_id = p_ptnl_ler_for_per_id
    and    pil.business_group_id = p_business_group_id
    and    pil.per_in_ler_stat_cd in ('STRTD','PROCD');

Line: 255

    select pil.per_in_ler_id, pil.lf_evt_ocrd_dt, pil.ntfn_dt, ler.name
    from   ben_per_in_ler pil,
           ben_ler_f ler
    where  pil.person_id = p_person_id
    and    pil.per_in_ler_stat_cd in ('STRTD','PROCD')
    and    pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt
    and    pil.per_in_ler_id <> p_curr_per_in_ler_id
    and    pil.ler_id = ler.ler_id
    and    p_effective_date between ler.effective_start_date and ler.effective_end_date
    and    ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC', 'SCHEDDU')
    order by lf_evt_ocrd_dt desc;

Line: 521

        ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
         (p_ptnl_ler_for_per_id      => g_included_events(l_count).
                                        ptnl_ler_for_per_id,
          p_ptnl_ler_for_per_stat_cd => 'VOIDD',
          p_voidd_dt                 => p_effective_date,
          p_effective_date           => p_effective_date,
          p_object_version_number    => g_included_events(l_count).
                                        object_version_number);

Line: 540

        ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
         (p_ptnl_ler_for_per_id      => g_included_events(l_count).
                                        ptnl_ler_for_per_id,
          p_effective_date           => p_effective_date,
          p_object_version_number    => g_included_events(l_count).
                                        object_version_number);

Line: 547

        fnd_message.set_name('BEN','BEN_92435_PTNL_LER_DELETED');

Line: 578

     p_program_update_date      => sysdate);

Line: 767

  l_dynamic_sql := 'select 1 from sys.dual where '||p_expression;

Line: 805

  g_included_events.delete;

Line: 872

    select *
    from   ben_clpse_lf_evt_f clp
    where  clp.business_group_id  = p_business_group_id
    and    p_effective_date
           between clp.effective_start_date
           and     clp.effective_end_date
    order  by seq;