DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 334: l_table_name :='RA_CUSTOMER_TRX_ALL';

330:
331: BEGIN
332:
333: IF p_application_id = 222 then
334: l_table_name :='RA_CUSTOMER_TRX_ALL';
335: ELSIF p_application_id = 200 then
336: l_table_name :='AP_INVOICES_ALL';
337: ELSIF p_application_id = 201 then
338: l_table_name :='PO_HEADERS_ALL';

Line 2132: FROM RA_CUSTOMER_TRX_ALL custtrx,

2128: DECODE(vat.tax_type,
2129: 'LOCATION', NULL,
2130: custtrxl.vat_tax_id) ACCOUNT_SOURCE_TAX_RATE_ID
2131:
2132: FROM RA_CUSTOMER_TRX_ALL custtrx,
2133: XLA_UPGRADE_DATES upd,
2134: AR_SYSTEM_PARAMETERS_ALL arsysparam,
2135: RA_CUST_TRX_TYPES_ALL types,
2136: FND_CURRENCIES fndcurr,

Line 2140: RA_CUSTOMER_TRX_ALL custtrx_prev,

2136: FND_CURRENCIES fndcurr,
2137: FND_DOCUMENT_SEQUENCES fds,
2138: ZX_PARTY_TAX_PROFILE ptp,
2139: RA_BATCH_SOURCES_ALL rbs,
2140: RA_CUSTOMER_TRX_ALL custtrx_prev,
2141: RA_CUSTOMER_TRX_LINES_ALL custtrxl,
2142: AR_VAT_TAX_ALL_B vat,
2143: ZX_RATES_B rates ,
2144: RA_CUSTOMER_TRX_LINES_ALL custtrxll, -- retrieve the trx line for tax lines