DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on STANDARD

Line 1050: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

1046: ,NULL TAX_APPLICABILITY_RESULT_ID
1047: ,'Y' TAX_APPORTIONMENT_FLAG
1048: ,1 TAX_APPORTIONMENT_LINE_NUMBER
1049: ,NULL TAX_BASE_MODIFIER_RATE
1050: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
1051: ,NULL TAX_CODE
1052: ,taxes.tax_currency_code TAX_CURRENCY_CODE
1053: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
1054: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 1096: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

1092: ,NULL TAX_TYPE_CODE
1093: ,NULL TAXABLE_AMT
1094: ,NULL TAXABLE_AMT_FUNCL_CURR
1095: ,NULL TAXABLE_AMT_TAX_CURR
1096: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
1097: ,NULL TAXING_JURIS_GEOGRAPHY_ID
1098: ,NULL THRESH_RESULT_ID
1099: ,NVL(poh.currency_code,
1100: poh.base_currency_code) TRX_CURRENCY_CODE

Line 1762: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

1758: rates.tax_regime_code,
1759: rates.tax
1760: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
1761: ,NULL TAX_BASE_MODIFIER_RATE
1762: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
1763: ,NULL TAX_CODE
1764: ,taxes.tax_currency_code TAX_CURRENCY_CODE
1765: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
1766: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 1809: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

1805: ,NULL TAX_TYPE_CODE
1806: ,NULL TAXABLE_AMT
1807: ,NULL TAXABLE_AMT_FUNCL_CURR
1808: ,NULL TAXABLE_AMT_TAX_CURR
1809: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
1810: ,NULL TAXING_JURIS_GEOGRAPHY_ID
1811: ,NULL THRESH_RESULT_ID
1812: ,NVL(poh.currency_code,
1813: poh.base_currency_code) TRX_CURRENCY_CODE

Line 2208: 'STANDARD')) RECOVERY_TYPE_CODE

2204: 'AD_HOC_RECOVERY') RECOVERY_RATE_CODE
2205: ,rates.tax_rate_id RECOVERY_RATE_ID
2206: ,DECODE(tmp.rec_flag,'N', NULL,
2207: NVL(rates.recovery_type_code,
2208: 'STANDARD')) RECOVERY_TYPE_CODE
2209: ,NULL RECOVERY_TYPE_ID
2210: ,NULL REF_DOC_CURR_CONV_RATE
2211: ,NULL REF_DOC_DIST_ID
2212: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 2338: AND rates.recovery_type_code(+) = 'STANDARD'

2334: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
2335: AND rates.tax(+) = pohzd.tax
2336: AND rates.content_owner_id(+) = pohzd.content_owner_id
2337: AND rates.rate_type_code(+) = 'RECOVERY'
2338: AND rates.recovery_type_code(+) = 'STANDARD'
2339: AND rates.active_flag(+) = 'Y'
2340: AND rates.effective_from(+) <= sysdate
2341: AND rates.record_type_code(+) = 'MIGRATED'
2342: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)

Line 3359: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

3355: ,NULL TAX_APPLICABILITY_RESULT_ID
3356: ,'Y' TAX_APPORTIONMENT_FLAG
3357: ,1 TAX_APPORTIONMENT_LINE_NUMBER
3358: ,NULL TAX_BASE_MODIFIER_RATE
3359: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
3360: ,NULL TAX_CODE
3361: ,taxes.tax_currency_code TAX_CURRENCY_CODE
3362: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
3363: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 3405: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

