APPS.WSH_ITM_PKG dependencies on WSH_ITM_RESPONSE_RULES

Line 52: --Bug 9277386:Added column Interpreted_Value_Code from WSH_ITM_RESPONSE_RULES

48: IS
49:
50:
51: --Declaration Cursor For Export Compliance Query
52: --Bug 9277386:Added column Interpreted_Value_Code from WSH_ITM_RESPONSE_RULES
53: CURSOR C_EXP_COMPL_QUERY(p_req_ctrl_id NUMBER, p_status VARCHAR2) is
54: SELECT RL.EXPORT_COMPLIANCE_TYPE COMPL_TYPE,
55: DECODE(RL.EXPORT_COMPLIANCE_SUCCESS, 'Y', 'COMPLIANT', 'N', 'NOT_COMPLIANT') COMPL_STATUS,
56: RL.EXPORT_COMPLIANCE_DESCRIPTION COMPL_DESC,

Line 64: WSH_ITM_RESPONSE_RULES WRR

60: WRR.INTERPRETED_VALUE_CODE INTERPRETED_VALUE
61: FROM WSH_ITM_RESPONSE_HEADERS RH,
62: WSH_ITM_RESPONSE_LINES RL,
63: WSH_ITM_REQUEST_CONTROL REQ,
64: WSH_ITM_RESPONSE_RULES WRR
65: WHERE
66: REQ.REQUEST_CONTROL_ID = p_req_ctrl_id AND
67: REQ.RESPONSE_HEADER_ID = RH.RESPONSE_HEADER_ID AND
68: RH.RESPONSE_HEADER_ID = RL.RESPONSE_HEADER_ID AND