DBA Data[Home] [Help]

APPS.XTR_UPDATE_SETTLEMENT_ACCOUNTS dependencies on XTR_CFLOW_REQUEST_DETAILS_S

Line 214: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL

210: WHERE account_number = p_new_bank_account
211: AND party_code = p_party_code;
212:
213: IF l_new_authorized <> 'Y' THEN
214: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL
215: INTO l_cf_req_details_id
216: FROM DUAL;
217: insert_request_details( l_cf_req_details_id,
218: l_request_id, p_party_code,

Line 236: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL

232: END IF;
233:
234: IF (l_message_name IS NULL) THEN
235: IF l_current_currency <> l_new_currency THEN
236: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL
237: INTO l_cf_req_details_id
238: FROM DUAL;
239: insert_request_details( l_cf_req_details_id,
240: l_request_id, p_party_code,

Line 258: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL

254: END IF;
255: END IF;
256:
257: IF l_message_name IS NULL THEN
258: SELECT XTR_CFLOW_REQUEST_DETAILS_S.NEXTVAL
259: INTO l_cf_req_details_id
260: FROM DUAL;
261: insert_request_details(l_cf_req_details_id, l_request_id,
262: p_party_code, p_current_bank_account,