APPS.OKL_UPDT_CASH_DTLS dependencies on OKL_XTL_CSH_APPS_B

Line 114: FROM okl_ext_csh_rcpts_b a, okl_xtl_csh_apps_b b

110: CURSOR c_get_external_hdr (cp_xcr_id_details IN NUMBER) IS
111: SELECT a.id, a.rct_id, a.remittance_amount, a.check_number, a.receipt_date,
112: a.gl_date, a.customer_number, a.currency_code, a.org_id, a.exchange_rate_type,
113: a.exchange_rate_date, a.attribute1
114: FROM okl_ext_csh_rcpts_b a, okl_xtl_csh_apps_b b
115: WHERE a.id = b.xcr_id_details
116: AND b.xcr_id_details = cp_xcr_id_details;
117:
118: ----------

Line 187: DELETE FROM OKL_XTL_CSH_APPS_B

183: DELETE FROM OKL_EXT_CSH_RCPTS_B
184: WHERE ID = l_xcr_id_details;
185:
186: -- clear up external receipt lines
187: DELETE FROM OKL_XTL_CSH_APPS_B
188: WHERE XCR_ID_DETAILS = l_xcr_id_details;
189:
190: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
191:

Line 484: FROM OKL_XTL_CSH_APPS_B

480: -------------------------------------------------------------------------------------------
481: -- clean up redundant records without amounts applied before calling AR
482:
483: DELETE
484: FROM OKL_XTL_CSH_APPS_B
485: WHERE AMOUNT_APPLIED = 0
486: AND XCR_ID_DETAILS = l_xcr_id_details;
487:
488: -------------------------------------------------------------------------------------------