APPS.ZX_MIGRATE_TAX_DEF_COMMON dependencies on AR_VAT_TAX_ALL_B

Line 699: FROM ar_vat_tax_all_b codes,

695: sysdate creation_date,
696: fnd_global.user_id last_updated_by,
697: sysdate last_updated_date,
698: fnd_global.conc_login_id last_update_login
699: FROM ar_vat_tax_all_b codes,
700: ar_system_parameters_all asp
701: WHERE codes.tax_type not in ('TAX_GROUP', 'LOCATION')
702: AND asp.org_id = codes.org_id
703: -- Eliminate Tax Vendor Tax Codes

Line 821: FROM ar_vat_tax_all_b codes,

817: sysdate creation_date,
818: fnd_global.user_id last_updated_by,
819: sysdate last_updated_date,
820: fnd_global.conc_login_id last_update_login
821: FROM ar_vat_tax_all_b codes,
822: ar_system_parameters_all asp
823: WHERE codes.tax_type not in ('TAX_GROUP', 'LOCATION')
824: AND asp.org_id = codes.org_id
825: AND asp.org_id = l_org_id

Line 941: FROM ar_vat_tax_all_b codes,

937: sysdate creation_date,
938: fnd_global.user_id last_updated_by,
939: sysdate last_updated_date,
940: fnd_global.conc_login_id last_update_login
941: FROM ar_vat_tax_all_b codes,
942: ar_system_parameters_all asp,
943: zx_tax_priorities_t zxpt
944:
945: WHERE

Line 1023: FROM ar_vat_tax_all_b codes,

1019: sysdate creation_date,
1020: fnd_global.user_id last_updated_by,
1021: sysdate last_updated_date,
1022: fnd_global.conc_login_id last_update_login
1023: FROM ar_vat_tax_all_b codes,
1024: ar_system_parameters_all asp,
1025: zx_tax_priorities_t zxpt
1026:
1027: WHERE

Line 1143: ar_vat_tax_all_b ar_codes,

1139: ap_codes.start_date effective_from,
1140: ap_codes.inactive_date effective_to,
1141: 'Y' intercompany_flag
1142: FROM ap_tax_codes_all ap_codes,
1143: ar_vat_tax_all_b ar_codes,
1144: financials_system_params_all fsp,
1145: mtl_intercompany_parameters intcomp
1146: WHERE ap_codes.tax_type NOT IN ('AWT','TAX_GROUP')
1147: AND decode(l_multi_org_flag,'N',l_org_id,ap_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,fsp.org_id)

Line 1263: FROM ar_vat_tax_all_b ar_codes,

1259: fnd_global.conc_login_id last_update_login,
1260: ar_codes.start_date effective_from,
1261: ar_codes.end_date effective_to,
1262: 'Y' intercompany_flag
1263: FROM ar_vat_tax_all_b ar_codes,
1264: ap_tax_codes_all ap_codes,
1265: ar_system_parameters_all asp,
1266: mtl_intercompany_parameters intcomp
1267: WHERE ar_codes.tax_type <> 'TAX_GROUP'

Line 1363: ar_vat_tax_all_b avt,

1359: FROM fnd_id_flex_structures str,
1360: fnd_id_flex_segments segment,
1361: fnd_segment_attribute_values qual,
1362: ar_system_parameters_all asp,
1363: ar_vat_tax_all_b avt,
1364: gl_sets_of_books gsob
1365: WHERE str.id_flex_code = 'RLOC'
1366: AND str.application_id = 222
1367: AND str.application_id = segment.application_id

Line 2542: ar_vat_tax_all_b codes,

2538: (select rates.tax_regime_code tax_regime_code,
2539: lkups.meaning meaning,
2540: params.global_attribute_category global_attribute_category
2541: from zx_rates_b rates,
2542: ar_vat_tax_all_b codes,
2543: ar_system_parameters_all params,
2544: fnd_lookups lkups
2545: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2546: AND codes.org_id = params.org_id

Line 2622: ar_vat_tax_all_b codes,

2618: (select rates.tax_regime_code tax_regime_code,
2619: lkups.meaning meaning,
2620: params.global_attribute_category global_attribute_category
2621: from zx_rates_b rates,
2622: ar_vat_tax_all_b codes,
2623: ar_system_parameters_all params,
2624: fnd_lookups lkups
2625: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2626: AND codes.org_id = params.org_id

Line 2694: FROM ar_vat_tax_all_b;

2690:
2691: BEGIN
2692: SELECT min(start_date)
2693: INTO l_ar_min_start_date
2694: FROM ar_vat_tax_all_b;
2695: EXCEPTION
2696: WHEN NO_DATA_FOUND THEN
2697: l_ar_min_start_date := sysdate;
2698: END;

Line 2709: FROM ar_vat_tax_all_b;

2705:
2706: BEGIN
2707: SELECT count(*)
2708: INTO l_ar_count
2709: FROM ar_vat_tax_all_b;
2710: END;
2711:
2712: IF l_ap_count = 0 THEN
2713: l_ap_min_start_date := sysdate;