DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on AR_VAT_TAX_ALL_B

Line 1288: ar_vat_tax_all_b ar_codes,

1284: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1285: FROM
1286: zx_update_criteria_results results,
1287: ap_tax_codes_all codes,
1288: ar_vat_tax_all_b ar_codes,
1289: ap_tax_recvry_rules_all rec_rules,
1290: financials_system_params_all fsp,
1291: zx_party_tax_profile ptp
1292: WHERE

Line 1387: ar_vat_tax_all_b ar_codes,

1383: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1384: FROM
1385: zx_update_criteria_results results,
1386: ap_tax_codes_all codes,
1387: ar_vat_tax_all_b ar_codes,
1388: zx_update_criteria_results offset,
1389: financials_system_params_all fsp,
1390: ap_tax_recvry_rules_all rec_rules,
1391: zx_party_tax_profile ptp

Line 1709: ar_vat_tax_all_b ar_codes,

1705: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1706: FROM
1707: zx_update_criteria_results results,
1708: ap_tax_codes_all codes,
1709: ar_vat_tax_all_b ar_codes,
1710: ap_tax_recvry_rules_all rec_rules,
1711: financials_system_params_all fsp,
1712: zx_party_tax_profile ptp
1713: WHERE

Line 1809: ar_vat_tax_all_b ar_codes,

1805: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
1806: FROM
1807: zx_update_criteria_results results,
1808: ap_tax_codes_all codes,
1809: ar_vat_tax_all_b ar_codes,
1810: zx_update_criteria_results offset,
1811: financials_system_params_all fsp,
1812: ap_tax_recvry_rules_all rec_rules,
1813: zx_party_tax_profile ptp

Line 2724: ar_vat_tax_all_b avtb

2720: userenv('LANG'),
2721: avtb.description
2722: FROM FND_LANGUAGES L,
2723: ZX_RATES_B RATES,
2724: ar_vat_tax_all_b avtb
2725: WHERE
2726: L.INSTALLED_FLAG in ('I', 'B')
2727: AND avtb.vat_tax_id = RATES.tax_rate_id
2728: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 3084: ar_vat_tax_all_b ar_codes,

3080:
3081: FROM
3082: zx_update_criteria_results results,
3083: ap_tax_codes_all codes,
3084: ar_vat_tax_all_b ar_codes,
3085: ap_tax_codes_all offset,
3086: financials_system_params_all fsp,
3087: zx_party_tax_profile ptp
3088: WHERE

Line 3395: ar_vat_tax_all_b ar_codes,

3391:
3392: FROM
3393: zx_update_criteria_results results,
3394: ap_tax_codes_all codes,
3395: ar_vat_tax_all_b ar_codes,
3396: ap_tax_codes_all offset,
3397: financials_system_params_all fsp,
3398: zx_party_tax_profile ptp
3399: WHERE

Line 4078: ar_vat_tax_all_b avtb

4074: userenv('LANG'),
4075: avtb.description
4076: FROM FND_LANGUAGES L,
4077: ZX_RATES_B RATES,
4078: ar_vat_tax_all_b avtb
4079: WHERE
4080: L.INSTALLED_FLAG in ('I', 'B')
4081: AND avtb.vat_tax_id = RATES.tax_rate_id
4082: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 4431: ar_vat_tax_all_b ar_codes,

4427: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
4428: FROM
4429: zx_update_criteria_results results,
4430: ap_tax_codes_all offset,
4431: ar_vat_tax_all_b ar_codes,
4432: financials_system_params_all fsp,
4433: zx_party_tax_profile ptp
4434: WHERE
4435: results.tax_code_id = offset.tax_id

Line 4740: ar_vat_tax_all_b ar_codes,

4736: offset.DESCRIPTION DESCRIPTION -- Bug 4705196
4737: FROM
4738: zx_update_criteria_results results,
4739: ap_tax_codes_all offset,
4740: ar_vat_tax_all_b ar_codes,
4741: financials_system_params_all fsp,
4742: zx_party_tax_profile ptp
4743: WHERE
4744: results.tax_code_id = offset.tax_id

Line 5419: ar_vat_tax_all_b avtb

5415: userenv('LANG'),
5416: avtb.description
5417: FROM FND_LANGUAGES L,
5418: ZX_RATES_B RATES,
5419: ar_vat_tax_all_b avtb
5420: WHERE
5421: L.INSTALLED_FLAG in ('I', 'B')
5422: AND avtb.vat_tax_id = RATES.tax_rate_id
5423: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 5722: ar_vat_tax_all_b avtb

