VIEW: APPS.PAY_ELEMENT_LINKS_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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