DBA Data[Home] [Help]

APPS.BEN_SEEDDATA_OBJECT SQL Statements

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

Line: 57

    select ler.ler_id,
           ler.typ_cd
    from   ben_ler_f ler
    where  ler.business_group_id+0 = p_business_group_id
    and    ler.typ_cd in ('DRVDAGE','DRVDLOS','DRVDCAL',
                          'DRVDHRW','DRVDTPF','DRVDCMP',
                          'DRVDLSELG','DRVDNLP','DRVDPOEELG',
                          'DRVDPOERT','DRVDVEC')
    and    p_effective_date
           between ler.effective_start_date
           and     ler.effective_end_date;