232: AND b.source_object_code = p_object_type_code
233: AND b.jtf_note_id = t.jtf_note_id
234: AND t.language = USERENV('LANG')
235: AND ( EXISTS ( SELECT o.object_id
236: FROM jtf_object_mappings o
237: WHERE o.object_id = b.note_type
238: AND o.source_object_code = 'ASO_QUOTE' )
239:
240: OR NOT EXISTS ( SELECT om.object_id
237: WHERE o.object_id = b.note_type
238: AND o.source_object_code = 'ASO_QUOTE' )
239:
240: OR NOT EXISTS ( SELECT om.object_id
241: FROM JTF_OBJECT_MAPPINGS om
242: WHERE om.object_id = b.note_type )
243: );
244:
245: