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 981: FROM ar_vat_tax_all_b codes,

977: sysdate creation_date,
978: fnd_global.user_id last_updated_by,
979: sysdate last_updated_date,
980: fnd_global.conc_login_id last_update_login
981: FROM ar_vat_tax_all_b codes,
982: ar_system_parameters_all asp,
983: zx_tax_priorities_t zxpt
984:
985: WHERE

Line 1100: FROM ar_vat_tax_all_b codes,

1096: sysdate creation_date,
1097: fnd_global.user_id last_updated_by,
1098: sysdate last_updated_date,
1099: fnd_global.conc_login_id last_update_login
1100: FROM ar_vat_tax_all_b codes,
1101: ar_system_parameters_all asp,
1102: zx_tax_priorities_t zxpt
1103:
1104: WHERE

Line 1220: ar_vat_tax_all_b ar_codes,

1216: ap_codes.start_date effective_from,
1217: ap_codes.inactive_date effective_to,
1218: 'Y' intercompany_flag
1219: FROM ap_tax_codes_all ap_codes,
1220: ar_vat_tax_all_b ar_codes,
1221: financials_system_params_all fsp,
1222: mtl_intercompany_parameters intcomp
1223: WHERE ap_codes.tax_type NOT IN ('AWT','TAX_GROUP')
1224: 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 1340: FROM ar_vat_tax_all_b ar_codes,

1336: fnd_global.conc_login_id last_update_login,
1337: ar_codes.start_date effective_from,
1338: ar_codes.end_date effective_to,
1339: 'Y' intercompany_flag
1340: FROM ar_vat_tax_all_b ar_codes,
1341: ap_tax_codes_all ap_codes,
1342: ar_system_parameters_all asp,
1343: mtl_intercompany_parameters intcomp
1344: WHERE ar_codes.tax_type <> 'TAX_GROUP'

Line 1440: ar_vat_tax_all_b avt,

1436: FROM fnd_id_flex_structures str,
1437: fnd_id_flex_segments segment,
1438: fnd_segment_attribute_values qual,
1439: ar_system_parameters_all asp,
1440: ar_vat_tax_all_b avt,
1441: gl_sets_of_books gsob
1442: WHERE str.id_flex_code = 'RLOC'
1443: AND str.application_id = 222
1444: AND str.application_id = segment.application_id

Line 2619: ar_vat_tax_all_b codes,

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

Line 2699: ar_vat_tax_all_b codes,

2695: (select rates.tax_regime_code tax_regime_code,
2696: lkups.meaning meaning,
2697: params.global_attribute_category global_attribute_category
2698: from zx_rates_b rates,
2699: ar_vat_tax_all_b codes,
2700: ar_system_parameters_all params,
2701: fnd_lookups lkups
2702: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
2703: AND codes.org_id = params.org_id

Line 2771: FROM ar_vat_tax_all_b;

2767:
2768: BEGIN
2769: SELECT min(start_date)
2770: INTO l_ar_min_start_date
2771: FROM ar_vat_tax_all_b;
2772: EXCEPTION
2773: WHEN NO_DATA_FOUND THEN
2774: l_ar_min_start_date := sysdate;
2775: END;

Line 2788: FROM ar_vat_tax_all_b;

2784:
2785: BEGIN
2786: SELECT count(*)
2787: INTO l_ar_count
2788: FROM ar_vat_tax_all_b;
2789: END;
2790:
2791: IF l_ap_count = 0 THEN
2792: l_ap_min_start_date := sysdate;