VIEW: APPS.IRCFV_CANDIDATE_QUALFICATIONS

Source

View Text - Preformatted

SELECT par.person_name candidate_name ,qua.title qualification_title ,qua.grade_attained grade_attained ,qua.awarded_date awarded_date ,hr_bis.bis_decode_lookup('PER_CATEGORIES', qut.category) qualification_category ,qut.name qualification_type_name ,qut.rank qualification_type_rank ,qua.start_date qualification_start_date ,qua.end_date qualification_end_date ,qua.projected_completion_date projected_completion_date ,qua.group_ranking group_ranking ,qua.comments qualification_comments ,qua.license_number license_number ,qua.license_restrictions licence_restrictions ,qua.expiry_date expiry_date ,hr_bis.bis_decode_lookup('PER_TUITION_METHODS',qua.tuition_method) tuition_method ,qua.reimbursement_arrangements reimbursement_arrangements ,qua.training_completed_amount training_completed_amount ,qua.total_training_amount total_training_amount ,qua.training_completed_units training_completed_units ,qua.professional_body_name professional_body_name ,qua.membership_number membership_number ,qua.membership_category membership_category ,qua.subscription_payment_method subscription_payment_method ,'_DF:PER:PER_QUALIFICATIONS:qua' ,qut.category qualification_category_code ,qua.tuition_method tuition_method_code ,qua.qualification_id qualification_id ,qua.party_id party_id ,qut.qualification_type_id qualification_type_id FROM hz_person_profiles par ,irc_notification_preferences inp ,per_qualifications qua ,per_qualification_types qut WHERE par.party_id = qua.party_id AND inp.party_id = par.party_id AND inp.allow_access = 'Y' AND qua.qualification_type_id = qut.qualification_type_id AND trunc(sysdate) between NVL(par.effective_start_date ,trunc(sysdate)) and NVL(par.effective_end_date , sysdate) WITH READ ONLY

View Text - HTML Formatted

SELECT PAR.PERSON_NAME CANDIDATE_NAME
, QUA.TITLE QUALIFICATION_TITLE
, QUA.GRADE_ATTAINED GRADE_ATTAINED
, QUA.AWARDED_DATE AWARDED_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PER_CATEGORIES'
, QUT.CATEGORY) QUALIFICATION_CATEGORY
, QUT.NAME QUALIFICATION_TYPE_NAME
, QUT.RANK QUALIFICATION_TYPE_RANK
, QUA.START_DATE QUALIFICATION_START_DATE
, QUA.END_DATE QUALIFICATION_END_DATE
, QUA.PROJECTED_COMPLETION_DATE PROJECTED_COMPLETION_DATE
, QUA.GROUP_RANKING GROUP_RANKING
, QUA.COMMENTS QUALIFICATION_COMMENTS
, QUA.LICENSE_NUMBER LICENSE_NUMBER
, QUA.LICENSE_RESTRICTIONS LICENCE_RESTRICTIONS
, QUA.EXPIRY_DATE EXPIRY_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD) TUITION_METHOD
, QUA.REIMBURSEMENT_ARRANGEMENTS REIMBURSEMENT_ARRANGEMENTS
, QUA.TRAINING_COMPLETED_AMOUNT TRAINING_COMPLETED_AMOUNT
, QUA.TOTAL_TRAINING_AMOUNT TOTAL_TRAINING_AMOUNT
, QUA.TRAINING_COMPLETED_UNITS TRAINING_COMPLETED_UNITS
, QUA.PROFESSIONAL_BODY_NAME PROFESSIONAL_BODY_NAME
, QUA.MEMBERSHIP_NUMBER MEMBERSHIP_NUMBER
, QUA.MEMBERSHIP_CATEGORY MEMBERSHIP_CATEGORY
, QUA.SUBSCRIPTION_PAYMENT_METHOD SUBSCRIPTION_PAYMENT_METHOD
, '_DF:PER:PER_QUALIFICATIONS:QUA'
, QUT.CATEGORY QUALIFICATION_CATEGORY_CODE
, QUA.TUITION_METHOD TUITION_METHOD_CODE
, QUA.QUALIFICATION_ID QUALIFICATION_ID
, QUA.PARTY_ID PARTY_ID
, QUT.QUALIFICATION_TYPE_ID QUALIFICATION_TYPE_ID
FROM HZ_PERSON_PROFILES PAR
, IRC_NOTIFICATION_PREFERENCES INP
, PER_QUALIFICATIONS QUA
, PER_QUALIFICATION_TYPES QUT
WHERE PAR.PARTY_ID = QUA.PARTY_ID
AND INP.PARTY_ID = PAR.PARTY_ID
AND INP.ALLOW_ACCESS = 'Y'
AND QUA.QUALIFICATION_TYPE_ID = QUT.QUALIFICATION_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN NVL(PAR.EFFECTIVE_START_DATE
, TRUNC(SYSDATE))
AND NVL(PAR.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY