640: opt.ALLOW_ROUNDING_OVERRIDE_FLAG ALLOW_ROUNDING_OVERRIDE_FLAG
641: From
642: GL_TAX_OPTIONS opt,
643: ap_tax_codes_all aptax,
644: zx_RATES_B rates
645: Where
646: opt.ledger_id = aptax.set_of_books_id and
647: decode(l_multi_org_flag,'N',l_org_id,opt.org_id)= decode(l_multi_org_flag,'N',l_org_id,aptax.org_id) and
648: opt.input_tax_code = aptax.name and
845: From
846: gl_tax_option_accounts accounts,
847: ap_tax_codes_all aptax,
848: gl_tax_options opt,
849: zx_rates_b rates
850: Where
851: accounts.ledger_id = opt.ledger_id and
852: decode(l_multi_org_flag,'N',l_org_id,accounts.org_id) = decode(l_multi_org_flag,'N',l_org_id,opt.org_id) and
853: accounts.ledger_id = aptax.set_of_books_id and
1031: opt.ALLOW_ROUNDING_OVERRIDE_FLAG ALLOW_ROUNDING_OVERRIDE_FLAG
1032: From
1033: GL_TAX_OPTIONS opt,
1034: AR_VAT_TAX_ALL artax,
1035: zx_RATES_B rates
1036: Where
1037: opt.ledger_id = artax.set_of_books_id and
1038: decode(l_multi_org_flag,'N',l_org_id,opt.org_id) = decode(l_multi_org_flag,'N',l_org_id,artax.org_id) and
1039: opt.output_tax_code = artax.tax_code and
1238: From
1239: gl_tax_option_accounts accounts,
1240: ar_vat_tax_all artax,
1241: gl_tax_options opt,
1242: zx_rates_b rates
1243: Where
1244: accounts.ledger_id = opt.ledger_id and
1245: decode(l_multi_org_flag,'N',l_org_id,opt.org_id) = decode(l_multi_org_flag,'N',l_org_id,accounts.org_id) and
1246: accounts.ledger_id = artax.set_of_books_id and