APPS.BEN_PEP_CACHE1 SQL Statements

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

Line: 51

    select  /*+ benppch1.get_curroiplippep_dets.c_piloiplip_dets */
            pep.elig_per_id
    from    ben_elig_per_f pep,
            ben_per_in_ler pil
    where   pep.person_id = c_person_id
    and     pep.pgm_id  = c_pgm_id
    and     pep.plip_id = c_plip_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date
    and    pil.per_in_ler_id=pep.per_in_ler_id
    and    pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');

Line: 70

    select  /*+ benppch1.get_curroiplippep_dets.c_nopiloiplip_dets */
            pep.elig_per_id
    from    ben_elig_per_f pep
    where   pep.person_id = c_person_id
    and     pep.per_in_ler_id is null
    and     pep.pgm_id    = c_pgm_id
    and     pep.plip_id   = c_plip_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date;

Line: 86

    select  /*+ benppch1.get_curroiplippep_dets.c_piloiplipnip_dets */
            pep.elig_per_id
    from    ben_elig_per_f pep,
            ben_per_in_ler pil
    where   pep.person_id = c_person_id
    and     pep.pgm_id is null
    and     pep.plip_id = c_plip_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date
    and    pil.per_in_ler_id=pep.per_in_ler_id
    and    pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');

Line: 104

    select  /*+ benppch1.get_curroiplippep_dets.c_nopiloiplipnip_dets */
            pep.elig_per_id
    from    ben_elig_per_f pep
    where   pep.person_id = c_person_id
    and     pep.per_in_ler_id is null
    and     pep.pgm_id is null
    and     pep.plip_id = c_plip_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date;

Line: 194

    select  /*+ benppch1.get_currplnpep_dets.c_pilpln_dets */
            pep.elig_per_id,
            pep.prtn_strt_dt,
            pep.prtn_end_dt
    from    ben_elig_per_f pep,
            ben_per_in_ler pil
    where   pep.person_id = c_person_id
    and     pep.pgm_id    = c_pgm_id
    and     pep.pl_id     = c_pl_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date
    and     pil.per_in_ler_id=pep.per_in_ler_id
    and     pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
     order by pep.per_in_ler_id desc ;   -- Bug 5941500

Line: 216

    select  /*+ benppch1.get_currplnpep_dets.c_nopilpln_dets */
            pep.elig_per_id,
            pep.prtn_strt_dt,
            pep.prtn_end_dt
    from    ben_elig_per_f pep
    where   pep.person_id = c_person_id
    and     pep.per_in_ler_id is null
    and     pep.pgm_id    = c_pgm_id
    and     pep.pl_id     = c_pl_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date;

Line: 234

    select  /*+ benppch1.get_currplnpep_dets.c_pilplnip_dets */
            pep.elig_per_id,
            pep.prtn_strt_dt,
            pep.prtn_end_dt
    from    ben_elig_per_f pep,
            ben_per_in_ler pil
    where   pep.person_id = c_person_id
    and     pep.pgm_id is null
    and     pep.pl_id     = c_pl_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date
    and    pil.per_in_ler_id=pep.per_in_ler_id
    and    pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
    order by pep.per_in_ler_id desc ;-- Bug 5941500

Line: 255

    select  /*+ benppch1.get_currplnpep_dets.c_nopilplnip_dets */
            pep.elig_per_id,
            pep.prtn_strt_dt,
            pep.prtn_end_dt
    from    ben_elig_per_f pep
    where   pep.person_id = c_person_id
    and     pep.per_in_ler_id is null
    and     pep.pgm_id is null
    and     pep.pl_id = c_pl_id
    and     c_effective_date
      between pep.effective_start_date and pep.effective_end_date;