APPS.BEN_ELIG_OBJECT SQL Statements

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

Line: 525

    select peo.*
    from   ben_elig_to_prte_rsn_f peo
    where  peo.business_group_id  = p_business_group_id
    and    peo.ler_id = p_ler_id
    and    peo.pl_id = p_pl_id
    and    p_effective_date
           between peo.effective_start_date
           and     peo.effective_end_date;

Line: 564

    select peo.*
    from   ben_elig_to_prte_rsn_f peo
    where  peo.business_group_id  = p_business_group_id
    and    peo.ler_id = p_ler_id
    and    peo.pgm_id = p_pgm_id
    and    p_effective_date
           between peo.effective_start_date
           and     peo.effective_end_date;

Line: 606

    select peo.*
    from   ben_elig_to_prte_rsn_f peo
    where  peo.business_group_id  = p_business_group_id
    and    peo.ler_id = p_ler_id
    and    peo.oipl_id = p_oipl_id
    and    p_effective_date
           between peo.effective_start_date
           and     peo.effective_end_date;

Line: 644

    select peo.*
    from   ben_elig_to_prte_rsn_f peo
    where  peo.business_group_id  = p_business_group_id
    and    peo.ler_id = p_ler_id
    and    peo.plip_id = p_plip_id
    and    p_effective_date
           between peo.effective_start_date
           and     peo.effective_end_date;

Line: 682

    select peo.*
    from   ben_elig_to_prte_rsn_f peo
    where  peo.business_group_id  = p_business_group_id
    and    peo.ler_id = p_ler_id
    and    peo.ptip_id = p_ptip_id
    and    p_effective_date
           between peo.effective_start_date
           and     peo.effective_end_date;

Line: 717

    select epa.*
    from   ben_prtn_elig_f epa
    where  epa.business_group_id  = p_business_group_id
    and    epa.pl_id = p_pl_id
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date;

Line: 749

    select epa.*
    from   ben_prtn_elig_f epa
    where  epa.business_group_id  = p_business_group_id
    and    epa.pgm_id = p_pgm_id
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date;

Line: 785

    select epa.*
    from   ben_prtn_elig_f epa
    where  epa.business_group_id  = p_business_group_id
    and    epa.oipl_id = p_oipl_id
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date;

Line: 817

    select epa.*
    from   ben_prtn_elig_f epa
    where  epa.business_group_id  = p_business_group_id
    and    epa.plip_id = p_plip_id
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date;

Line: 849

    select epa.*
    from   ben_prtn_elig_f epa
    where  epa.business_group_id  = p_business_group_id
    and    epa.ptip_id = p_ptip_id
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date;

Line: 1523

  g_cache_pgm_rec.delete;

Line: 1524

  g_cache_pl_rec.delete;

Line: 1525

  g_cache_oipl_rec.delete;

Line: 1526

  g_cache_plip_rec.delete;

Line: 1527

  g_cache_ptip_rec.delete;

Line: 1528

  g_cache_pgm_elig_rec.delete;

Line: 1529

  g_cache_pl_elig_rec.delete;

Line: 1530

  g_cache_oipl_elig_rec.delete;

Line: 1531

  g_cache_plip_elig_rec.delete;

Line: 1532

  g_cache_ptip_elig_rec.delete;