DBA Data[Home] [Help]

APPS.HZ_CLASS_VALIDATE_V2PUB dependencies on FND_LOOKUP_VALUES_VL

Line 321: from fnd_lookup_values_vl

317: varchar2) return varchar2 is
318:
319: cursor get_invalid_delimiter_csr is
320: select 'x'
321: from fnd_lookup_values_vl
322: where lookup_type = p_class_category
323: and sysdate between start_date_active and nvl(end_date_active,sysdate)
324: and instrb(meaning,p_delimiter)>0;
325:

Line 747: FROM hz_code_assignments ca, fnd_lookup_values_vl lv

743: IS
744: SELECT DISTINCT actual_content_source,
745: owner_table_name,
746: owner_table_id
747: FROM hz_code_assignments ca, fnd_lookup_values_vl lv
748: WHERE ca.class_category = p_class_category
749: AND ca.class_category = lv.lookup_type
750: AND ca.class_code = lv.lookup_code;
751: