DBA Data[Home] [Help]

APPS.ARP_EBS_AUTOINV_PREPROC dependencies on RA_CUST_TRX_TYPES

Line 39: FROM ra_cust_trx_types

35: AND trx_date > NVL(rec.end_date_active,
36: to_date('31-12-2001','DD-MM-YYYY'))
37: AND currency_code = rec.currency_code
38: AND cust_trx_type_id in ( SELECT cust_trx_type_id
39: FROM ra_cust_trx_types
40: WHERE type = 'CM' ) ;
41:
42: -- Updating dist rows
43: -- note use of sysdate - EMU currencies have fixed conversion

Line 103: FROM ra_cust_trx_types

99: AND trx_date > NVL(rec.end_date_active,
100: to_date('31-12-2001','DD-MM-YYYY'))
101: AND currency_code = rec.currency_code
102: AND cust_trx_type_id in ( SELECT cust_trx_type_id
103: FROM ra_cust_trx_types
104: WHERE type = 'CM' ) ;
105:
106: -- Update invoice and CM headers
107: