DBA Data[Home] [Help]

APPS.AR_BILLS_MAINTAIN_VAL_PVT dependencies on AR_TRANSACTION_HISTORY_ALL

Line 1144: FROM ar_transaction_history_all

1140: END IF;
1141: -- Bug9578330
1142: SELECT trx_date, gl_date
1143: INTO l_trx_date, l_gl_date
1144: FROM ar_transaction_history_all
1145: WHERE transaction_history_id = (SELECT MAX(transaction_history_id)
1146: FROM ar_transaction_history_all
1147: WHERE customer_trx_id = p_trh_rec.customer_trx_id
1148: AND event NOT IN (C_DESELECTED_REMITTANCE, C_SELECTED_REMITTANCE));

Line 1146: FROM ar_transaction_history_all

1142: SELECT trx_date, gl_date
1143: INTO l_trx_date, l_gl_date
1144: FROM ar_transaction_history_all
1145: WHERE transaction_history_id = (SELECT MAX(transaction_history_id)
1146: FROM ar_transaction_history_all
1147: WHERE customer_trx_id = p_trh_rec.customer_trx_id
1148: AND event NOT IN (C_DESELECTED_REMITTANCE, C_SELECTED_REMITTANCE));
1149:
1150: