APPS.XNB_UTIL_PVT dependencies on ECX_TP_DETAILS

Line 107: FROM ECX_TP_DETAILS_V

103: --
104: -----------------------------------------------------------------------------------------
105: cursor l_tp_codes is
106: SELECT SOURCE_TP_LOCATION_CODE
107: FROM ECX_TP_DETAILS_V
108: WHERE TRANSACTION_TYPE = 'XNB' AND TRANSACTION_SUBTYPE = 'CBODI';
109:
110: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;
111: l_num NUMBER;

Line 110: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;

106: SELECT SOURCE_TP_LOCATION_CODE
107: FROM ECX_TP_DETAILS_V
108: WHERE TRANSACTION_TYPE = 'XNB' AND TRANSACTION_SUBTYPE = 'CBODI';
109:
110: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;
111: l_num NUMBER;
112:
113: begin
114:

Line 182: FROM ECX_TP_DETAILS_V

178: AS
179:
180: CURSOR l_tp_codes IS
181: SELECT SOURCE_TP_LOCATION_CODE
182: FROM ECX_TP_DETAILS_V
183: WHERE TRANSACTION_TYPE = 'XNB' AND TRANSACTION_SUBTYPE = 'CBODI';
184:
185: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;
186: l_success_stat NUMBER; --Success status from each trading partner

Line 185: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;

181: SELECT SOURCE_TP_LOCATION_CODE
182: FROM ECX_TP_DETAILS_V
183: WHERE TRANSACTION_TYPE = 'XNB' AND TRANSACTION_SUBTYPE = 'CBODI';
184:
185: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;
186: l_success_stat NUMBER; --Success status from each trading partner
187: BEGIN
188:
189: ---------------------------------------------------------------