DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on FND_LOOKUP_VALUES_VL

Line 6807: -- 4. Use fnd_lookup_values_vl for translation issues

6803: -- Bug 3822690 : Modify the cursor for better performance
6804: -- 1. Remove upper for lookup type
6805: -- 2. Remove upper for lookup code
6806: -- 3. Add view_application_id = 222
6807: -- 4. Use fnd_lookup_values_vl for translation issues
6808: CURSOR c_check_lookups
6809: IS
6810: SELECT 'Y'
6811: FROM fnd_lookup_values_vl

Line 6811: FROM fnd_lookup_values_vl

6807: -- 4. Use fnd_lookup_values_vl for translation issues
6808: CURSOR c_check_lookups
6809: IS
6810: SELECT 'Y'
6811: FROM fnd_lookup_values_vl
6812: -- WHERE upper(lookup_type) = upper(p_lookup_type)
6813: -- AND upper(lookup_code) = upper(p_lookup_code)
6814: WHERE lookup_type = p_lookup_type
6815: AND lookup_code = p_lookup_code