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 736: 'AR_TRANSACTION_HISTORY HS, ' ||

732: Inconsitent Datatypes errors in 10g. */
733:
734: p_select_detail := 'SELECT PS.* ' ||
735: 'FROM AR_PAYMENT_SCHEDULES PS, ' ||
736: 'AR_TRANSACTION_HISTORY HS, ' ||
737: 'HZ_CUST_ACCOUNTS CUST, ' ||
738: 'HZ_PARTIES PARTY, ' ||
739: 'RA_CUST_TRX_TYPES TRX_TYPE, ' ||
740: 'RA_CUSTOMER_TRX TRX, ' ||

Line 1040: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;

1036:
1037: TOTAL_COUNT AR_BATCHES.control_count%TYPE;
1038: TOTAL_AMOUNT AR_BATCHES.control_amount%TYPE;
1039:
1040: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1041:
1042: BEGIN
1043:
1044: IF PG_DEBUG in ('Y', 'C') THEN

Line 1171: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;

1167: l_api_version CONSTANT number := 1.0;
1168:
1169: l_field varchar2(30) := NULL;
1170:
1171: l_new_status AR_TRANSACTION_HISTORY.status%TYPE;
1172:
1173: l_batch_rec AR_BATCHES%ROWTYPE;
1174: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
1175: