Rahmadnet

SQL Add Alert

Sep 2nd, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT ht_salarycomponent_id AS referencekey_id,
  2.     ad_column_identifier('HT_Salary Component', ht_salarycomponent_id, 'en_US') AS record_id,
  3.     0 AS ad_role_id,
  4.     NULL AS ad_user_id,
  5.     ad_client_id, ad_org_id,
  6.     now() AS created, 0 AS createdby,
  7.     now() AS updated, 0 AS updatedby,
  8.     'Y' AS isactive,description,
  9.     first_name, last_name,
  10.     isearning,man,woman
  11.     FROM ht_salarycomponent
  12.     WHERE isearning = 'Y'
  13.     AND woman = 'N'
Advertisement
Add Comment
Please, Sign In to add comment