APPS.OKL_UPDT_CASH_DTLS dependencies on OKL_EXT_CSH_RCPTS_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 123: FROM okl_ext_csh_rcpts_b a

119:
120: -- currency conversion rate
121: CURSOR c_get_conv_rate (cp_xcr_id IN NUMBER) IS
122: SELECT a.exchange_rate
123: FROM okl_ext_csh_rcpts_b a
124: WHERE a.id = cp_xcr_id;
125:
126: ----------
127:

Line 133: okl_ext_csh_rcpts_b b

129: CURSOR c_get_rcpt_info (cp_rct_id IN NUMBER) IS
130: SELECT a.currency_code, a.amount, -- rcpt currency
131: b.currency_code, b.remittance_amount -- functional currency
132: FROM okl_trx_csh_receipt_b a,
133: okl_ext_csh_rcpts_b b
134: WHERE a.id = cp_rct_id
135: AND a.id = b.rct_id;
136:
137: ----------

Line 183: DELETE FROM OKL_EXT_CSH_RCPTS_B

179: DELETE FROM OKL_TXL_RCPT_APPS_B
180: WHERE RCT_ID_DETAILS = l_rct_id_details;
181:
182: -- clear up external receipt
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