APPS.CSM_LOOKUP_EVENT_PKG dependencies on JTF_OBJECT_MAPPINGS

Line 65: from jtf_object_mappings

61: OR
62: (val.view_application_id = 0 AND val.lookup_type = 'JTF_NOTE_STATUS')
63: OR (val.view_application_id = 0 AND val.lookup_type = 'JTF_NOTE_TYPE' AND
64: (val.lookup_code in (select object_id
65: from jtf_object_mappings
66: where object_code like 'JTF_NOTE_TYPE%' and
67: source_object_code in ('SR', 'TASK', 'PARTY', 'CP', 'SD', 'OKS_COV_NOTE')) OR
68: NOT EXISTS ( SELECT 1
69: FROM jtf_object_mappings

Line 69: FROM jtf_object_mappings

65: from jtf_object_mappings
66: where object_code like 'JTF_NOTE_TYPE%' and
67: source_object_code in ('SR', 'TASK', 'PARTY', 'CP', 'SD', 'OKS_COV_NOTE')) OR
68: NOT EXISTS ( SELECT 1
69: FROM jtf_object_mappings
70: WHERE object_id = val.lookup_code)))
71: OR (val.view_application_id = 170 AND val.lookup_type = 'REQUEST_PROBLEM_CODE')
72: OR (val.view_application_id = 0 AND val.lookup_type = 'CSF_MATERIAL_REASON')
73: OR (val.view_application_id = 0 AND val.lookup_type = 'CSF_EXPENSE_REASON')