DBA Data[Home] [Help]

APPS.POS_BUSINESS_CLASS_BO_PKG dependencies on FND_LOOKUP_VALUES

Line 26: FROM fnd_lookup_values

22: -- Validate the classifcation using the following query
23: BEGIN
24: SELECT lookup_code
25: INTO l_dummy_lookup
26: FROM fnd_lookup_values
27: WHERE lookup_type = p_vendor_buss_class_rec.lookup_type
28: AND lookup_code = p_vendor_buss_class_rec.lookup_code
29: AND enabled_flag = 'Y'
30: AND nvl(end_date_active, SYSDATE + 1) > SYSDATE

Line 46: FROM fnd_lookup_values_vl

42: IF (p_vendor_buss_class_rec.lookup_code = 'MINORITY_OWNED') THEN
43: BEGIN
44: SELECT lookup_code
45: INTO l_dummy_lookup
46: FROM fnd_lookup_values_vl
47: WHERE lookup_type = 'MINORITY GROUP'
48: AND lookup_code = p_vendor_buss_class_rec.ext_attr_1
49: AND enabled_flag = 'Y'
50: AND nvl(end_date_active, SYSDATE + 1) > SYSDATE;