APPS.ZX_MIGRATE_TAX_DEF_COMMON dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 114: financials_system_params_all fsp

110: fnd_global.user_id last_updated_by,
111: sysdate last_updated_date,
112: fnd_global.conc_login_id last_update_login
113: FROM ap_tax_codes_all codes,
114: financials_system_params_all fsp
115: WHERE codes.tax_type NOT IN ('AWT','TAX_GROUP','OFFSET')
116: AND codes.org_id = fsp.org_id
117: -- Sync process
118: AND codes.tax_id = nvl(p_tax_id,codes.tax_id)

Line 220: financials_system_params_all fsp

216: fnd_global.user_id last_updated_by,
217: sysdate last_updated_date,
218: fnd_global.conc_login_id last_update_login
219: FROM ap_tax_codes_all codes,
220: financials_system_params_all fsp
221: WHERE codes.tax_type NOT IN ('AWT','TAX_GROUP','OFFSET')
222: AND codes.org_id = fsp.org_id
223: AND codes.org_id = l_org_id
224: -- Sync process

Line 326: financials_system_params_all fsp

322: sysdate last_updated_date,
323: fnd_global.conc_login_id last_update_login
324: FROM ap_tax_codes_all codes,
325: ap_tax_codes_all offset,
326: financials_system_params_all fsp
327: WHERE offset.tax_type = 'OFFSET'
328: AND offset.tax_id = codes.offset_tax_code_id
329: AND codes.offset_tax_code_id IS NOT NULL
330: AND codes.org_id = fsp.org_id

Line 430: financials_system_params_all fsp

426: sysdate last_updated_date,
427: fnd_global.conc_login_id last_update_login
428: FROM ap_tax_codes_all codes,
429: ap_tax_codes_all offset,
430: financials_system_params_all fsp
431: WHERE offset.tax_type = 'OFFSET'
432: AND offset.tax_id = codes.offset_tax_code_id
433: AND codes.offset_tax_code_id IS NOT NULL
434: AND codes.org_id = fsp.org_id

Line 508: financials_system_params_all fsp

504: sysdate last_updated_date,
505: fnd_global.conc_login_id last_update_login
506: FROM
507: ap_tax_codes_all offset,
508: financials_system_params_all fsp
509: WHERE offset.tax_type = 'OFFSET'
510: AND offset.org_id = fsp.org_id
511: AND not exists (select 1 from ap_tax_codes_all where
512: offset_tax_code_id = offset.tax_id)

Line 578: financials_system_params_all fsp

574: sysdate last_updated_date,
575: fnd_global.conc_login_id last_update_login
576: FROM
577: ap_tax_codes_all offset,
578: financials_system_params_all fsp
579: WHERE offset.tax_type = 'OFFSET'
580: AND offset.org_id = fsp.org_id
581: AND offset.org_id = l_org_id
582: AND not exists (select 1 from ap_tax_codes_all where

Line 1221: financials_system_params_all fsp,

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)
1225: AND decode(l_multi_org_flag,'N',l_org_id,ap_codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,intcomp.sell_organization_id)