FND Design Data [Home] [Help]

View: PAY_ASSIGNMENT_LINK_USAGES_X

Product: PAY - Payroll
Description: Date-effective view.
Implementation/DBA Data: ViewAPPS.PAY_ASSIGNMENT_LINK_USAGES_X
View Text

SELECT ASSIGNMENT_LINK_USAGE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ELEMENT_LINK_ID
, ASSIGNMENT_ID
FROM PAY_ASSIGNMENT_LINK_USAGES_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE

Columns

Name
ASSIGNMENT_LINK_USAGE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ELEMENT_LINK_ID
ASSIGNMENT_ID