5718: userenv('LANG'),
5719: avtb.description
5720: FROM FND_LANGUAGES L,
5721: ZX_RATES_B RATES,
5722: ar_vat_tax_all_b avtb
5723: WHERE
5724: L.INSTALLED_FLAG in ('I', 'B')
5725: AND avtb.vat_tax_id = RATES.tax_rate_id
5726: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 10743: ar_vat_tax_all_b ar_codes,

10739: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
10740: FROM
10741: zx_update_criteria_results results,
10742: ap_tax_codes_all codes,
10743: ar_vat_tax_all_b ar_codes,
10744: ap_tax_recvry_rules_all rec_rules,
10745: financials_system_params_all fsp,
10746: zx_party_tax_profile ptp
10747: WHERE

Line 10843: ar_vat_tax_all_b ar_codes,

10839:
10840: FROM
10841: zx_update_criteria_results results,
10842: ap_tax_codes_all codes,
10843: ar_vat_tax_all_b ar_codes,
10844: zx_update_criteria_results offset,
10845: financials_system_params_all fsp,
10846: ap_tax_recvry_rules_all rec_rules,
10847: zx_party_tax_profile ptp

Line 11166: ar_vat_tax_all_b ar_codes,

11162: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
11163: FROM
11164: zx_update_criteria_results results,
11165: ap_tax_codes_all codes,
11166: ar_vat_tax_all_b ar_codes,
11167: ap_tax_recvry_rules_all rec_rules,
11168: financials_system_params_all fsp,
11169: zx_party_tax_profile ptp
11170: WHERE

Line 11267: ar_vat_tax_all_b ar_codes,

11263:
11264: FROM
11265: zx_update_criteria_results results,
11266: ap_tax_codes_all codes,
11267: ar_vat_tax_all_b ar_codes,
11268: zx_update_criteria_results offset,
11269: financials_system_params_all fsp,
11270: ap_tax_recvry_rules_all rec_rules,
11271: zx_party_tax_profile ptp

Line 12470: ar_vat_tax_all_b ar_codes,

12466: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12467: FROM
12468: zx_update_criteria_results results,
12469: ap_tax_codes_all codes,
12470: ar_vat_tax_all_b ar_codes,
12471: ap_tax_recvry_rules_all rec_rules,
12472: financials_system_params_all fsp,
12473: zx_party_tax_profile ptp
12474: WHERE

Line 12569: ar_vat_tax_all_b ar_codes,

12565: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12566: FROM
12567: zx_update_criteria_results results,
12568: ap_tax_codes_all codes,
12569: ar_vat_tax_all_b ar_codes,
12570: zx_update_criteria_results offset,
12571: financials_system_params_all fsp,
12572: ap_tax_recvry_rules_all rec_rules,
12573: zx_party_tax_profile ptp

Line 12894: ar_vat_tax_all_b ar_codes,

12890: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12891: FROM
12892: zx_update_criteria_results results,
12893: ap_tax_codes_all codes,
12894: ar_vat_tax_all_b ar_codes,
12895: ap_tax_recvry_rules_all rec_rules,
12896: financials_system_params_all fsp,
12897: zx_party_tax_profile ptp
12898: WHERE

Line 12994: ar_vat_tax_all_b ar_codes,

12990: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
12991: FROM
12992: zx_update_criteria_results results,
12993: ap_tax_codes_all codes,
12994: ar_vat_tax_all_b ar_codes,
12995: zx_update_criteria_results offset,
12996: financials_system_params_all fsp,
12997: ap_tax_recvry_rules_all rec_rules,
12998: zx_party_tax_profile ptp

Line 13921: ar_vat_tax_all_b avtb

13917: userenv('LANG'),
13918: avtb.description
13919: FROM FND_LANGUAGES L,
13920: ZX_RATES_B RATES,
13921: ar_vat_tax_all_b avtb
13922: WHERE
13923: L.INSTALLED_FLAG in ('I', 'B')
13924: AND avtb.vat_tax_id = RATES.tax_rate_id
13925: AND RATES.RECORD_TYPE_CODE = 'MIGRATED'

Line 14046: ar_vat_tax_all_b

14042:
14043: SELECT 'Y' INTO ID_CLASH FROM DUAL
14044: WHERE EXISTS (select 1
14045: from ap_tax_codes_all,
14046: ar_vat_tax_all_b
14047: where tax_id = vat_tax_id);
14048: EXCEPTION
14049: WHEN no_data_found THEN
14050: arp_util_tax.debug('No data found exception encountered for tax definition in constructor :'||sqlerrm);