APPS.ARP_ETAX_INVAPI_UTIL dependencies on RA_CUST_TRX_TYPES

Line 145: RA_CUST_TRX_TYPES TT,

141: DECODE(REL_T.customer_trx_id, NULL, NULL, REL_T.trx_date),
142: T.bill_to_customer_id, -- bill_third_pty_acct_id
143: BTPS.cust_acct_site_id -- bill_third_pty_acct_site_id
144: FROM RA_CUSTOMER_TRX T,
145: RA_CUST_TRX_TYPES TT,
146: RA_BATCH_SOURCES TB,
147: FND_CURRENCIES C,
148: FND_DOCUMENT_SEQUENCES SEQ,
149: AR_SYSTEM_PARAMETERS AR,

Line 155: RA_CUST_TRX_TYPES REL_TT

151: HZ_CUST_SITE_USES BTCSU,
152: HZ_CUST_ACCT_SITES BTPS,
153: HR_ORGANIZATION_UNITS HR,
154: RA_CUSTOMER_TRX REL_T,
155: RA_CUST_TRX_TYPES REL_TT
156: WHERE T.request_id = p_request_id
157: AND T.invoice_currency_code = C.currency_code
158: AND T.org_id = AR.org_id
159: AND T.cust_trx_type_id = TT.cust_trx_type_id

Line 611: ra_cust_trx_types types

607: /* Bug 9585582 */
608: CURSOR ctt IS
609: SELECT DISTINCT types.type
610: FROM ra_customer_trx trx ,
611: ra_cust_trx_types types
612: WHERE trx.cust_trx_type_id = types.cust_trx_type_id
613: AND trx.request_id=p_request_id;
614:
615: