View: PAY_ELEMENT_LINKS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_ELEMENT_LINKS_V

View Text

SELECT LINK.ROWID ROW_ID
, LINK.ELEMENT_LINK_ID
, LINK.EFFECTIVE_START_DATE
, LINK.EFFECTIVE_END_DATE
, LINK.PAYROLL_ID
, PAYROLL.PAYROLL_NAME
, LINK.JOB_ID
, JBT.NAME JOB_NAME
, LINK.POSITION_ID
, PFT.NAME POSITION_NAME
, LINK.PEOPLE_GROUP_ID
, LINK.COST_ALLOCATION_KEYFLEX_ID
, LINK.ORGANIZATION_ID
, ORGANIZATIONTL.NAME ORGANIZATION_NAME
, LINK.LOCATION_ID
, LOCATIONTL.LOCATION_CODE
, LINK.GRADE_ID
, GRT.NAME GRADE_NAME
, LINK.EMPLOYMENT_CATEGORY
, CATEGORY.MEANING EMPLOYMENT_CATEGORY_NAME
, LINK.QUALIFYING_AGE
, LINK.QUALIFYING_LENGTH_OF_SERVICE
, LINK.QUALIFYING_UNITS
, UNIT.MEANING QUALIFYING_UNIT_NAME
, LINK.ELEMENT_TYPE_ID
, ELEMENTTL.ELEMENT_NAME
, ELEMENT.INPUT_CURRENCY_CODE
, ELEMENT.PROCESSING_TYPE
, ELEMENTTL.DESCRIPTION
, ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG
, ELEMENT.BENEFIT_CLASSIFICATION_ID
, CLASSIFICATIONTL.CLASSIFICATION_NAME
, CLASSIFICATION.COSTING_DEBIT_OR_CREDIT
, CLASSIFICATION.COSTABLE_FLAG CLASSIFICATION_COSTABLE_FLAG
, LINK.BALANCING_KEYFLEX_ID
, LINK.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, LINK.ELEMENT_SET_ID
, ELEMENT_SET.ELEMENT_SET_NAME
, LINK.PAY_BASIS_ID
, PAY_BASIS.NAME PAY_BASIS_NAME
, LINK.COSTABLE_TYPE
, LINK.LINK_TO_ALL_PAYROLLS_FLAG
, LINK.MULTIPLY_VALUE_FLAG
, LINK.STANDARD_LINK_FLAG
, LINK.STANDARD_LINK_FLAG OLD_STANDARD_LINK_FLAG
, LINK.TRANSFER_TO_GL_FLAG
, LINK.COMMENT_ID
, BENEFIT.CONTRIBUTIONS_USED
, LINK.ATTRIBUTE_CATEGORY
, LINK.ATTRIBUTE1
, LINK.ATTRIBUTE2
, LINK.ATTRIBUTE3
, LINK.ATTRIBUTE4
, LINK.ATTRIBUTE5
, LINK.ATTRIBUTE6
, LINK.ATTRIBUTE7
, LINK.ATTRIBUTE8
, LINK.ATTRIBUTE9
, LINK.ATTRIBUTE10
, LINK.ATTRIBUTE11
, LINK.ATTRIBUTE12
, LINK.ATTRIBUTE13
, LINK.ATTRIBUTE14
, LINK.ATTRIBUTE15
, LINK.ATTRIBUTE16
, LINK.ATTRIBUTE17
, LINK.ATTRIBUTE18
, LINK.ATTRIBUTE19
, LINK.ATTRIBUTE20
, LINK.LAST_UPDATE_DATE
, LINK.LAST_UPDATED_BY
, LINK.LAST_UPDATE_LOGIN
, LINK.CREATED_BY
, LINK.CREATION_DATE
FROM PAY_ELEMENT_LINKS_F LINK
, FND_SESSIONS CURRENT_SESSION
, PER_JOBS_TL JBT
, PER_GRADES_TL GRT
, PAY_ELEMENT_SETS ELEMENT_SET
, HR_LOCATIONS_ALL_TL LOCATIONTL
, HR_LOCATIONS_NO_JOIN LOCATION
, HR_ALL_POSITIONS_F_TL PFT
, PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, BEN_BENEFIT_CLASSIFICATIONS BENEFIT
, PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL
, PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION
, PER_PAY_BASES PAY_BASIS
, PAY_ALL_PAYROLLS_F PAYROLL
, HR_LOOKUPS UNIT
, HR_LOOKUPS CATEGORY
, HR_ALL_ORGANIZATION_UNITS_TL ORGANIZATIONTL
, HR_ALL_ORGANIZATION_UNITS ORGANIZATION
WHERE LOCATIONTL.LOCATION_ID (+) =LOCATION.LOCATION_ID
AND DECODE(LOCATIONTL.LOCATION_ID
, NULL
, '1'
, LOCATIONTL.LANGUAGE) = DECODE(LOCATIONTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND ORGANIZATIONTL.ORGANIZATION_ID (+) = ORGANIZATION.ORGANIZATION_ID
AND DECODE(ORGANIZATIONTL.ORGANIZATION_ID
, NULL
, '1'
, ORGANIZATIONTL.LANGUAGE) = DECODE(ORGANIZATIONTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID
AND CLASSIFICATIONTL.LANGUAGE = USERENV('LANG')
AND ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
AND ELEMENTTL.LANGUAGE = USERENV('LANG')
AND (UNIT.LOOKUP_CODE(+) = LINK.QUALIFYING_UNITS
AND UNIT.LOOKUP_TYPE(+) = 'QUALIFYING_UNITS'
AND (UNIT.APPLICATION_ID BETWEEN 800
AND 899 OR UNIT.APPLICATION_ID IS NULL))
AND (CATEGORY.LOOKUP_CODE(+) = LINK.EMPLOYMENT_CATEGORY
AND CATEGORY.LOOKUP_TYPE(+) = 'EMP_CAT'
AND (CATEGORY.APPLICATION_ID BETWEEN 800
AND 899 OR CATEGORY.APPLICATION_ID IS NULL))
AND LINK.ELEMENT_TYPE_ID = ELEMENT.ELEMENT_TYPE_ID
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND ELEMENT.CLASSIFICATION_ID = CLASSIFICATION.CLASSIFICATION_ID
AND LINK.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND LINK.GRADE_ID = GRT.GRADE_ID(+)
AND GRT.LANGUAGE(+) = USERENV('LANG')
AND LINK.ELEMENT_SET_ID = ELEMENT_SET.ELEMENT_SET_ID(+)
AND LINK.LOCATION_ID = LOCATION.LOCATION_ID(+)
AND LINK.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND LINK.PAY_BASIS_ID = PAY_BASIS.PAY_BASIS_ID(+)
AND LINK.ORGANIZATION_ID = ORGANIZATION.ORGANIZATION_ID(+)
AND ELEMENT.BENEFIT_CLASSIFICATION_ID=BENEFIT.BENEFIT_CLASSIFICATION_ID(+)
AND LINK.PAYROLL_ID = PAYROLL.PAYROLL_ID(+)
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN NVL(PAYROLL.EFFECTIVE_START_DATE
, CURRENT_SESSION.EFFECTIVE_DATE)
AND NVL(PAYROLL.EFFECTIVE_END_DATE
, CURRENT_SESSION.EFFECTIVE_DATE)
AND CURRENT_SESSION.SESSION_ID = USERENV('SESSIONID')
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE

Columns