APPS.PQP_COPY_EAT SQL Statements

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

Line: 18

  SELECT *
  FROM pqp_extract_attributes
  WHERE ext_dfn_id = p_curr_ext_dfn_id;

Line: 23

  SELECT pqp_extract_attributes_s.nextval
  FROM dual;

Line: 27

  SELECT name
  FROM ben_ext_dfn
  WHERE ext_dfn_id = p_new_ext_dfn_id;

Line: 32

  SELECT user_table_name
  FROM pay_user_tables
  WHERE user_table_id = p_user_table_id;

Line: 82

    INSERT INTO pqp_extract_attributes
    (extract_attribute_id
    ,ext_dfn_id
    ,ext_dfn_name
    ,ext_dfn_type
    ,ext_user_table_id
    ,ext_user_table_name
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
    )
    VALUES
    (l_new_seq_id
    ,p_new_ext_dfn_id
    ,l_new_ext_name
    ,r_ext_attr.ext_dfn_type
    ,l_new_put_id
    ,l_new_udt_name
    ,r_ext_attr.created_by
    ,r_ext_attr.creation_date
    ,r_ext_attr.last_updated_by
    ,r_ext_attr.last_update_date
    ,r_ext_attr.last_update_login
    ,1
    );