[Home] [Help]
245: p_tax,
246: p_tax_status_code,
247: p_tax_rate_code
248: FROM zx_rates_b zrb,
249: zx_party_tax_profile zptp
250: WHERE
251: zptp.party_type_code = 'OU'
252: AND zptp.party_tax_profile_id = zrb.content_owner_id
253: AND zrb.record_type_code = 'MIGRATED'
2093: NULL L_TAX_EXMPT_SOURCE_TAX,
2094: 'N' L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2095: FROM
2096: ar_vat_tax_all_b avt,
2097: zx_party_tax_profile ptp,
2098: ar_system_parameters_all asp,
2099: gl_sets_of_books gsob,
2100: zx_regimes_b zrb
2101: WHERE avt.org_id = ptp.party_id
2507: NULL L_TAX_EXMPT_SOURCE_TAX,
2508: 'N' L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2509: FROM
2510: ar_vat_tax_all_b avt,
2511: zx_party_tax_profile ptp,
2512: ar_system_parameters_all asp,
2513: gl_sets_of_books gsob,
2514: zx_regimes_b zrb
2515: WHERE avt.org_id = ptp.party_id
3009: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3010: FROM
3011: zx_status_b status,
3012: ar_vat_tax_all_b codes,
3013: zx_party_tax_profile ptp,
3014: ar_system_parameters_all asp
3015: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3016: AND status.tax = 'LOCATION'
3017: AND status.tax_status_code = 'STANDARD'
3344: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3345: FROM
3346: zx_status_b status,
3347: ar_vat_tax_all_b codes,
3348: zx_party_tax_profile ptp,
3349: ar_system_parameters_all asp
3350: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3351: AND status.tax = 'LOCATION'
3352: AND status.tax_status_code = 'STANDARD'
4418: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4419: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4420: FROM
4421: ar_vat_tax_all_b avt,
4422: zx_party_tax_profile ptp,
4423: ar_system_parameters_all asp,
4424: zx_regimes_b zrb,
4425: zx_taxes_b ztb
4426: WHERE ptp.party_type_code = 'OU'
4750: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4751: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4752: FROM
4753: ar_vat_tax_all_b avt,
4754: zx_party_tax_profile ptp,
4755: ar_system_parameters_all asp,
4756: zx_regimes_b zrb,
4757: zx_taxes_b ztb
4758: WHERE ptp.party_type_code = 'OU'
4803: location_tax_account_rec,
4804: set_of_books_id_rec,
4805: location_structure_id_rec
4806: FROM ar_system_parameters_all asp,
4807: zx_party_tax_profile ptp
4808: WHERE ptp.party_type_code = 'OU'
4809: AND ptp.party_id = asp.org_id
4810: AND asp.tax_database_view_set IN ('_A', '_V');
4811: ELSE
4820: location_tax_account_rec,
4821: set_of_books_id_rec,
4822: location_structure_id_rec
4823: FROM ar_system_parameters_all asp,
4824: zx_party_tax_profile ptp
4825: WHERE ptp.party_type_code = 'OU'
4826: AND ptp.party_id = asp.org_id
4827: AND asp.org_id = l_org_id
4828: AND asp.tax_database_view_set IN ('_A', '_V');
5238: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5239: FROM
5240: zx_update_criteria_results results,
5241: ar_vat_tax_all_b codes,
5242: zx_party_tax_profile ptp,
5243: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5244: WHERE
5245: results.tax_code_id = codes.vat_tax_id
5246: AND results.tax_class = 'OUTPUT'
5585: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5586: FROM
5587: zx_update_criteria_results results,
5588: ar_vat_tax_all_b codes,
5589: zx_party_tax_profile ptp,
5590: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5591: WHERE
5592: results.tax_code_id = codes.vat_tax_id
5593: AND results.tax_class = 'OUTPUT'
5936: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5937: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
5938: FROM
5939: ar_vat_tax_all_b codes,
5940: zx_party_tax_profile ptp,
5941: ar_system_parameters_all params,
5942: jl_zz_ar_tx_categ_all categs
5943: WHERE
5944: codes.tax_type <> 'TAX_GROUP'
6119: BEGIN
6120: SELECT ztb.tax
6121: INTO l_tax
6122: FROM zx_taxes_b ztb,
6123: zx_party_tax_profile zptp
6124: WHERE ztb.content_owner_id = zptp.party_tax_profile_id
6125: AND zptp.party_type_code = 'OU'
6126: AND zptp.party_id = l_org_id
6127: AND ztb.tax = 'LOCATION'
7665: ZX_RATES_B RATES,
7666: ZX_UPDATE_CRITERIA_RESULTS results,
7667: AR_SYSTEM_PARAMETERS_ALL ARP,
7668: GL_SETS_OF_BOOKS SOB,
7669: ZX_PARTY_TAX_PROFILE PTP
7670: WHERE
7671: -- Bug 4691005 : 1. removed nvl source_id
7672: -- 2. added condition for tax_class
7673: RESULTS.tax_code_id = rates.tax_rate_id
8018: ZX_RATES_B RATES,
8019: ZX_UPDATE_CRITERIA_RESULTS results,
8020: AR_SYSTEM_PARAMETERS_ALL ARP,
8021: GL_SETS_OF_BOOKS SOB,
8022: ZX_PARTY_TAX_PROFILE PTP
8023: WHERE
8024: -- Bug 4691005 : 1. removed nvl source_id
8025: -- 2. added condition for tax_class
8026: RESULTS.tax_code_id = rates.tax_rate_id
8813: update zx_taxes_b_tmp
8814: set allow_manual_entry_flag = 'N',
8815: allow_tax_override_flag = 'N',
8816: object_version_number = object_version_number + 1
8817: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile
8818: where party_id= to_number(l_org_id(i))
8819: and party_type_code='OU')
8820: and record_type_code='MIGRATED';
8821:
8827: BEGIN
8828: update zx_status_b_tmp
8829: set allow_rate_override_flag = 'N',
8830: object_version_number = object_version_number + 1
8831: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile
8832: where party_id= to_number(l_org_id(i))
8833: and party_type_code='OU')
8834: and record_type_code='MIGRATED';
8835:
10182: FROM
10183: fnd_languages l,
10184: zx_rates_b b,
10185: ar_system_parameters_all asp,
10186: zx_party_tax_profile ptp,
10187: ar_vat_tax_all_b avtb
10188: WHERE
10189: l.installed_flag in ('I', 'B')
10190: AND avtb.vat_tax_id = b.tax_rate_id
10304: l_allow_exceptions_flag VARCHAR2(100);
10305: BEGIN
10306: FOR cursor_rec IN (SELECT party_id,
10307: party_tax_profile_id
10308: FROM zx_party_tax_profile
10309: WHERE party_tax_profile_id IN (SELECT content_owner_id
10310: FROM zx_rates_b
10311: WHERE tax_class = 'OUTPUT'
10312: INTERSECT