APPS.IGS_EN_VAL_IV dependencies on FND_LOOKUP_VALUES

Line 9: --asbala 15-APR-04 3349171 - Wrong usage of fnd_lookup_values

5: --Who When What
6: --smadathi 28-AUG-2001 Bug No. 1956374 .The Function genp_val_staff_prsn removed
7: -------------------------------------------------------------------------------------------
8: --msrinivi 24-AUG-2001 Bug No. 1956374 .The function genp_val_prsn_id removed
9: --asbala 15-APR-04 3349171 - Wrong usage of fnd_lookup_values
10: --
11: --
12: -- bug id : 1956374
13: -- sjadhav , 28-aug-2001

Line 88: FROM fnd_lookup_values

84:
85: v_closed_ind VARCHAR2(1);
86: CURSOR c_visa_type IS
87: SELECT enabled_flag
88: FROM fnd_lookup_values
89: WHERE lookup_type = 'PER_US_VISA_TYPES'
90: AND view_application_id = 3
91: AND security_group_id = 0
92: AND language = USERENV('LANG')