3401: ,NULL TAX_TYPE_CODE
3402: ,NULL TAXABLE_AMT
3403: ,NULL TAXABLE_AMT_FUNCL_CURR
3404: ,NULL TAXABLE_AMT_TAX_CURR
3405: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
3406: ,NULL TAXING_JURIS_GEOGRAPHY_ID
3407: ,NULL THRESH_RESULT_ID
3408: ,NVL(poll.poh_currency_code,
3409: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 4083: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

4079: rates.tax_regime_code,
4080: rates.tax
4081: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
4082: ,NULL TAX_BASE_MODIFIER_RATE
4083: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
4084: ,NULL TAX_CODE
4085: ,taxes.tax_currency_code TAX_CURRENCY_CODE
4086: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
4087: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 4130: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

4126: ,NULL TAX_TYPE_CODE
4127: ,NULL TAXABLE_AMT
4128: ,NULL TAXABLE_AMT_FUNCL_CURR
4129: ,NULL TAXABLE_AMT_TAX_CURR
4130: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
4131: ,NULL TAXING_JURIS_GEOGRAPHY_ID
4132: ,NULL THRESH_RESULT_ID
4133: ,NVL(poll.poh_currency_code,
4134: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 4541: 'STANDARD')) RECOVERY_TYPE_CODE

4537: 'AD_HOC_RECOVERY') RECOVERY_RATE_CODE
4538: ,rates.tax_rate_id RECOVERY_RATE_ID
4539: ,DECODE(tmp.rec_flag,'N', NULL,
4540: NVL(rates.recovery_type_code,
4541: 'STANDARD')) RECOVERY_TYPE_CODE
4542: ,NULL RECOVERY_TYPE_ID
4543: ,NULL REF_DOC_CURR_CONV_RATE
4544: ,NULL REF_DOC_DIST_ID
4545: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 4672: AND rates.recovery_type_code(+) = 'STANDARD'

4668: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
4669: AND rates.tax(+) = pohzd.tax
4670: AND rates.content_owner_id(+) = pohzd.content_owner_id
4671: AND rates.rate_type_code(+) = 'RECOVERY'
4672: AND rates.recovery_type_code(+) = 'STANDARD'
4673: AND rates.active_flag(+) = 'Y'
4674: AND rates.effective_from(+) <= sysdate
4675: AND rates.record_type_code(+) = 'MIGRATED'
4676: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)

Line 5753: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

5749: ,NULL TAX_APPLICABILITY_RESULT_ID
5750: ,'Y' TAX_APPORTIONMENT_FLAG
5751: ,1 TAX_APPORTIONMENT_LINE_NUMBER
5752: ,NULL TAX_BASE_MODIFIER_RATE
5753: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
5754: ,NULL TAX_CODE
5755: ,taxes.tax_currency_code TAX_CURRENCY_CODE
5756: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
5757: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 5799: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

5795: ,NULL TAX_TYPE_CODE
5796: ,NULL TAXABLE_AMT
5797: ,NULL TAXABLE_AMT_FUNCL_CURR
5798: ,NULL TAXABLE_AMT_TAX_CURR
5799: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
5800: ,NULL TAXING_JURIS_GEOGRAPHY_ID
5801: ,NULL THRESH_RESULT_ID
5802: ,NVL(poh.currency_code,
5803: poh.base_currency_code) TRX_CURRENCY_CODE

Line 6463: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

6459: rates.tax_regime_code,
6460: rates.tax
6461: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
6462: ,NULL TAX_BASE_MODIFIER_RATE
6463: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
6464: ,NULL TAX_CODE
6465: ,taxes.tax_currency_code TAX_CURRENCY_CODE
6466: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
6467: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 6510: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

6506: ,NULL TAX_TYPE_CODE
6507: ,NULL TAXABLE_AMT
6508: ,NULL TAXABLE_AMT_FUNCL_CURR
6509: ,NULL TAXABLE_AMT_TAX_CURR
6510: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
6511: ,NULL TAXING_JURIS_GEOGRAPHY_ID
6512: ,NULL THRESH_RESULT_ID
6513: ,NVL(poh.currency_code,
6514: poh.base_currency_code) TRX_CURRENCY_CODE

Line 6905: 'STANDARD')) RECOVERY_TYPE_CODE

