APPS.WSH_ITM_OVERRIDE dependencies on WSH_ITM_SERVICE_PREFERENCES

Line 409: WSH_ITM_SERVICE_PREFERENCES wsp,

405: wrc.request_control_id,
406: wrc.request_set_id
407: FROM
408: WSH_ITM_REQUEST_CONTROL wrc,
409: WSH_ITM_SERVICE_PREFERENCES wsp,
410: WSH_ITM_VENDOR_SERVICES wvs
411: WHERE
412: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
413: nvl(wrc.original_system_reference,-99))

Line 540: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';

536: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');
537: if p_application_id=660 then
538: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
539: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
540: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';
541: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';
542:
543: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
544: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';