APPS.ARP_PROCESS_BR_REMIT dependencies on AR_TRANSACTION_HISTORY

Line 592: l_pending_remittance AR_TRANSACTION_HISTORY.status%TYPE := 'PENDING_REMITTANCE';

588:
589: l_ps_status_opened AR_BATCHES.status%TYPE := 'OP';
590: l_ps_class AR_PAYMENT_SCHEDULES.CLASS%TYPE := 'BR';
591:
592: l_pending_remittance AR_TRANSACTION_HISTORY.status%TYPE := 'PENDING_REMITTANCE';
593: l_unpaid AR_TRANSACTION_HISTORY.status%TYPE := 'UNPAID';
594:
595: BEGIN
596:

Line 593: l_unpaid AR_TRANSACTION_HISTORY.status%TYPE := 'UNPAID';

589: l_ps_status_opened AR_BATCHES.status%TYPE := 'OP';
590: l_ps_class AR_PAYMENT_SCHEDULES.CLASS%TYPE := 'BR';
591:
592: l_pending_remittance AR_TRANSACTION_HISTORY.status%TYPE := 'PENDING_REMITTANCE';
593: l_unpaid AR_TRANSACTION_HISTORY.status%TYPE := 'UNPAID';
594:
595: BEGIN
596:
597: IF PG_DEBUG in ('Y', 'C') THEN

Line 620: '(SELECT MAX(transaction_history_id) FROM AR_TRANSACTION_HISTORY WHERE customer_trx_id = PS.customer_trx_id ' ||

616: l_where_clause := l_where_clause || 'AND PS.reserved_type IS NULL ';
617: l_where_clause := l_where_clause || 'AND PS.reserved_value IS NULL ';
618: -- Bug9578330
619: l_where_clause := l_where_clause || 'AND HS1.transaction_history_id = ' ||
620: '(SELECT MAX(transaction_history_id) FROM AR_TRANSACTION_HISTORY WHERE customer_trx_id = PS.customer_trx_id ' ||
621: ' AND event NOT IN (''SELECTED_REMITTANCE'', ''DESELECTED_REMITTANCE''))';
622: -- bug6050275
623: /*
624: l_where_clause := l_where_clause || 'AND :batch_date >= HS.trx_date ';

Line 746: 'AR_TRANSACTION_HISTORY HS, ' ||

742: Inconsitent Datatypes errors in 10g. */
743:
744: p_select_detail := 'SELECT PS.* ' ||
745: 'FROM AR_PAYMENT_SCHEDULES PS, ' ||
746: 'AR_TRANSACTION_HISTORY HS, ' ||
747: 'HZ_CUST_ACCOUNTS CUST, ' ||
748: 'HZ_PARTIES PARTY, ' ||
749: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
750: 'RA_CUSTOMER_TRX TRX, ' ||

Line 753: 'AR_TRANSACTION_HISTORY HS1 ' ||

749: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
750: 'RA_CUSTOMER_TRX TRX, ' ||
751: 'AP_BANK_ACCOUNTS ACC, ' ||
752: 'CE_BANK_BRANCHES_V BRANCH, ' ||
753: 'AR_TRANSACTION_HISTORY HS1 ' ||
754: l_where_clause ||
755: l_order_clause;
756:
757: IF PG_DEBUG in ('Y', 'C') THEN

Line 1051: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;

1047:
1048: TOTAL_COUNT AR_BATCHES.control_count%TYPE;
1049: TOTAL_AMOUNT AR_BATCHES.control_amount%TYPE;
1050:
1051: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1052:
1053: BEGIN
1054:
1055: IF PG_DEBUG in ('Y', 'C') THEN

Line 1182: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;

1178: l_api_version CONSTANT number := 1.0;
1179:
1180: l_field varchar2(30) := NULL;
1181:
1182: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1183:
1184: l_batch_rec AR_BATCHES%ROWTYPE;
1185: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1186: