APPS.AR_EXTRACT_DOCUMENT dependencies on RA_CUSTOMER_TRX

Line 30: ra_customer_trx trx

26:
27: CURSOR c_pending_trx IS
28: select trx.customer_trx_id
29: from ar_document_transfers xfr,
30: ra_customer_trx trx
31: where xfr.status = 'WAITING' and
32: xfr.source_id = trx.customer_trx_id and
33: trx.PRINTING_PENDING <> 'N' and
34: trx.PRINTING_COUNT is null and

Line 104: ra_customer_trx trx

100: FND_GLOBAL.USER_ID,
101: NULL,
102: NULL
103: from ar_document_transfers_v d,
104: ra_customer_trx trx
105: where (l_trx_class is null or d.trx_class = l_trx_class) and
106: (l_trx_type_id is null or d.trx_type_id = l_trx_type_id) and
107: (l_trx_number_low is null or l_trx_number_low <= d.trx_number) and
108: (l_trx_number_high is null or d.trx_number <= l_trx_number_high) and

Line 121: update ra_customer_trx

117: FOR trx in c_pending_trx LOOP
118: arp_etax_util.global_document_update(trx.customer_trx_id,null,'PRINT');
119: END LOOP;
120:
121: update ra_customer_trx
122: set PRINTING_PENDING = 'N',
123: PRINTING_COUNT = 1,
124: PRINTING_LAST_PRINTED = sysdate,
125: PRINTING_ORIGINAL_DATE = sysdate,