SELECT description, visa_type FROM IGS_AD_VISA_TYPE WHERE FND_PROFILE.VALUE('IGS_EN_VISA_TYPE')='O' UNION SELECT meaning description , lookup_code visa_type FROM FND_COMMON_LOOKUPS WHERE lookup_type='PER_US_VISA_TYPES' AND FND_PROFILE.VALUE('IGS_EN_VISA_TYPE')='H'
SELECT DESCRIPTION
, VISA_TYPE
FROM IGS_AD_VISA_TYPE
WHERE FND_PROFILE.VALUE('IGS_EN_VISA_TYPE')='O' UNION SELECT MEANING DESCRIPTION
, LOOKUP_CODE VISA_TYPE
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE='PER_US_VISA_TYPES'
AND FND_PROFILE.VALUE('IGS_EN_VISA_TYPE')='H'
|
|
|