APPS.IEX_DISPUTE_PVT dependencies on RA_CM_REQUESTS

Line 377: from ra_cm_requests

373: from iex_disputes
374: where delinquency_id = l_delinquency_id ;
375:
376: select status into l_status
377: from ra_cm_requests
378: where request_id = l_request_id ;
379:
380: IF l_status = 'PENDING_APPROVAL' or l_status = 'APPROVED_PEND_COMP' then
381: x_return_status := 'T' ;

Line 539: FROM ra_cm_requests_all

535: BEGIN
536:
537: SELECT org_id
538: INTO l_org_id
539: FROM ra_cm_requests_all
540: WHERE request_id = p_dispute_id;
541:
542: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
543: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: l_org_id: ' || l_org_id);

Line 579: FROM ra_cm_requests

575: END IF;
576:
577: SELECT total_amount * -1
578: INTO remove_from_dispute_amt
579: FROM ra_cm_requests
580: WHERE request_id = p_dispute_id;
581:
582: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
583: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: remove_from_dispute_amt: ' || remove_from_dispute_amt);

Line 709: FROM ra_cm_requests

705:
706: if l_customer_trx_id is null then
707: SELECT customer_trx_id
708: INTO l_customer_trx_id
709: FROM ra_cm_requests
710: WHERE request_id = l_document_id;
711:
712: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
713: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: l_customer_trx_id: '||l_customer_trx_id);