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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PAY_MX_LEGISLATION_INFO_F

Object Details

Object Name:	PAY_MX_LEGISLATION_INFO_F
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_MX_LEGISLATION_INFO_F
Subobject Name:
Status:	VALID

Keeps legislation specific data for Mexico

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_MX_LEGISLATION_INFO_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEGISLATION_INFO_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE ZD_EDITION_NAME
PAY_MX_LEGISLATION_INFO_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEGISLATION_INFO1 LEGISLATION_INFO2 LEGISLATION_INFO3 LEGISLATION_INFO4 LEGISLATION_INFO5

Columns

Name	Datatype	Length	Mandatory	Comments
LEGISLATION_INFO_ID	NUMBER	(9)	Yes	Primary key.
EFFECTIVE_START_DATE	DATE		Yes	Date after which current record is valid
EFFECTIVE_END_DATE	DATE		Yes	Date before which current record is valid
JURISDICTION_CODE	VARCHAR2	(30)		Jurisdiction code of current record
LEGISLATION_INFO_TYPE	VARCHAR2	(30)	Yes	Legislation Info Type
LEGISLATION_INFO1	VARCHAR2	(200)		Segment 1
LEGISLATION_INFO2	VARCHAR2	(200)		Segment 2
LEGISLATION_INFO3	VARCHAR2	(200)		Segment 3
LEGISLATION_INFO4	VARCHAR2	(200)		Segment 4
LEGISLATION_INFO5	VARCHAR2	(200)		Segment 5
LEGISLATION_INFO6	VARCHAR2	(200)		Segment 6
LEGISLATION_INFO7	VARCHAR2	(200)		Segment 7
LEGISLATION_INFO8	VARCHAR2	(200)		Segment 8
LEGISLATION_INFO9	VARCHAR2	(200)		Segment 9
LEGISLATION_INFO10	VARCHAR2	(200)		Segment 10
LEGISLATION_INFO11	VARCHAR2	(200)		Segment 11
LEGISLATION_INFO12	VARCHAR2	(200)		Segment 12
LEGISLATION_INFO13	VARCHAR2	(200)		Segment 13
LEGISLATION_INFO14	VARCHAR2	(200)		Segment 14
LEGISLATION_INFO15	VARCHAR2	(200)		Segment 15
LEGISLATION_INFO16	VARCHAR2	(200)		Segment 16
LEGISLATION_INFO17	VARCHAR2	(200)		Segment 17
LEGISLATION_INFO18	VARCHAR2	(200)		Segment 18
LEGISLATION_INFO19	VARCHAR2	(200)		Segment 19
LEGISLATION_INFO20	VARCHAR2	(200)		Segment 20
LEGISLATION_INFO21	VARCHAR2	(200)		Segment 21
LEGISLATION_INFO22	VARCHAR2	(200)		Segment 22
LEGISLATION_INFO23	VARCHAR2	(200)		Segment 23
LEGISLATION_INFO24	VARCHAR2	(200)		Segment 24
LEGISLATION_INFO25	VARCHAR2	(200)		Segment 25
LEGISLATION_INFO26	VARCHAR2	(200)		Segment 26
LEGISLATION_INFO27	VARCHAR2	(200)		Segment 27
LEGISLATION_INFO28	VARCHAR2	(200)		Segment 28
LEGISLATION_INFO29	VARCHAR2	(200)		Segment 29
LEGISLATION_INFO30	VARCHAR2	(200)		Segment 30
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

HR.PAY_MX_LEGISLATION_INFO_F does not reference any database object

HR.PAY_MX_LEGISLATION_INFO_F is referenced by following:

HR: PAY_MX_LEGISLATION_INFO_F#