6901: 'AD_HOC_RECOVERY') RECOVERY_RATE_CODE
6902: ,rates.tax_rate_id RECOVERY_RATE_ID
6903: ,DECODE(tmp.rec_flag,'N', NULL,
6904: NVL(rates.recovery_type_code,
6905: 'STANDARD')) RECOVERY_TYPE_CODE
6906: ,NULL RECOVERY_TYPE_ID
6907: ,NULL REF_DOC_CURR_CONV_RATE
6908: ,NULL REF_DOC_DIST_ID
6909: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 7041: AND rates.recovery_type_code(+) = 'STANDARD'

7037: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
7038: AND rates.tax(+) = pohzd.tax
7039: AND rates.content_owner_id(+) = pohzd.content_owner_id
7040: AND rates.rate_type_code(+) = 'RECOVERY'
7041: AND rates.recovery_type_code(+) = 'STANDARD'
7042: AND rates.active_flag(+) = 'Y'
7043: AND rates.effective_from(+) <= sysdate
7044: AND rates.record_type_code(+) = 'MIGRATED'
7045: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)

Line 8048: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

8044: ,NULL TAX_APPLICABILITY_RESULT_ID
8045: ,'Y' TAX_APPORTIONMENT_FLAG
8046: ,1 TAX_APPORTIONMENT_LINE_NUMBER
8047: ,NULL TAX_BASE_MODIFIER_RATE
8048: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
8049: ,NULL TAX_CODE
8050: ,taxes.tax_currency_code TAX_CURRENCY_CODE
8051: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
8052: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 8094: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

8090: ,NULL TAX_TYPE_CODE
8091: ,NULL TAXABLE_AMT
8092: ,NULL TAXABLE_AMT_FUNCL_CURR
8093: ,NULL TAXABLE_AMT_TAX_CURR
8094: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
8095: ,NULL TAXING_JURIS_GEOGRAPHY_ID
8096: ,NULL THRESH_RESULT_ID
8097: ,NVL(poll.poh_currency_code,
8098: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 8767: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

8763: rates.tax_regime_code,
8764: rates.tax
8765: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
8766: ,NULL TAX_BASE_MODIFIER_RATE
8767: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
8768: ,NULL TAX_CODE
8769: ,taxes.tax_currency_code TAX_CURRENCY_CODE
8770: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
8771: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 8814: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

8810: ,NULL TAX_TYPE_CODE
8811: ,NULL TAXABLE_AMT
8812: ,NULL TAXABLE_AMT_FUNCL_CURR
8813: ,NULL TAXABLE_AMT_TAX_CURR
8814: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
8815: ,NULL TAXING_JURIS_GEOGRAPHY_ID
8816: ,NULL THRESH_RESULT_ID
8817: ,NVL(poll.poh_currency_code,
8818: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 9218: 'STANDARD')) RECOVERY_TYPE_CODE

9214: 'AD_HOC_RECOVERY') RECOVERY_RATE_CODE
9215: ,rates.tax_rate_id RECOVERY_RATE_ID
9216: ,DECODE(tmp.rec_flag,'N', NULL,
9217: NVL(rates.recovery_type_code,
9218: 'STANDARD')) RECOVERY_TYPE_CODE
9219: ,NULL RECOVERY_TYPE_ID
9220: ,NULL REF_DOC_CURR_CONV_RATE
9221: ,NULL REF_DOC_DIST_ID
9222: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 9355: AND rates.recovery_type_code(+) = 'STANDARD'

9351: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
9352: AND rates.tax(+) = pohzd.tax
9353: AND rates.content_owner_id(+) = pohzd.content_owner_id
9354: AND rates.rate_type_code(+) = 'RECOVERY'
9355: AND rates.recovery_type_code(+) = 'STANDARD'
9356: AND rates.active_flag(+) = 'Y'
9357: AND rates.effective_from(+) <= sysdate
9358: AND rates.record_type_code(+) = 'MIGRATED'
9359: AND rates.percentage_rate(+) = NVL(NVL(pohzd.p_recovery_rate, pohzd.d_rec_rate),0)