APPS.BEN_BIS_UTILS SQL Statements

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

Line: 34

  select name
  from 	 ben_pl_f pl
  where  pl_id = p_pl_id
  and    business_group_id = p_business_group_id
  and 	 p_effective_date between effective_start_date and effective_end_date;

Line: 62

  select name
  from 	 ben_pl_f pl
  where  pl_id = p_pl_id
  and 	 p_effective_date between effective_start_date and effective_end_date;

Line: 91

  select name
  from 	 ben_pgm_f pgm
  where  pgm_id = p_pgm_id
  and    business_group_id = p_business_group_id
  and 	 p_effective_date between effective_start_date and effective_end_date;

Line: 120

  select name
  from 	 ben_opt_f
  where  opt_id = p_opt_id
  and    business_group_id = p_business_group_id
  and 	 p_effective_date between effective_start_date and effective_end_date;

Line: 150

  select name
  from 	 ben_opt_f
  where  opt_id = p_opt_id
  and 	 p_effective_date between effective_start_date and effective_end_date;

Line: 179

  select pgm.name|| ' - '|| pln.name
  from 	 ben_pl_f pln,
  	 ben_pgm_f pgm,
  	 ben_plip_f plip
  where  plip.plip_id = p_plip_id
  and    pgm.pgm_id   = plip.pgm_id
  and    pln.pl_id    = plip.pl_id
  and    plip.business_group_id = p_business_group_id
  and 	 p_effective_date between plip.effective_start_date and plip.effective_end_date
  and 	 p_effective_date between pln.effective_start_date and pln.effective_end_date
  and 	 p_effective_date between pgm.effective_start_date and pgm.effective_end_date;

Line: 215

  select pgm.name|| ' - ' || plt.name
  from 	 ben_pl_typ_f plt,
  	 ben_pgm_f pgm,
  	 ben_ptip_f ptip
  where  ptip.ptip_id = p_ptip_id
  and    pgm.pgm_id   = ptip.pgm_id
  and    plt.pl_typ_id   = ptip.pl_typ_id
  and    ptip.business_group_id = p_business_group_id
  and 	 p_effective_date between ptip.effective_start_date and ptip.effective_end_date
  and 	 p_effective_date between plt.effective_start_date and plt.effective_end_date
  and 	 p_effective_date between pgm.effective_start_date and pgm.effective_end_date;

Line: 251

  select pln.name|| ' - '|| opt.name
  from 	 ben_pl_f pln,
  	 ben_opt_f opt,
  	 ben_oipl_f oipl
  where  oipl.oipl_id = p_oipl_id
  and    opt.opt_id   = oipl.opt_id
  and    pln.pl_id    = oipl.pl_id
  and    oipl.business_group_id = p_business_group_id
  and 	 p_effective_date between oipl.effective_start_date and oipl.effective_end_date
  and 	 p_effective_date between opt.effective_start_date and opt.effective_end_date
  and 	 p_effective_date between pln.effective_start_date and pln.effective_end_date;

Line: 286

  select pln.name|| ' - '|| opt.name
  from 	 ben_pl_f pln,
  	 ben_opt_f opt,
  	 ben_oipl_f oipl
  where  oipl.oipl_id = p_oipl_id
  and    opt.opt_id   = oipl.opt_id
  and    pln.pl_id    = oipl.pl_id
  and 	 p_effective_date between oipl.effective_start_date and oipl.effective_end_date
  and 	 p_effective_date between opt.effective_start_date and opt.effective_end_date
  and 	 p_effective_date between pln.effective_start_date and pln.effective_end_date;

Line: 320

  select pgm.name || ' - '|| pln.name|| ' - '|| opt.name
  from 	 ben_pl_f pln,
  	 ben_opt_f opt,
  	 ben_oipl_f oipl,
  	 ben_oiplip_f oiplip,
  	 ben_plip_f plip,
  	 ben_pgm_f pgm
  where  oiplip.oiplip_id = p_oiplip_id
  and    oipl.oipl_id   = oiplip.oipl_id
  and    opt.opt_id     = oipl.opt_id
  and    pln.pl_id      = oipl.pl_id
  and    plip.plip_id   = oiplip.plip_id
  and    pgm.pgm_id     = plip.pgm_id
  and    oiplip.business_group_id = p_business_group_id
  and 	 p_effective_date between oiplip.effective_start_date and oiplip.effective_end_date
  and 	 p_effective_date between oipl.effective_start_date and oipl.effective_end_date
  and 	 p_effective_date between opt.effective_start_date and opt.effective_end_date
  and 	 p_effective_date between pln.effective_start_date and pln.effective_end_date
  and 	 p_effective_date between plip.effective_start_date and plip.effective_end_date
  and 	 p_effective_date between pgm.effective_start_date and pgm.effective_end_date;

Line: 365

  select cplip.name
  from   ben_cmbn_plip_f cplip
  where  cplip.cmbn_plip_id    = p_cmbn_plip_id
  and    cplip.business_group_id = p_business_group_id
  and    p_effective_date between cplip.effective_start_date and cplip.effective_end_date;

Line: 395

  select cptip.name
  from 	 ben_cmbn_ptip_f cptip
  where  cptip.cmbn_ptip_id = p_cmbn_ptip_id
  and    cptip.business_group_id = p_business_group_id
  and  	 p_effective_date between cptip.effective_start_date  and cptip.effective_end_date;

Line: 425

  select cpt.name
  from   ben_cmbn_ptip_opt_f cpt
  where  cpt.cmbn_ptip_opt_id = p_cmbn_ptip_opt_id
  and    cpt.business_group_id = p_business_group_id
  and    p_effective_date between cpt.effective_start_date and cpt.effective_end_date;