VIEW: APPS.PAYBV_ELEMENT_LINK

Source

View Text - Preformatted

SELECT pel.EFFECTIVE_START_DATE , pel.EFFECTIVE_END_DATE , hr_bis.bis_decode_lookup('COSTABLE_TYPE',pel.COSTABLE_TYPE) COSTABLE_TYPE , hr_bis.bis_decode_lookup('YES_NO', pel.LINK_TO_ALL_PAYROLLS_FLAG) LINK_TO_ALL_PAYROLLS_FLAG , hr_bis.bis_decode_lookup('YES_NO', pel.MULTIPLY_VALUE_FLAG) MULTIPLY_VALUE_FLAG , hr_bis.bis_decode_lookup('YES_NO', pel.STANDARD_LINK_FLAG) STANDARD_LINK_FLAG , hr_bis.bis_decode_lookup('YES_NO', pel.TRANSFER_TO_GL_FLAG) TRANSFER_TO_GL_FLAG , hr_bis.bis_decode_lookup('EMP_CAT', pel.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY , pel.QUALIFYING_AGE , pel.QUALIFYING_LENGTH_OF_SERVICE , hr_bis.bis_decode_lookup('QUALIFYING_UNITS', pel.QUALIFYING_UNITS) QUALIFYING_UNITS , '_DF:PAY:PAY_ELEMENT_LINKS:pel' , pel.ATTRIBUTE_CATEGORY, pel.ATTRIBUTE1, pel.ATTRIBUTE2, pel.ATTRIBUTE3, pel.ATTRIBUTE4, pel.ATTRIBUTE5, pel.ATTRIBUTE6, pel.ATTRIBUTE7, pel.ATTRIBUTE8, pel.ATTRIBUTE9, pel.ATTRIBUTE10, pel.ATTRIBUTE11, pel.ATTRIBUTE12, pel.ATTRIBUTE13, pel.ATTRIBUTE14, pel.ATTRIBUTE15, pel.ATTRIBUTE16, pel.ATTRIBUTE17, pel.ATTRIBUTE18, pel.ATTRIBUTE19, pel.ATTRIBUTE20, pel.COSTABLE_TYPE COSTABLE_TYPE_CODE , pel.LINK_TO_ALL_PAYROLLS_FLAG LINK_TO_ALL_PAYROLLS_FLAG_CODE , pel.MULTIPLY_VALUE_FLAG MULTIPLY_VALUE_FLAG_CODE , pel.STANDARD_LINK_FLAG STANDARD_LINK_FLAG_CODE , pel.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG_CODE , pel.EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY_CODE , pel.QUALIFYING_UNITS QUALIFYING_UNITS_CODE , pel.ELEMENT_LINK_ID , pel.PAYROLL_ID , pel.JOB_ID , pel.POSITION_ID , pel.PEOPLE_GROUP_ID , pel.COST_ALLOCATION_KEYFLEX_ID , pel.ORGANIZATION_ID , pel.ELEMENT_TYPE_ID , pel.LOCATION_ID , pel.GRADE_ID , pel.BALANCING_KEYFLEX_ID , pel.BUSINESS_GROUP_ID , pel.ELEMENT_SET_ID , pel.PAY_BASIS_ID , pel.COMMENT_ID , pel.LAST_UPDATE_DATE , pel.LAST_UPDATED_BY , pel.LAST_UPDATE_LOGIN , pel.CREATED_BY , pel.CREATION_DATE , pel.OBJECT_VERSION_NUMBER , CASE WHEN (pel.business_group_id = nvl(hr_bis.get_sec_profile_bg_id, pel.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_element_links_f pel WITH READ ONLY

View Text - HTML Formatted

SELECT PEL.EFFECTIVE_START_DATE
, PEL.EFFECTIVE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('COSTABLE_TYPE'
, PEL.COSTABLE_TYPE) COSTABLE_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.LINK_TO_ALL_PAYROLLS_FLAG) LINK_TO_ALL_PAYROLLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.MULTIPLY_VALUE_FLAG) MULTIPLY_VALUE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.STANDARD_LINK_FLAG) STANDARD_LINK_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEL.TRANSFER_TO_GL_FLAG) TRANSFER_TO_GL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('EMP_CAT'
, PEL.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY
, PEL.QUALIFYING_AGE
, PEL.QUALIFYING_LENGTH_OF_SERVICE
, HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, PEL.QUALIFYING_UNITS) QUALIFYING_UNITS
, '_DF:PAY:PAY_ELEMENT_LINKS:PEL'
, PEL.ATTRIBUTE_CATEGORY
, PEL.ATTRIBUTE1
, PEL.ATTRIBUTE2
, PEL.ATTRIBUTE3
, PEL.ATTRIBUTE4
, PEL.ATTRIBUTE5
, PEL.ATTRIBUTE6
, PEL.ATTRIBUTE7
, PEL.ATTRIBUTE8
, PEL.ATTRIBUTE9
, PEL.ATTRIBUTE10
, PEL.ATTRIBUTE11
, PEL.ATTRIBUTE12
, PEL.ATTRIBUTE13
, PEL.ATTRIBUTE14
, PEL.ATTRIBUTE15
, PEL.ATTRIBUTE16
, PEL.ATTRIBUTE17
, PEL.ATTRIBUTE18
, PEL.ATTRIBUTE19
, PEL.ATTRIBUTE20
, PEL.COSTABLE_TYPE COSTABLE_TYPE_CODE
, PEL.LINK_TO_ALL_PAYROLLS_FLAG LINK_TO_ALL_PAYROLLS_FLAG_CODE
, PEL.MULTIPLY_VALUE_FLAG MULTIPLY_VALUE_FLAG_CODE
, PEL.STANDARD_LINK_FLAG STANDARD_LINK_FLAG_CODE
, PEL.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG_CODE
, PEL.EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY_CODE
, PEL.QUALIFYING_UNITS QUALIFYING_UNITS_CODE
, PEL.ELEMENT_LINK_ID
, PEL.PAYROLL_ID
, PEL.JOB_ID
, PEL.POSITION_ID
, PEL.PEOPLE_GROUP_ID
, PEL.COST_ALLOCATION_KEYFLEX_ID
, PEL.ORGANIZATION_ID
, PEL.ELEMENT_TYPE_ID
, PEL.LOCATION_ID
, PEL.GRADE_ID
, PEL.BALANCING_KEYFLEX_ID
, PEL.BUSINESS_GROUP_ID
, PEL.ELEMENT_SET_ID
, PEL.PAY_BASIS_ID
, PEL.COMMENT_ID
, PEL.LAST_UPDATE_DATE
, PEL.LAST_UPDATED_BY
, PEL.LAST_UPDATE_LOGIN
, PEL.CREATED_BY
, PEL.CREATION_DATE
, PEL.OBJECT_VERSION_NUMBER
, CASE WHEN (PEL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEL.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_ELEMENT_LINKS_F PEL WITH READ ONLY