APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_UPDATE_CRITERIA_RESULTS

Line 5240: zx_update_criteria_results results,

5236: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5237: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
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

Line 5587: zx_update_criteria_results results,

5583: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5584: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
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

Line 7666: ZX_UPDATE_CRITERIA_RESULTS results,

7662: -- decode(ARP.CROSS_CURRENCY_RATE_TYPE,'User','Corporate',ARP.CROSS_CURRENCY_RATE_TYPE) CROSS_CURRENCY_RATE_TYPE
7663: NULL CROSS_CURRENCY_RATE_TYPE
7664: FROM
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

Line 8019: ZX_UPDATE_CRITERIA_RESULTS results,

8015: -- decode(ARP.CROSS_CURRENCY_RATE_TYPE,'User','Corporate',ARP.CROSS_CURRENCY_RATE_TYPE) CROSS_CURRENCY_RATE_TYPE
8016: NULL CROSS_CURRENCY_RATE_TYPE
8017: FROM
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

Line 10217: | This routine updates zx_update_criteria_results table when

10213: | OUT
10214: | NA
10215: |
10216: | DESCRIPTION
10217: | This routine updates zx_update_criteria_results table when
10218: | there's tax codes with same name, one with tax_precedence with a
10219: | value the others with null tax_precedence.
10220: |
10221: | i.e.

Line 10253: UPDATE zx_update_criteria_results zucr1

10249: +==========================================================================*/
10250: PROCEDURE update_criteria_results AS
10251: BEGIN
10252:
10253: UPDATE zx_update_criteria_results zucr1
10254: SET tax_precedence = (SELECT zucr2.tax_precedence
10255: FROM zx_update_criteria_results zucr2
10256: WHERE zucr1.tax_code = zucr2.tax_code
10257: AND zucr1.tax_class = zucr2.tax_class

Line 10255: FROM zx_update_criteria_results zucr2

10251: BEGIN
10252:
10253: UPDATE zx_update_criteria_results zucr1
10254: SET tax_precedence = (SELECT zucr2.tax_precedence
10255: FROM zx_update_criteria_results zucr2
10256: WHERE zucr1.tax_code = zucr2.tax_code
10257: AND zucr1.tax_class = zucr2.tax_class
10258: AND zucr1.tax_class = 'OUTPUT'
10259: AND zucr1.org_id = zucr2.org_id