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 1205: cash_receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%

1201: trx_currency_type VARCHAR2,
1202: X_cr_id IN OUT NOCOPY NUMBER,
1203: X_effective_date DATE,
1204: X_org_id NUMBER ) IS
1205: cash_receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%
1206: TYPE;
1207: l_dbseqname VARCHAR2(30);
1208: l_doc_seq_id NUMBER;
1209: l_doc_seq_value NUMBER;

Line 1402: FROM ar_cash_receipt_history_all arh --ar_cash_receipt_history arh

1398: --
1399: BEGIN
1400: SELECT arh.status, arh.cash_receipt_history_id
1401: INTO l_status, cash_receipt_history_id
1402: FROM ar_cash_receipt_history_all arh --ar_cash_receipt_history arh
1403: WHERE arh.cash_receipt_id = X_cr_id AND
1404: arh.current_record_flag = 'Y';
1405: EXCEPTION
1406: WHEN NO_DATA_FOUND THEN

Line 2779: FROM ar_cash_receipt_history_all arh

2775: ELSIF (clearing_trx_type IN ('CASH','MISC')) THEN
2776:
2777: SELECT NVL(arh.current_record_flag, 'N')
2778: INTO p_current_record_flag
2779: FROM ar_cash_receipt_history_all arh
2780: WHERE arh.cash_receipt_history_id = trx_id;
2781:
2782: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2783: AND p_current_record_flag <> 'N'