SELECT per.person_type_id, lk.lookup_code, lk.meaning FROM pa_lookups lk, per_person_types per WHERE lk.lookup_type = 'PA_PERSON_TYPE' AND per.system_person_type = lk.lookup_code AND per.business_group_id = 0
View Text - HTML Formatted
SELECT PER.PERSON_TYPE_ID , LK.LOOKUP_CODE , LK.MEANING FROM PA_LOOKUPS LK , PER_PERSON_TYPES PER WHERE LK.LOOKUP_TYPE = 'PA_PERSON_TYPE' AND PER.SYSTEM_PERSON_TYPE = LK.LOOKUP_CODE AND PER.BUSINESS_GROUP_ID = 0