APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_WSH_POES_VL

Line 385: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host

381: if p_application_id = -1 then
382:
383: SELECT app.object_version_number, app.wsh_po_id, app.application_id, app.cache_policy, app.cache_clear_flag, app.cache_reload_flag, app.cache_filter_policy, host.hostname, 'HTML-Platform', ''
384: INTO p_object_version_number, p_wsh_po_id, p_application_id, p_cache_policy, p_cache_clear_flag, p_cache_reload_flag, p_cache_filter_policy, p_hostname, p_appname, p_app_short_name
385: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host
386: WHERE app.host_app_id = p_host_app_id
387: AND app.wsh_po_id = host.wsh_po_id;
388:
389: else

Line 393: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host, fnd_application_vl fndapp

389: else
390:
391: SELECT app.object_version_number, app.wsh_po_id, app.application_id, app.cache_policy, app.cache_clear_flag, app.cache_reload_flag, app.cache_filter_policy, host.hostname, fndapp.application_name, fndapp.application_short_name
392: INTO p_object_version_number, p_wsh_po_id, p_application_id, p_cache_policy, p_cache_clear_flag, p_cache_reload_flag, p_cache_filter_policy, p_hostname, p_appname, p_app_short_name
393: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host, fnd_application_vl fndapp
394: WHERE app.host_app_id = p_host_app_id
395: AND app.wsh_po_id = host.wsh_po_id
396: AND app.application_id = fndapp.application_id;
397: