386: Select pqt.qualification_type_id LOOKUP_CODE
387: , substr(p_year1||':'||pqtl.NAME,1,80) MEANING
388: , pqtl.NAME DESCRIPTION
389: from
390: per_qualification_types pqt
391: , per_qualification_types_tl pqtl
392: Where pqt.qualification_type_id = pqtl.qualification_type_id
393: and pqtl.language = userenv('LANG')
394: and pqt.qualification_type_id in
387: , substr(p_year1||':'||pqtl.NAME,1,80) MEANING
388: , pqtl.NAME DESCRIPTION
389: from
390: per_qualification_types pqt
391: , per_qualification_types_tl pqtl
392: Where pqt.qualification_type_id = pqtl.qualification_type_id
393: and pqtl.language = userenv('LANG')
394: and pqt.qualification_type_id in
395: ( Select pq.qualification_type_id