APPS.WMS_ATF_DEST_LOCATOR dependencies on WMS_API_HOOKED_ENTITIES

Line 87: from wms_api_hook_calls wahc, wms_api_hooked_entities wahe

83:
84: -- Added the wahc.effective_to_date to the select on December 24th 2003.
85: cursor c_get_hook_call_details is
86: select wahe.current_package_cntr, wahc.effective_to_date
87: from wms_api_hook_calls wahc, wms_api_hooked_entities wahe
88: where wahe.module_hook_id = wahc.module_hook_id
89: -- Restricts the output to "Locator Selection/Validation" only
90: and wahe.short_name_id = 1
91: and wahc.hook_call_id = p_hook_call_id;