APPS.BEN_DRR_BUS SQL Statements

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

Line: 113

    select null
    from   ben_dsgn_rqmt_f a
    where  a.dsgn_rqmt_id = p_dsgn_rqmt_id
    and    p_effective_date
           between a.effective_start_date
           and     a.effective_end_date;

Line: 204

     SELECT NULL
       FROM fnd_lookup_types_vl flt, fnd_lookup_values_vl flv
      WHERE flt.lookup_type = 'CONTACT'
        AND (   flv.security_group_id = 0
             OR flv.security_group_id IN (
                    SELECT security_group_id
                      FROM fnd_security_groups
                     WHERE security_group_key =
                                               TO_CHAR (cv_business_group_id))
            )
        AND flt.lookup_type = flv.lookup_type
        AND flt.security_group_id = flv.security_group_id
        AND flv.lookup_code = cv_lookup_code
        AND cv_effective_date BETWEEN NVL (flv.start_date_active,
                                           cv_effective_date
                                          )
                                  AND NVL (flv.end_date_active,
                                           cv_effective_date
                                          );

Line: 320

    select 'X'
    from   ben_dsgn_rqmt_rlshp_typ
    where  dsgn_rqmt_id = p_dsgn_rqmt_id
    and    rlshp_typ_cd = p_rlshp_typ_cd
    and    business_group_id = p_business_group_id
    and    dsgn_rqmt_rlshp_typ_id <> nvl(p_dsgn_rqmt_rlshp_typ_id, -999);

Line: 359

Procedure insert_validate(p_rec in ben_drr_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 392

End insert_validate;

Line: 397

Procedure update_validate(p_rec in ben_drr_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 430

End update_validate;

Line: 435

Procedure delete_validate(p_rec in ben_drr_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 446

End delete_validate;

Line: 459

    select a.legislation_code
    from   per_business_groups a,
           ben_dsgn_rqmt_rlshp_typ b
    where b.dsgn_rqmt_rlshp_typ_id      = p_dsgn_rqmt_rlshp_typ_id
    and   a.business_group_id = b.business_group_id;