APPS.WSH_ITM_OVERRIDE dependencies on WSH_ITM_SERVICE_PREFERENCES

Line 392: WSH_ITM_SERVICE_PREFERENCES wsp,

388: wrc.request_control_id,
389: wrc.request_set_id
390: FROM
391: WSH_ITM_REQUEST_CONTROL wrc,
392: WSH_ITM_SERVICE_PREFERENCES wsp,
393: WSH_ITM_VENDOR_SERVICES wvs
394: WHERE
395: nvl(wrc.original_system_reference,-99) = nvl(p_reference_id,
396: nvl(wrc.original_system_reference,-99))

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

519: WSH_UTIL_CORE.println('Start the loop for Get_Unprocessed_Records_2');
520: if p_application_id=660 then
521: l_sql_string := 'SELECT DISTINCT wrc.request_control_id, wrc.request_set_id ';
522: l_sql_string := l_sql_string || 'FROM WSH_ITM_REQUEST_CONTROL wrc, ';
523: l_sql_string := l_sql_string || ' WSH_ITM_SERVICE_PREFERENCES wsp, ';
524: l_sql_string := l_sql_string || ' WSH_ITM_VENDOR_SERVICES wvs ';
525:
526: IF ( p_party_type is NOT NULL or p_party_id is NOT NULL ) THEN
527: l_sql_string := l_sql_string || ' , WSH_ITM_PARTIES wp ';