DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on AR_TRANSACTION_HISTORY

Line 447: FROM ar_transaction_history crh

443: customer_trx_id,
444: p_entity_code,
445: event_id,
446: 'AR'
447: FROM ar_transaction_history crh
448: WHERE customer_trx_id = p_source_int_id;
449:
450:
451: END IF;

Line 1043: ar_transaction_history_all th

1039: p_org_id IN NUMBER)
1040: IS
1041: SELECT th.customer_trx_id
1042: FROM ar_distributions_all ard,
1043: ar_transaction_history_all th
1044: WHERE ard.source_table = 'TH'
1045: AND ard.source_id = th.transaction_history_id
1046: AND th.gl_date BETWEEN p_start_date AND p_end_date
1047: AND th.posting_control_id = -3

Line 1068: p_entity => 'AR_TRANSACTION_HISTORY_ALL',

1064: (p_start_date => p_start_date,
1065: p_end_date => p_end_date,
1066: p_org_id => p_org_id,
1067: p_type => 'BILL',
1068: p_entity => 'AR_TRANSACTION_HISTORY_ALL',
1069: x_return_status => x_return_status);
1070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1071: RAISE fnd_api.g_exc_error;
1072: END IF;