VIEW: APPS.PAY_ELEMENT_SPAN_USAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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