APPS.ZX_JA_EXTRACT_PKG dependencies on RA_BATCH_SOURCES_ALL

Line 163: FROM ra_batch_sources_all

159: /* Taiwanese Output VAT Report */
160: if P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID is NOT NULL then
161: SELECT batch_source_type, TO_NUMBER(global_attribute1)
162: INTO l_loc_trx_src_type, l_referenced_trx_src_id
163: FROM ra_batch_sources_all
164: WHERE batch_source_Id = P_TRL_GLOBAL_VARIABLES_REC.BATCH_SOURCE_ID;
165:
166:
167: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 259: SELECT 1 FROM ra_batch_sources_all rbs,

255: 'DELETE from ZX_REP_TRX_DETAIL_T DET
256: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
257: NOT EXISTS
258: (
259: SELECT 1 FROM ra_batch_sources_all rbs,
260: ra_customer_trx_all rct
261: WHERE
262: rbs.batch_source_id = DET.TRX_BATCH_SOURCE_ID and
263: rct.batch_source_id = rbs.batch_source_id and

Line 2432: ra_batcH_sources_all rbs

2428: SELECT rct_org.trx_number
2429: INTO X_ORG_TRX_NUMBER
2430: FROM ra_customer_trx_all rct,
2431: ra_customer_trx_all rct_org,
2432: ra_batcH_sources_all rbs
2433: WHERE rct_org.customer_Trx_id = rct.previous_customer_trx_id and
2434: rct.batch_source_id = rbs.batch_source_id and
2435: rbs.batch_source_id = P_TRX_SOURCE_ID and
2436: rct.customer_trx_id = p_trx_id;