APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_UPDATE_CRITERIA_RESULTS

Line 5244: zx_update_criteria_results results,

5240: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5241: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5242: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5243: FROM
5244: zx_update_criteria_results results,
5245: ar_vat_tax_all_b codes,
5246: zx_party_tax_profile ptp,
5247: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5248: WHERE

Line 5599: zx_update_criteria_results results,

5595: codes.DESCRIPTION DESCRIPTION ,-- Bug 4705196
5596: nvl(asp.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') ALLOW_EXEMPTIONS_FLAG,
5597: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5598: FROM
5599: zx_update_criteria_results results,
5600: ar_vat_tax_all_b codes,
5601: zx_party_tax_profile ptp,
5602: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5603: WHERE

Line 7678: ZX_UPDATE_CRITERIA_RESULTS results,

7674: -- decode(ARP.CROSS_CURRENCY_RATE_TYPE,'User','Corporate',ARP.CROSS_CURRENCY_RATE_TYPE) CROSS_CURRENCY_RATE_TYPE
7675: NULL CROSS_CURRENCY_RATE_TYPE
7676: FROM
7677: ZX_RATES_B RATES,
7678: ZX_UPDATE_CRITERIA_RESULTS results,
7679: AR_SYSTEM_PARAMETERS_ALL ARP,
7680: GL_SETS_OF_BOOKS SOB,
7681: ZX_PARTY_TAX_PROFILE PTP
7682: WHERE

Line 8031: ZX_UPDATE_CRITERIA_RESULTS results,

8027: -- decode(ARP.CROSS_CURRENCY_RATE_TYPE,'User','Corporate',ARP.CROSS_CURRENCY_RATE_TYPE) CROSS_CURRENCY_RATE_TYPE
8028: NULL CROSS_CURRENCY_RATE_TYPE
8029: FROM
8030: ZX_RATES_B RATES,
8031: ZX_UPDATE_CRITERIA_RESULTS results,
8032: AR_SYSTEM_PARAMETERS_ALL ARP,
8033: GL_SETS_OF_BOOKS SOB,
8034: ZX_PARTY_TAX_PROFILE PTP
8035: WHERE

Line 10226: | This routine updates zx_update_criteria_results table when

10222: | OUT
10223: | NA
10224: |
10225: | DESCRIPTION
10226: | This routine updates zx_update_criteria_results table when
10227: | there's tax codes with same name, one with tax_precedence with a
10228: | value the others with null tax_precedence.
10229: |
10230: | i.e.

Line 10262: UPDATE zx_update_criteria_results zucr1

10258: +==========================================================================*/
10259: PROCEDURE update_criteria_results AS
10260: BEGIN
10261:
10262: UPDATE zx_update_criteria_results zucr1
10263: SET tax_precedence = (SELECT zucr2.tax_precedence
10264: FROM zx_update_criteria_results zucr2
10265: WHERE zucr1.tax_code = zucr2.tax_code
10266: AND zucr1.tax_class = zucr2.tax_class

Line 10264: FROM zx_update_criteria_results zucr2

10260: BEGIN
10261:
10262: UPDATE zx_update_criteria_results zucr1
10263: SET tax_precedence = (SELECT zucr2.tax_precedence
10264: FROM zx_update_criteria_results zucr2
10265: WHERE zucr1.tax_code = zucr2.tax_code
10266: AND zucr1.tax_class = zucr2.tax_class
10267: AND zucr1.tax_class = 'OUTPUT'
10268: AND zucr1.org_id = zucr2.org_id