APPS.ARP_ACCT_EVENT_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 106: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN

102: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: END IF;
106: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN
107: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
108: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
109: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
110: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');

Line 407: FROM ar_cash_receipt_history crh

403: FROM
404: (SELECT gl_date gl_date,
405: cash_receipt_id cash_receipt_id,
406: event_id event_id
407: FROM ar_cash_receipt_history crh
408: WHERE cash_receipt_id = p_source_int_id
409: UNION ALL
410: SELECT ra.gl_date gl_date,
411: ra.cash_receipt_id cash_receipt_id,

Line 853: ar_cash_receipt_history_all crh,

849: p_type IN VARCHAR2)
850: IS
851: SELECT crh.cash_receipt_id
852: FROM ar_distributions_all ard,
853: ar_cash_receipt_history_all crh,
854: ar_cash_receipts_all cr
855: WHERE ard.source_table = 'CRH'
856: AND ard.source_id = crh.cash_receipt_history_id
857: AND crh.gl_date BETWEEN p_start_date AND p_end_date

Line 884: p_entity => 'AR_CASH_RECEIPT_HISTORY_ALL',

880: (p_start_date => p_start_date,
881: p_end_date => p_end_date,
882: p_org_id => p_org_id,
883: p_type => p_type,
884: p_entity => 'AR_CASH_RECEIPT_HISTORY_ALL',
885: x_return_status => x_return_status);
886: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
887: RAISE fnd_api.g_exc_error;
888: END IF;

Line 1488: FROM AR_CASH_RECEIPT_HISTORY

1484: ,third_party_sub_id = p_new_site_id
1485: WHERE
1486: ( SOURCE_TABLE, SOURCE_ID ) IN
1487: ( SELECT 'CRH', CASH_RECEIPT_HISTORY_ID
1488: FROM AR_CASH_RECEIPT_HISTORY
1489: WHERE CASH_RECEIPT_ID = p_source_id_int_1
1490: UNION ALL
1491: SELECT 'RA', RECEIVABLE_APPLICATION_ID
1492: FROM AR_RECEIVABLE_APPLICATIONS