APPS.AMS_LST_RULE_USAGES SQL Statements

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

Line: 21

      SELECT ams_list_rule_usages_s.NEXTVAL
      FROM DUAL;

Line: 49

      delete from ams_list_rule_usages
      where list_header_id = p_list_header_id;

Line: 52

   INSERT INTO ams_list_rule_usages (
    list_rule_usage_id              ,
    list_header_id                  ,
    list_rule_id                    ,
    last_update_date                ,
    last_updated_by                 ,
    creation_date                   ,
    created_by                      ,
    last_update_login               ,
    object_version_number           ,
    active_from_date                ,
    active_to_date                  ,
    priority                        ,
    security_group_id
  )
  values (
    l_list_rule_usage_id,
    p_list_header_id,
    p_list_rule_id,
    sysdate,
    fnd_global.user_id,
    sysdate,
    fnd_global.user_id,
    fnd_global.conc_login_id,
    1,
    sysdate ,
    '',
    '',
    ''
  );