Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_RETRO_COMPONENT_USAGES_V |
SELECT PRCU.ROWID ROW_ID
, PRCU.RETRO_COMPONENT_USAGE_ID
, PRCU.BUSINESS_GROUP_ID
, PRCU.LEGISLATION_CODE
, PRCU.RETRO_COMPONENT_ID
, PTR.COMPONENT_NAME
, PRCU.CREATOR_ID
, PRCU.CREATOR_TYPE
, PRCU.DEFAULT_COMPONENT
, PRCU.REPROCESS_TYPE
, HL.MEANING D_REPROCESS_TYPE
, PRCU.OBJECT_VERSION_NUMBER
, PRCU.CREATION_DATE
, PRCU.CREATED_BY
, PRCU.LAST_UPDATE_DATE
, PRCU.LAST_UPDATED_BY
, PRCU.LAST_UPDATE_LOGIN
, PRCU.REPLACE_RUN_FLAG
, PRCU.USE_OVERRIDE_DATES
FROM PAY_RETRO_COMPONENT_USAGES PRCU
, PAY_RETRO_COMPONENTS PTR
, HR_LOOKUPS HL
WHERE PTR.RETRO_COMPONENT_ID = PRCU.RETRO_COMPONENT_ID
AND HL.LOOKUP_TYPE = 'RETRO_REPROCESS_TYPE'
AND HL.LOOKUP_CODE = PRCU.REPROCESS_TYPE