APPS.CE_AUTO_BANK_CLEAR1 dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 182: x_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;

178: | Status Status of the cash_receipt_history_record matched |
179: --------------------------------------------------------------------- */
180: FUNCTION check_matching_status(cr_id IN NUMBER,
181: orig_status IN VARCHAR2) RETURN BOOLEAN IS
182: x_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
183: BEGIN
184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.check_matching_status');
186: END IF;

Line 190: ar_cash_receipt_history_all crh,

186: END IF;
187: SELECT crh.status
188: INTO x_status
189: FROM ce_statement_recon_gt_v rec, --ce_statement_reconcils_all rec,
190: ar_cash_receipt_history_all crh,
191: ar_cash_receipts_all cr
192: WHERE rec.current_record_flag = 'Y' AND
193: rec.status_flag = 'M' AND
194: rec.reference_type = 'RECEIPT' AND

Line 530: receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;

526: X_original_amount NUMBER,
527: X_effective_date DATE,
528: X_float_handling_flag VARCHAR2) IS
529: receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;
530: receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
531: receipt_type AR_CASH_RECEIPTS_ALL.type%TYPE;
532: receipt_status CE_LOOKUPS.lookup_code%TYPE;
533: receipt_date DATE;
534: receipt_gl_date DATE;

Line 1226: cash_receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%

1222: trx_currency_type VARCHAR2,
1223: X_cr_id IN OUT NOCOPY NUMBER,
1224: X_effective_date DATE,
1225: X_org_id NUMBER ) IS
1226: cash_receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%
1227: TYPE;
1228: l_dbseqname VARCHAR2(30);
1229: l_doc_seq_id NUMBER;
1230: l_doc_seq_value NUMBER;

Line 1423: FROM ar_cash_receipt_history_all arh --ar_cash_receipt_history arh

1419: --
1420: BEGIN
1421: SELECT arh.status, arh.cash_receipt_history_id
1422: INTO l_status, cash_receipt_history_id
1423: FROM ar_cash_receipt_history_all arh --ar_cash_receipt_history arh
1424: WHERE arh.cash_receipt_id = X_cr_id AND
1425: arh.current_record_flag = 'Y';
1426: EXCEPTION
1427: WHEN NO_DATA_FOUND THEN

Line 2866: FROM ar_cash_receipt_history_all arh

2862: ELSIF (clearing_trx_type IN ('CASH','MISC')) THEN
2863:
2864: SELECT NVL(arh.current_record_flag, 'N')
2865: INTO p_current_record_flag
2866: FROM ar_cash_receipt_history_all arh
2867: WHERE arh.cash_receipt_history_id = trx_id;
2868:
2869: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2870: AND p_current_record_flag <> 'N'