Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_ELEMENT_SPAN_USAGES_V |
SELECT ESU.ROWID
, ESU.ELEMENT_SPAN_USAGE_ID
, ESU.BUSINESS_GROUP_ID
, ESU.LEGISLATION_CODE
, ESU.TIME_SPAN_ID
, TSP.START_TIME_DEF_ID
, TDF1.DEFINITION_NAME
, TSP.END_TIME_DEF_ID
, TDF2.DEFINITION_NAME
, ESU.RETRO_COMPONENT_USAGE_ID
, ESU.ADJUSTMENT_TYPE
, HR_GENERAL.DECODE_LOOKUP( 'RETRO_ADJUSTMENT_TYPE'
, ESU.ADJUSTMENT_TYPE)
, ESU.RETRO_ELEMENT_TYPE_ID
, ETP.ELEMENT_NAME
, ESU.OBJECT_VERSION_NUMBER
, ESU.CREATION_DATE
, ESU.CREATED_BY
, ESU.LAST_UPDATE_DATE
, ESU.LAST_UPDATED_BY
, ESU.LAST_UPDATE_LOGIN
FROM PAY_ELEMENT_SPAN_USAGES ESU
, PAY_ELEMENT_TYPES ETP
, PAY_TIME_SPANS TSP
, PAY_TIME_DEFINITIONS TDF1
, PAY_TIME_DEFINITIONS TDF2
WHERE ETP.ELEMENT_TYPE_ID = ESU.RETRO_ELEMENT_TYPE_ID
AND TSP.TIME_SPAN_ID = ESU.TIME_SPAN_ID
AND TDF1.TIME_DEFINITION_ID = TSP.START_TIME_DEF_ID
AND TDF2.TIME_DEFINITION_ID = TSP.END_TIME_DEF_ID