APPS.ZX_JL_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 3259: ra_customer_trx_all ratrx,

3255: FROM zx_rep_trx_detail_t itf,
3256: zx_rates_b rates,
3257:
3258:
3259: ra_customer_trx_all ratrx,
3260: ra_cust_trx_types_all types
3261: WHERE itf.request_id = P_REQUEST_ID
3262: AND itf.trx_id = ratrx.customer_trx_id
3263: AND itf.tax_rate_id = rates.tax_rate_id

Line 3770: FROM ra_customer_trx_all

3766: BEGIN
3767:
3768: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3769: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3770: FROM ra_customer_trx_all
3771: WHERE customer_trx_id = p_trx_id_tbl(i);
3772:
3773: EXCEPTION
3774: WHEN OTHERS THEN

Line 3995: FROM ra_customer_trx_all

3991: END IF;
3992:
3993: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
3994: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
3995: FROM ra_customer_trx_all
3996: WHERE customer_trx_id = p_trx_id_tbl(i);
3997:
3998: IF (g_level_procedure >= g_current_runtime_level ) THEN
3999: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_vat_amount',

Line 4524: FROM ra_customer_trx_all

4520:
4521: BEGIN
4522: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4523: INTO l_gdf_ra_cust_trx_att19_tbl(k)
4524: FROM ra_customer_trx_all
4525: WHERE customer_trx_id = p_trx_id_tbl(i);
4526:
4527: IF (g_level_statement >= g_current_runtime_level ) THEN
4528: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG.get_taxable_amount',

Line 4689: FROM ra_customer_trx_all

4685:
4686: BEGIN
4687: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
4688: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
4689: FROM ra_customer_trx_all
4690: WHERE customer_trx_id = p_trx_id_tbl(i);
4691:
4692: EXCEPTION
4693: WHEN OTHERS THEN

Line 5557: FROM ra_customer_trx_all

5553: BEGIN
5554:
5555: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
5556: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
5557: FROM ra_customer_trx_all
5558: WHERE customer_trx_id = p_trx_id_tbl(i);
5559:
5560: EXCEPTION
5561:

Line 6352: FROM ra_customer_trx_all

6348: l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i)) <> 'NOT_NULL' ) THEN
6349: BEGIN
6350: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6351: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6352: FROM ra_customer_trx_all
6353: WHERE customer_trx_id = p_trx_id_tbl(i);
6354:
6355: EXCEPTION
6356:

Line 6517: FROM ra_customer_trx_all

6513: END IF;
6514:
6515: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
6516: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
6517: FROM ra_customer_trx_all
6518: WHERE customer_trx_id = p_trx_id_tbl(i);
6519:
6520: EXCEPTION
6521: WHEN OTHERS THEN

Line 8045: FROM ra_customer_trx_all trx,

8041: NVL(add1.global_attribute9,'N')
8042: INTO l_address_id,
8043: l_contributor_class,
8044: l_use_site_prof
8045: FROM ra_customer_trx_all trx,
8046: hz_cust_accounts cust,
8047: hz_cust_acct_sites_all add1,
8048: hz_cust_site_uses_all site
8049: WHERE trx.customer_trx_id = p_trx_id_tbl(i)

Line 8365: FROM ra_customer_trx_all trx,

8361: NVL(add1.global_attribute9,'N')
8362: INTO l_address_id,
8363: l_class_code,
8364: l_use_site_prof
8365: FROM ra_customer_trx_all trx,
8366: hz_cust_accounts cust,
8367: hz_cust_acct_sites_all add1,
8368: hz_cust_site_uses_all site
8369: WHERE trx.customer_trx_id = p_trx_id_tbl(i)

Line 8873: FROM ra_customer_trx_all

8869: BEGIN
8870:
8871: SELECT decode(global_attribute19,NULL,'IS_NULL','NOT_NULL')
8872: INTO l_gdf_ra_cust_trx_att19_tbl(p_trx_id_tbl(i))
8873: FROM ra_customer_trx_all
8874: WHERE customer_trx_id = p_trx_id_tbl(i);
8875:
8876: IF ( g_level_statement>= g_current_runtime_level ) THEN
8877: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JL_EXTRACT_PKG',