VIEW: APPS.IRCFV_CAND_SCHOOL_COLL_ATT

Source

View Text - Preformatted

SELECT par.person_name candidate_name ,qua.title qualification_title ,qua.grade_attained grade_attained ,qua.awarded_date awarded_date ,att.establishment school_or_college_name ,hr_bis.bis_decode_lookup('PER_CATEGORIES', qut.category) qualification_category ,qut.name qualification_type_name ,'_DF:PER:PER_QUALIFICATIONS:qua' ,'_DF:PER:PER_ESTABLISHMENT_ATTENDANCES:att' ,qut.category qualification_category_code ,qua.qualification_id qualification_id ,par.party_id party_id ,qut.qualification_type_id qualification_type_id ,att.attendance_id attendance_id FROM hz_person_profiles par ,irc_notification_preferences inp ,per_qualifications qua ,per_qualification_types qut ,per_establishment_attendances att WHERE inp.party_id = par.party_id AND inp.allow_access = 'Y' AND par.party_id = att.party_id AND qua.qualification_type_id = qut.qualification_type_id (+) AND qua.attendance_id (+) = att.attendance_id AND trunc(sysdate) between NVL(par.effective_start_date, hr_general.start_of_time) and NVL(par.effective_end_date , hr_general.end_of_time) 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
, ATT.ESTABLISHMENT SCHOOL_OR_COLLEGE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PER_CATEGORIES'
, QUT.CATEGORY) QUALIFICATION_CATEGORY
, QUT.NAME QUALIFICATION_TYPE_NAME
, '_DF:PER:PER_QUALIFICATIONS:QUA'
, '_DF:PER:PER_ESTABLISHMENT_ATTENDANCES:ATT'
, QUT.CATEGORY QUALIFICATION_CATEGORY_CODE
, QUA.QUALIFICATION_ID QUALIFICATION_ID
, PAR.PARTY_ID PARTY_ID
, QUT.QUALIFICATION_TYPE_ID QUALIFICATION_TYPE_ID
, ATT.ATTENDANCE_ID ATTENDANCE_ID
FROM HZ_PERSON_PROFILES PAR
, IRC_NOTIFICATION_PREFERENCES INP
, PER_QUALIFICATIONS QUA
, PER_QUALIFICATION_TYPES QUT
, PER_ESTABLISHMENT_ATTENDANCES ATT
WHERE INP.PARTY_ID = PAR.PARTY_ID
AND INP.ALLOW_ACCESS = 'Y'
AND PAR.PARTY_ID = ATT.PARTY_ID
AND QUA.QUALIFICATION_TYPE_ID = QUT.QUALIFICATION_TYPE_ID (+)
AND QUA.ATTENDANCE_ID (+) = ATT.ATTENDANCE_ID
AND TRUNC(SYSDATE) BETWEEN NVL(PAR.EFFECTIVE_START_DATE
, HR_GENERAL.START_OF_TIME)
AND NVL(PAR.EFFECTIVE_END_DATE
, HR_GENERAL.END_OF_TIME) WITH READ ONLY