APPS.BEN_OLA_BUS SQL Statements

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

Line: 89

    select null
    from   fnd_form_functions_vl ff
    where  ff.function_name = p_function_name;

Line: 103

     select null
     from hr_lookups
     where lookup_code  = p_function_name
     and lookup_type    = 'BEN_ON_LINE_ACT'
     and enabled_flag   = 'Y'
     and TRUNC(sysdate) between
           nvl(start_date_active, TRUNC(sysdate))
           and nvl(end_date_active, TRUNC(sysdate))
    union
    select null
    from   fnd_form frm,
           fnd_form_functions fnc
    where  frm.form_name      = 'PERWSHRG'
    and    frm.form_id        = fnc.form_id
    and    frm.application_id = fnc.application_id
    and    fnc.function_name  = p_function_name;

Line: 274

  Cursor c1 is select null
        from ben_csr_activities
        where (csr_activities_id <> p_csr_activities_id or p_csr_activities_id is null)and
              function_name = p_function_name and
              business_group_id = p_business_group_id;

Line: 355

    select 1
    from   BEN_CSR_ACTIVITIES bca
    where  bca.business_group_id +0 = p_business_group_id
    and    bca.csr_activities_id <> nvl(p_csr_activities_id,-1)
    and    bca.ordr_num = p_ordr_num
    and	   nvl(bca.end_date, hr_api.g_eot) >= nvl(p_csr_start_date, hr_api.g_sot)
    and    nvl(bca.start_date, hr_api.g_sot) <= nvl(p_csr_end_date, hr_api.g_eot);

Line: 411

Procedure insert_validate(p_rec in ben_ola_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 455

End insert_validate;

Line: 460

Procedure update_validate(p_rec in ben_ola_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 504

End update_validate;

Line: 509

Procedure delete_validate(p_rec in ben_ola_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 519

End delete_validate;

Line: 532

    select a.legislation_code
    from   per_business_groups a,
           ben_csr_activities b
    where b.csr_activities_id      = p_csr_activities_id
    and   a.business_group_id = b.business_group_id;