[Home] [Help]
View: PAY_ELEMENT_LINKS_D
View Text
SELECT ELEMENT.ELEMENT_LINK_ID
, ELEMENT.EFFECTIVE_START_DATE
, ELEMENT.EFFECTIVE_END_DATE
, ELESET.ELEMENT_SET_NAME
, HR5.MEANING
, HR2.MEANING
, HR3.MEANING
, HR4.MEANING
, ELEMENT.QUALIFYING_AGE
, ELEMENT.QUALIFYING_LENGTH_OF_SERVICE
, HR1.MEANING
, ELEMENT.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_ELEMENT_LINKS_F ELEMENT
, PAY_ELEMENT_TYPES_F ELETYPE
, PAY_ELEMENT_SETS ELESET
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, HR_LOOKUPS HR3
, HR_LOOKUPS HR4
, HR_LOOKUPS HR5
, FND_USER FUSER
WHERE ELETYPE.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID
AND ELEMENT.EFFECTIVE_START_DATE BETWEEN ELETYPE.EFFECTIVE_START_DATE
AND ELETYPE.EFFECTIVE_END_DATE
AND ELESET.ELEMENT_SET_ID (+)= ELEMENT.ELEMENT_SET_ID
AND HR1.LOOKUP_CODE (+)= ELEMENT.QUALIFYING_UNITS
AND HR1.LOOKUP_TYPE (+)= 'QUALIFYING_UNITS'
AND HR2.LOOKUP_CODE = ELEMENT.MULTIPLY_VALUE_FLAG
AND HR2.LOOKUP_TYPE = 'YES_NO'
AND HR3.LOOKUP_CODE = ELEMENT.STANDARD_LINK_FLAG
AND HR3.LOOKUP_TYPE = 'YES_NO'
AND HR4.LOOKUP_CODE = ELEMENT.TRANSFER_TO_GL_FLAG
AND HR4.LOOKUP_TYPE = 'YES_NO'
AND HR5.LOOKUP_CODE = ELEMENT.COSTABLE_TYPE
AND HR5.LOOKUP_TYPE = 'COSTABLE_TYPE'
AND FUSER.USER_ID (+)= ELEMENT.LAST_UPDATED_BY
Columns
Name |
ELEMENT_LINK_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
DISTRIBUTION_SET |
COSTABLE_TYPE |
MULTIPLY_VALUE |
STANDARD |
TRANSFER_TO_GL |
AGE |
LENGTH_OF_SERVICE |
UNITS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |