DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on AR_VAT_TAX_ALL_B

Line 1304: ar_vat_tax_all_b ar_codes,

1300: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1301: FROM
1302: zx_update_criteria_results results,
1303: ap_tax_codes_all codes,
1304: ar_vat_tax_all_b ar_codes,
1305: ap_tax_recvry_rules_all rec_rules,
1306: financials_system_params_all fsp,
1307: zx_party_tax_profile ptp
1308: WHERE

Line 1402: ar_vat_tax_all_b ar_codes,

1398: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1399: FROM
1400: zx_update_criteria_results results,
1401: ap_tax_codes_all codes,
1402: ar_vat_tax_all_b ar_codes,
1403: zx_update_criteria_results offset,
1404: financials_system_params_all fsp,
1405: ap_tax_recvry_rules_all rec_rules,
1406: zx_party_tax_profile ptp

Line 1721: ar_vat_tax_all_b ar_codes,

1717: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1718: FROM
1719: zx_update_criteria_results results,
1720: ap_tax_codes_all codes,
1721: ar_vat_tax_all_b ar_codes,
1722: ap_tax_recvry_rules_all rec_rules,
1723: financials_system_params_all fsp,
1724: zx_party_tax_profile ptp
1725: WHERE

Line 1820: ar_vat_tax_all_b ar_codes,

1816: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1817: FROM
1818: zx_update_criteria_results results,
1819: ap_tax_codes_all codes,
1820: ar_vat_tax_all_b ar_codes,
1821: zx_update_criteria_results offset,
1822: financials_system_params_all fsp,
1823: ap_tax_recvry_rules_all rec_rules,
1824: zx_party_tax_profile ptp

Line 2738: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

2734: userenv('LANG'),
2735: avtb.description
2736: FROM FND_LANGUAGES L,
2737: ZX_RATES_B RATES,
2738: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
2739: WHERE
2740: L.INSTALLED_FLAG in ('I', 'B')
2741: AND avtb.tax_id = RATES.tax_rate_id
2742: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 3100: ar_vat_tax_all_b ar_codes,

3096:
3097: FROM
3098: zx_update_criteria_results results,
3099: ap_tax_codes_all codes,
3100: ar_vat_tax_all_b ar_codes,
3101: ap_tax_codes_all offset,
3102: financials_system_params_all fsp,
3103: zx_party_tax_profile ptp
3104: WHERE

Line 3413: ar_vat_tax_all_b ar_codes,

3409:
3410: FROM
3411: zx_update_criteria_results results,
3412: ap_tax_codes_all codes,
3413: ar_vat_tax_all_b ar_codes,
3414: ap_tax_codes_all offset,
3415: financials_system_params_all fsp,
3416: zx_party_tax_profile ptp
3417: WHERE

Line 4100: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

4096: userenv('LANG'),
4097: avtb.description
4098: FROM FND_LANGUAGES L,
4099: ZX_RATES_B RATES,
4100: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
4101: WHERE
4102: L.INSTALLED_FLAG in ('I', 'B')
4103: AND avtb.tax_id = RATES.tax_rate_id
4104: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 4455: ar_vat_tax_all_b ar_codes,

4451: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
4452: FROM
4453: zx_update_criteria_results results,
4454: ap_tax_codes_all offset,
4455: ar_vat_tax_all_b ar_codes,
4456: financials_system_params_all fsp,
4457: zx_party_tax_profile ptp
4458: WHERE
4459: results.tax_code_id = offset.tax_id

Line 4766: ar_vat_tax_all_b ar_codes,

4762: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
4763: FROM
4764: zx_update_criteria_results results,
4765: ap_tax_codes_all offset,
4766: ar_vat_tax_all_b ar_codes,
4767: financials_system_params_all fsp,
4768: zx_party_tax_profile ptp
4769: WHERE
4770: results.tax_code_id = offset.tax_id

Line 5449: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

5445: userenv('LANG'),
5446: avtb.description
5447: FROM FND_LANGUAGES L,
5448: ZX_RATES_B RATES,
5449: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
5450: WHERE
5451: L.INSTALLED_FLAG in ('I', 'B')
5452: AND avtb.tax_id = RATES.tax_rate_id
5453: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 5753: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

5749: userenv('LANG'),
5750: avtb.description
5751: FROM FND_LANGUAGES L,
5752: ZX_RATES_B RATES,
5753: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
5754: WHERE
5755: L.INSTALLED_FLAG in ('I', 'B')
5756: AND avtb.tax_id = RATES.tax_rate_id
5757: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 11076: ar_vat_tax_all_b ar_codes,

11072: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11073: FROM
11074: zx_update_criteria_results results,
11075: ap_tax_codes_all codes,
11076: ar_vat_tax_all_b ar_codes,
11077: ap_tax_recvry_rules_all rec_rules,
11078: financials_system_params_all fsp,
11079: zx_party_tax_profile ptp
11080: WHERE

Line 11175: ar_vat_tax_all_b ar_codes,

11171:
11172: FROM
11173: zx_update_criteria_results results,
11174: ap_tax_codes_all codes,
11175: ar_vat_tax_all_b ar_codes,
11176: zx_update_criteria_results offset,
11177: financials_system_params_all fsp,
11178: ap_tax_recvry_rules_all rec_rules,
11179: zx_party_tax_profile ptp

Line 11498: ar_vat_tax_all_b ar_codes,

11494: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11495: FROM
11496: zx_update_criteria_results results,
11497: ap_tax_codes_all codes,
11498: ar_vat_tax_all_b ar_codes,
11499: ap_tax_recvry_rules_all rec_rules,
11500: financials_system_params_all fsp,
11501: zx_party_tax_profile ptp
11502: WHERE

Line 11598: ar_vat_tax_all_b ar_codes,

11594:
11595: FROM
11596: zx_update_criteria_results results,
11597: ap_tax_codes_all codes,
11598: ar_vat_tax_all_b ar_codes,
11599: zx_update_criteria_results offset,
11600: financials_system_params_all fsp,
11601: ap_tax_recvry_rules_all rec_rules,
11602: zx_party_tax_profile ptp

Line 12799: ar_vat_tax_all_b ar_codes,

12795: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12796: FROM
12797: zx_update_criteria_results results,
12798: ap_tax_codes_all codes,
12799: ar_vat_tax_all_b ar_codes,
12800: ap_tax_recvry_rules_all rec_rules,
12801: financials_system_params_all fsp,
12802: zx_party_tax_profile ptp
12803: WHERE

Line 12897: ar_vat_tax_all_b ar_codes,

12893: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12894: FROM
12895: zx_update_criteria_results results,
12896: ap_tax_codes_all codes,
12897: ar_vat_tax_all_b ar_codes,
12898: zx_update_criteria_results offset,
12899: financials_system_params_all fsp,
12900: ap_tax_recvry_rules_all rec_rules,
12901: zx_party_tax_profile ptp

Line 13222: ar_vat_tax_all_b ar_codes,

13218: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13219: FROM
13220: zx_update_criteria_results results,
13221: ap_tax_codes_all codes,
13222: ar_vat_tax_all_b ar_codes,
13223: ap_tax_recvry_rules_all rec_rules,
13224: financials_system_params_all fsp,
13225: zx_party_tax_profile ptp
13226: WHERE

Line 13321: ar_vat_tax_all_b ar_codes,

13317: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
13318: FROM
13319: zx_update_criteria_results results,
13320: ap_tax_codes_all codes,
13321: ar_vat_tax_all_b ar_codes,
13322: zx_update_criteria_results offset,
13323: financials_system_params_all fsp,
13324: ap_tax_recvry_rules_all rec_rules,
13325: zx_party_tax_profile ptp

Line 14246: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534

14242: userenv('LANG'),
14243: avtb.description
14244: FROM FND_LANGUAGES L,
14245: ZX_RATES_B RATES,
14246: ap_tax_codes_all avtb --snoothi changed table name from 'ar_vat_tax_all_b' to 'ap_tax_codes_all' bug#10221534
14247: WHERE
14248: L.INSTALLED_FLAG in ('I', 'B')
14249: AND avtb.tax_id = RATES.tax_rate_id
14250: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 14371: ar_vat_tax_all_b

14367:
14368: SELECT 'Y' INTO ID_CLASH FROM DUAL
14369: WHERE EXISTS (select 1
14370: from ap_tax_codes_all,
14371: ar_vat_tax_all_b
14372: where tax_id = vat_tax_id);
14373: EXCEPTION
14374: WHEN no_data_found THEN
14375: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);