VIEW: APPS.HRBV_QUALIFICATIONS_V

Source

View Text - Preformatted

SELECT QUAT.TITLE, QUA.GRADE_ATTAINED, QUA.STATUS, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES',QUA.STATUS), QUA.AWARDED_DATE, QUA.FEE, QUA.FEE_CURRENCY, QUA.TRAINING_COMPLETED_AMOUNT, QUA.REIMBURSEMENT_ARRANGEMENTS, QUA.TRAINING_COMPLETED_UNITS, QUA.TOTAL_TRAINING_AMOUNT, QUA.START_DATE, QUA.END_DATE, QUA.LICENSE_NUMBER, QUA.EXPIRY_DATE, QUA.LICENSE_RESTRICTIONS, QUA.PROJECTED_COMPLETION_DATE, QUA.AWARDING_BODY, QUA.TUITION_METHOD, HR_BIS.BIS_DECODE_LOOKUP('PER_TUITION_METHODS',QUA.TUITION_METHOD), QUA.GROUP_RANKING, QUA.COMMENTS, QUA.QUA_INFORMATION_CATEGORY, QUA.QUA_INFORMATION1, QUA.QUA_INFORMATION2, QUA.QUA_INFORMATION3, QUA.QUA_INFORMATION4, QUA.QUA_INFORMATION5, QUA.QUA_INFORMATION6, QUA.QUA_INFORMATION7, QUA.QUA_INFORMATION8, QUA.QUA_INFORMATION9, QUA.QUA_INFORMATION10, QUA.QUA_INFORMATION11, QUA.QUA_INFORMATION12, QUA.QUA_INFORMATION13, QUA.QUA_INFORMATION14, QUA.QUA_INFORMATION15, QUA.QUA_INFORMATION16, QUA.QUA_INFORMATION17, QUA.QUA_INFORMATION18, QUA.QUA_INFORMATION19, QUA.QUA_INFORMATION20, QUA.PROFESSIONAL_BODY_NAME, QUA.MEMBERSHIP_NUMBER, QUA.MEMBERSHIP_CATEGORY, QUA.SUBSCRIPTION_PAYMENT_METHOD, '_DF:PER:PER_QUALIFICATIONS:QUA', QUA.QUALIFICATION_ID, QUA.BUSINESS_GROUP_ID, QUA.PERSON_ID, QUA.QUALIFICATION_TYPE_ID, QUA.ATTENDANCE_ID, QUA.PARTY_ID, QUA.LAST_UPDATE_DATE, QUA.LAST_UPDATED_BY, QUA.CREATED_BY, QUA.CREATION_DATE, CASE WHEN QUA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, QUA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_QUALIFICATIONS QUA, PER_QUALIFICATIONS_TL QUAT WHERE QUA.QUALIFICATION_ID = QUAT.QUALIFICATION_ID AND QUAT.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT QUAT.TITLE
, QUA.GRADE_ATTAINED
, QUA.STATUS
, HR_BIS.BIS_DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, QUA.STATUS)
, QUA.AWARDED_DATE
, QUA.FEE
, QUA.FEE_CURRENCY
, QUA.TRAINING_COMPLETED_AMOUNT
, QUA.REIMBURSEMENT_ARRANGEMENTS
, QUA.TRAINING_COMPLETED_UNITS
, QUA.TOTAL_TRAINING_AMOUNT
, QUA.START_DATE
, QUA.END_DATE
, QUA.LICENSE_NUMBER
, QUA.EXPIRY_DATE
, QUA.LICENSE_RESTRICTIONS
, QUA.PROJECTED_COMPLETION_DATE
, QUA.AWARDING_BODY
, QUA.TUITION_METHOD
, HR_BIS.BIS_DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD)
, QUA.GROUP_RANKING
, QUA.COMMENTS
, QUA.QUA_INFORMATION_CATEGORY
, QUA.QUA_INFORMATION1
, QUA.QUA_INFORMATION2
, QUA.QUA_INFORMATION3
, QUA.QUA_INFORMATION4
, QUA.QUA_INFORMATION5
, QUA.QUA_INFORMATION6
, QUA.QUA_INFORMATION7
, QUA.QUA_INFORMATION8
, QUA.QUA_INFORMATION9
, QUA.QUA_INFORMATION10
, QUA.QUA_INFORMATION11
, QUA.QUA_INFORMATION12
, QUA.QUA_INFORMATION13
, QUA.QUA_INFORMATION14
, QUA.QUA_INFORMATION15
, QUA.QUA_INFORMATION16
, QUA.QUA_INFORMATION17
, QUA.QUA_INFORMATION18
, QUA.QUA_INFORMATION19
, QUA.QUA_INFORMATION20
, QUA.PROFESSIONAL_BODY_NAME
, QUA.MEMBERSHIP_NUMBER
, QUA.MEMBERSHIP_CATEGORY
, QUA.SUBSCRIPTION_PAYMENT_METHOD
, '_DF:PER:PER_QUALIFICATIONS:QUA'
, QUA.QUALIFICATION_ID
, QUA.BUSINESS_GROUP_ID
, QUA.PERSON_ID
, QUA.QUALIFICATION_TYPE_ID
, QUA.ATTENDANCE_ID
, QUA.PARTY_ID
, QUA.LAST_UPDATE_DATE
, QUA.LAST_UPDATED_BY
, QUA.CREATED_BY
, QUA.CREATION_DATE
, CASE WHEN QUA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, QUA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_QUALIFICATIONS QUA
, PER_QUALIFICATIONS_TL QUAT
WHERE QUA.QUALIFICATION_ID = QUAT.QUALIFICATION_ID
AND QUAT.LANGUAGE = USERENV('LANG') WITH READ ONLY