APPS.IGF_AP_OSS_INTEGR dependencies on FND_LOOKUP_VALUES

Line 137: p_visa_desc OUT NOCOPY fnd_lookup_values.meaning%TYPE,

133:
134:
135: PROCEDURE get_pe_visa_type(p_person_id IN hz_parties.party_id%TYPE,
136: p_visa_type OUT NOCOPY igs_pe_visa.visa_type%TYPE,
137: p_visa_desc OUT NOCOPY fnd_lookup_values.meaning%TYPE,
138: p_multiple OUT NOCOPY VARCHAR2)
139: IS
140:
141: /*************************************************************

Line 155: FROM igs_pe_visa a , fnd_lookup_values b

151:
152: CURSOR c_get_visa_type IS
153: SELECT a.visa_type,
154: b.meaning visa_description
155: FROM igs_pe_visa a , fnd_lookup_values b
156: WHERE a.person_id = p_person_id
157: AND b.view_application_id = 3
158: AND b.lookup_type = 'PER_US_VISA_TYPES'
159: AND a.visa_type = b.lookup_code;