APPS.AS_CLASSIFICATION_HOOKS dependencies on FND_LOOKUP_VALUES

Line 15: fnd_lookup_values lv

11: and selectable_flag = 'Y'
12: and exists (select 'x'
13: from hz_class_code_relations rel1,
14: hz_class_code_relations rel2,
15: fnd_lookup_values lv
16: where (rel1.sub_class_code = denorm.class_code
17: or lv.lookup_code = rel1.sub_class_code)
18: and rel2.class_code = denorm.class_code
19: and lv.lookup_type = denorm.class_category

Line 195: from fnd_lookup_values

191:
192: function get_code_meaning(p_type in varchar2, p_code in varchar2, p_language in varchar2) return varchar2 is
193: cursor get_code_meaning_csr is
194: select meaning
195: from fnd_lookup_values
196: where lookup_type = p_type
197: and language = p_language
198: and lookup_code = p_code;
199:

Line 492: fnd_lookup_values lv

488: fnd_global.prog_appl_id,
489: sysdate
490: from
491: as_hz_class_code_denorm denorm,
492: fnd_lookup_values lv
493: where
494: denorm.class_category = lv.lookup_type
495: and denorm.language = lv.language
496: and denorm.class_category = p_class_category

Line 604: fnd_lookup_values lv

600: fnd_global.prog_appl_id,
601: sysdate
602: from
603: as_hz_class_code_denorm denorm,
604: fnd_lookup_values lv
605: where
606: denorm.class_category = lv.lookup_type
607: and denorm.language = lv.language
608: and denorm.class_category = p_class_category

Line 716: fnd_lookup_values lv

712: fnd_global.prog_appl_id,
713: sysdate
714: from
715: as_hz_class_code_denorm denorm,
716: fnd_lookup_values lv
717: where
718: denorm.class_category = lv.lookup_type
719: and denorm.language = lv.language
720: and denorm.class_category = p_class_category

Line 784: from fnd_lookup_values

780: and sysdate between start_date_active and nvl(end_date_active,sysdate);
781:
782: cursor get_concat_meaning_csr is
783: select lookup_code,language,as_classification_hooks.get_concat_meaning(lookup_type,lookup_code,language)
784: from fnd_lookup_values
785: where lookup_type = p_class_category;
786:
787: cursor get_concat_code_csr is
788: select lookup_code,as_classification_hooks.get_concat_code(lookup_type,lookup_code)

Line 789: from fnd_lookup_values

785: where lookup_type = p_class_category;
786:
787: cursor get_concat_code_csr is
788: select lookup_code,as_classification_hooks.get_concat_code(lookup_type,lookup_code)
789: from fnd_lookup_values
790: where lookup_type = p_class_category;
791:
792: cursor code_relation_exist_csr is
793: select 'x'