APPS.BEN_RELATED_PERSON_LER_API SQL Statements

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

Line: 29

  select 'Y'
  from   ben_ptnl_ler_for_per
  where  person_id                             = p_person_id
  and    ler_id                                = p_ler_id
 /* commenting for bug 5968595
 and    PTNL_LER_FOR_PER_STAT_CD              <> 'VOIDD' /* Bug : 4624390 */
  and    lf_evt_ocrd_dt                        = p_lf_evt_ocrd_dt;

Line: 123

               p_program_update_date      => sysdate,
               p_ntfn_dt                  => trunc(sysdate),
               p_dtctd_dt                 => p_effective_date);