APPS.ARP_PROCESS_APPLICATION dependencies on AR_TRANSACTION_HISTORY

Line 6315: CURSOR br_dist_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE, p_sign NUMBER) IS

6311: AND dist.account_class = 'REC'
6312: AND dist.latest_rec_flag = 'Y';
6313:
6314: /* Cursor to fetch BR transaction CCID, new functionality */
6315: CURSOR br_dist_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE, p_sign NUMBER) IS
6316: SELECT dist.code_combination_id, dist.source_type
6317: FROM ar_distributions dist
6318: WHERE dist.source_id = p_transaction_history_id
6319: AND dist.source_table = 'TH'

Line 6335: FROM ar_transaction_history trh

6331:
6332: /* Cursor to fetch current BR transaction history record */
6333: CURSOR br_current_trh_cur(p_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6334: SELECT trh.transaction_history_id, trh.postable_flag, trh.event
6335: FROM ar_transaction_history trh
6336: WHERE trh.customer_trx_id = p_customer_trx_id
6337: AND trh.current_accounted_flag = 'Y';
6338:
6339: /* Cursor to fetch previous BR transaction postable transaction history record */

Line 6340: CURSOR br_prev_postable_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE) IS

6336: WHERE trh.customer_trx_id = p_customer_trx_id
6337: AND trh.current_accounted_flag = 'Y';
6338:
6339: /* Cursor to fetch previous BR transaction postable transaction history record */
6340: CURSOR br_prev_postable_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE) IS
6341: SELECT transaction_history_id
6342: FROM ar_transaction_history
6343: WHERE postable_flag = 'Y'
6344: AND event <> 'MATURITY_DATE'

Line 6342: FROM ar_transaction_history

6338:
6339: /* Cursor to fetch previous BR transaction postable transaction history record */
6340: CURSOR br_prev_postable_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE) IS
6341: SELECT transaction_history_id
6342: FROM ar_transaction_history
6343: WHERE postable_flag = 'Y'
6344: AND event <> 'MATURITY_DATE'
6345: CONNECT BY PRIOR prv_trx_history_id = transaction_history_id
6346: START WITH transaction_history_id = p_transaction_history_id

Line 6355: l_postable_trh_id ar_transaction_history.transaction_history_id%TYPE;

6351: trx_dist_rec trx_dist_cur%ROWTYPE;
6352: br_dist_rec br_dist_cur%ROWTYPE;
6353: br_current_trh_rec br_current_trh_cur%ROWTYPE;
6354: br_prev_postable_rec br_prev_postable_cur%ROWTYPE;
6355: l_postable_trh_id ar_transaction_history.transaction_history_id%TYPE;
6356:
6357: BEGIN
6358: IF PG_DEBUG in ('Y', 'C') THEN
6359: arp_standard.debug( 'arp_process_application.fetch_app_ccid()+' );

Line 6538: FROM ar_transaction_history trh

6534: WHERE ps.payment_schedule_id = p_applied_ps_id;
6535:
6536: CURSOR current_BR_cur IS
6537: SELECT trh.status, trh.event
6538: FROM ar_transaction_history trh
6539: WHERE trh.customer_trx_id = p_applied_customer_trx_id
6540: AND trh.current_record_flag = 'Y';
6541:
6542: trx_class_rec trx_class_cur%ROWTYPE;