APPS.ARP_PROCESS_APPLICATION dependencies on AR_TRANSACTION_HISTORY

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

6663: AND dist.account_class = 'REC'
6664: AND dist.latest_rec_flag = 'Y';
6665:
6666: /* Cursor to fetch BR transaction CCID, new functionality */
6667: CURSOR br_dist_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE, p_sign NUMBER) IS
6668: SELECT dist.code_combination_id, dist.source_type
6669: FROM ar_distributions dist
6670: WHERE dist.source_id = p_transaction_history_id
6671: AND dist.source_table = 'TH'

Line 6687: FROM ar_transaction_history trh

6683:
6684: /* Cursor to fetch current BR transaction history record */
6685: CURSOR br_current_trh_cur(p_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6686: SELECT trh.transaction_history_id, trh.postable_flag, trh.event
6687: FROM ar_transaction_history trh
6688: WHERE trh.customer_trx_id = p_customer_trx_id
6689: AND trh.current_accounted_flag = 'Y';
6690:
6691: /* Cursor to fetch previous BR transaction postable transaction history record */

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

6688: WHERE trh.customer_trx_id = p_customer_trx_id
6689: AND trh.current_accounted_flag = 'Y';
6690:
6691: /* Cursor to fetch previous BR transaction postable transaction history record */
6692: CURSOR br_prev_postable_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE) IS
6693: SELECT transaction_history_id
6694: FROM ar_transaction_history
6695: WHERE postable_flag = 'Y'
6696: AND event <> 'MATURITY_DATE'

Line 6694: FROM ar_transaction_history

6690:
6691: /* Cursor to fetch previous BR transaction postable transaction history record */
6692: CURSOR br_prev_postable_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE) IS
6693: SELECT transaction_history_id
6694: FROM ar_transaction_history
6695: WHERE postable_flag = 'Y'
6696: AND event <> 'MATURITY_DATE'
6697: CONNECT BY PRIOR prv_trx_history_id = transaction_history_id
6698: START WITH transaction_history_id = p_transaction_history_id

Line 6707: l_postable_trh_id ar_transaction_history.transaction_history_id%TYPE;

6703: trx_dist_rec trx_dist_cur%ROWTYPE;
6704: br_dist_rec br_dist_cur%ROWTYPE;
6705: br_current_trh_rec br_current_trh_cur%ROWTYPE;
6706: br_prev_postable_rec br_prev_postable_cur%ROWTYPE;
6707: l_postable_trh_id ar_transaction_history.transaction_history_id%TYPE;
6708:
6709: BEGIN
6710: IF PG_DEBUG in ('Y', 'C') THEN
6711: arp_debug.debug( 'arp_process_application.fetch_app_ccid()+' );

Line 6890: FROM ar_transaction_history trh

6886: WHERE ps.payment_schedule_id = p_applied_ps_id;
6887:
6888: CURSOR current_BR_cur IS
6889: SELECT trh.status, trh.event
6890: FROM ar_transaction_history trh
6891: WHERE trh.customer_trx_id = p_applied_customer_trx_id
6892: AND trh.current_record_flag = 'Y';
6893:
6894: trx_class_rec trx_class_cur%ROWTYPE;