eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PAY_MX_LEGISLATION_INFO_F#

Source

View Text - Preformatted


select LEGISLATION_INFO_ID LEGISLATION_INFO_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, JURISDICTION_CODE JURISDICTION_CODE, LEGISLATION_INFO_TYPE LEGISLATION_INFO_TYPE, LEGISLATION_INFO1 LEGISLATION_INFO1, LEGISLATION_INFO2 LEGISLATION_INFO2, LEGISLATION_INFO3 LEGISLATION_INFO3, LEGISLATION_INFO4 LEGISLATION_INFO4, LEGISLATION_INFO5 LEGISLATION_INFO5, LEGISLATION_INFO6 LEGISLATION_INFO6, LEGISLATION_INFO7 LEGISLATION_INFO7, LEGISLATION_INFO8 LEGISLATION_INFO8, LEGISLATION_INFO9 LEGISLATION_INFO9, LEGISLATION_INFO10 LEGISLATION_INFO10, LEGISLATION_INFO11 LEGISLATION_INFO11, LEGISLATION_INFO12 LEGISLATION_INFO12, LEGISLATION_INFO13 LEGISLATION_INFO13, LEGISLATION_INFO14 LEGISLATION_INFO14, LEGISLATION_INFO15 LEGISLATION_INFO15, LEGISLATION_INFO16 LEGISLATION_INFO16, LEGISLATION_INFO17 LEGISLATION_INFO17, LEGISLATION_INFO18 LEGISLATION_INFO18, LEGISLATION_INFO19 LEGISLATION_INFO19, LEGISLATION_INFO20 LEGISLATION_INFO20, LEGISLATION_INFO21 LEGISLATION_INFO21, LEGISLATION_INFO22 LEGISLATION_INFO22, LEGISLATION_INFO23 LEGISLATION_INFO23, LEGISLATION_INFO24 LEGISLATION_INFO24, LEGISLATION_INFO25 LEGISLATION_INFO25, LEGISLATION_INFO26 LEGISLATION_INFO26, LEGISLATION_INFO27 LEGISLATION_INFO27, LEGISLATION_INFO28 LEGISLATION_INFO28, LEGISLATION_INFO29 LEGISLATION_INFO29, LEGISLATION_INFO30 LEGISLATION_INFO30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_MX_LEGISLATION_INFO_F"

View Text - HTML Formatted

SELECT LEGISLATION_INFO_ID LEGISLATION_INFO_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, JURISDICTION_CODE JURISDICTION_CODE
, LEGISLATION_INFO_TYPE LEGISLATION_INFO_TYPE
, LEGISLATION_INFO1 LEGISLATION_INFO1
, LEGISLATION_INFO2 LEGISLATION_INFO2
, LEGISLATION_INFO3 LEGISLATION_INFO3
, LEGISLATION_INFO4 LEGISLATION_INFO4
, LEGISLATION_INFO5 LEGISLATION_INFO5
, LEGISLATION_INFO6 LEGISLATION_INFO6
, LEGISLATION_INFO7 LEGISLATION_INFO7
, LEGISLATION_INFO8 LEGISLATION_INFO8
, LEGISLATION_INFO9 LEGISLATION_INFO9
, LEGISLATION_INFO10 LEGISLATION_INFO10
, LEGISLATION_INFO11 LEGISLATION_INFO11
, LEGISLATION_INFO12 LEGISLATION_INFO12
, LEGISLATION_INFO13 LEGISLATION_INFO13
, LEGISLATION_INFO14 LEGISLATION_INFO14
, LEGISLATION_INFO15 LEGISLATION_INFO15
, LEGISLATION_INFO16 LEGISLATION_INFO16
, LEGISLATION_INFO17 LEGISLATION_INFO17
, LEGISLATION_INFO18 LEGISLATION_INFO18
, LEGISLATION_INFO19 LEGISLATION_INFO19
, LEGISLATION_INFO20 LEGISLATION_INFO20
, LEGISLATION_INFO21 LEGISLATION_INFO21
, LEGISLATION_INFO22 LEGISLATION_INFO22
, LEGISLATION_INFO23 LEGISLATION_INFO23
, LEGISLATION_INFO24 LEGISLATION_INFO24
, LEGISLATION_INFO25 LEGISLATION_INFO25
, LEGISLATION_INFO26 LEGISLATION_INFO26
, LEGISLATION_INFO27 LEGISLATION_INFO27
, LEGISLATION_INFO28 LEGISLATION_INFO28
, LEGISLATION_INFO29 LEGISLATION_INFO29
, LEGISLATION_INFO30 LEGISLATION_INFO30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_MX_LEGISLATION_INFO_F"