DBA Data[Home] [Help]

APPS.PER_ZA_WSP_LOOKUP dependencies on PER_QUALIFICATION_TYPES

Line 390: per_qualification_types pqt

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

Line 391: , per_qualification_types_tl pqtl

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