DBA Data[Home] [Help]

APPS.OE_EXPORT_COMPLIANCE_WF dependencies on WSH_ITM_REQUEST_CONTROL

Line 241: FROM wsh_itm_request_control wrc

237: IS
238: SELECT request_control_id, response_header_id, organization_id,
239: nvl(original_system_line_reference, 0) line_id,
240: nvl(original_system_reference, 0) header_id --bug 4503620
241: FROM wsh_itm_request_control wrc
242: WHERE request_control_id = nvl(cp_request_control_id, 0)
243: AND wrc.application_id = 660
244: UNION
245: SELECT request_control_id, response_header_id, organization_id,

Line 248: FROM wsh_itm_request_control wrc

244: UNION
245: SELECT request_control_id, response_header_id, organization_id,
246: nvl(original_system_line_reference, 0) line_id,
247: nvl(original_system_reference, 0) header_id --bug 4503620
248: FROM wsh_itm_request_control wrc
249: WHERE request_set_id = nvl(cp_request_set_id, 0)
250: AND wrc.application_id = 660;
251:
252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Screening_Results';