DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on FND_LOOKUP_VALUES

Line 5359: FROM fnd_lookup_values

5355: -- Validate the classifcation using the following query
5356: BEGIN
5357: SELECT lookup_code
5358: INTO l_dummy_lookup
5359: FROM fnd_lookup_values
5360: WHERE lookup_type = p_vendor_buss_class_rec.lookup_type
5361: AND lookup_code = p_vendor_buss_class_rec.lookup_code
5362: AND enabled_flag = 'Y'
5363: AND nvl(end_date_active, SYSDATE + 1) > SYSDATE

Line 5405: FROM fnd_lookup_values_vl

5401: IF (p_vendor_buss_class_rec.lookup_code = 'MINORITY_OWNED') THEN
5402: BEGIN
5403: SELECT lookup_code
5404: INTO l_dummy_lookup
5405: FROM fnd_lookup_values_vl
5406: WHERE lookup_type = 'MINORITY GROUP'
5407: AND lookup_code = p_vendor_buss_class_rec.ext_attr_1
5408: AND enabled_flag = 'Y'
5409: AND nvl(end_date_active, SYSDATE + 1) > SYSDATE;