APPS.ZX_MIGRATE_TAX_DEF dependencies on STANDARD

Line 1233: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1229: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1230: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1231: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1232: 'Y',
1233: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1234: NULL),
1235: NULL,
1236: NULL,
1237: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 1237: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

1233: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1234: NULL),
1235: NULL,
1236: NULL,
1237: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1238: --NULL DEFAULT_REC_TAX ,
1239: --BugFix 3480468
1240: DECODE(codes.tax_recovery_rule_id,
1241: NULL,

Line 1244: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1240: DECODE(codes.tax_recovery_rule_id,
1241: NULL,
1242: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1243: 'Y',
1244: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1245: NULL),
1246: NULL) DEFAULT_REC_RATE_CODE,
1247: NULL OFFSET_TAX,
1248: NULL OFFSET_STATUS_CODE ,

Line 1332: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1328: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1329: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1330: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1331: 'Y',
1332: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1333: NULL),
1334: NULL,
1335: NULL,
1336: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 1336: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

1332: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1333: NULL),
1334: NULL,
1335: NULL,
1336: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1337: --NULL DEFAULT_REC_TAX ,
1338: --BugFix 3480468
1339: DECODE(codes.tax_recovery_rule_id,
1340: NULL,

Line 1343: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1339: DECODE(codes.tax_recovery_rule_id,
1340: NULL,
1341: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1342: 'Y',
1343: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1344: NULL),
1345: NULL) DEFAULT_REC_RATE_CODE,
1346: offset.tax OFFSET_TAX ,
1347: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 1654: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1650: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1651: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1652: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1653: 'Y',
1654: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1655: NULL),
1656: NULL,
1657: NULL,
1658: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 1658: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

1654: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1655: NULL),
1656: NULL,
1657: NULL,
1658: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1659: --NULL DEFAULT_REC_TAX ,
1660: --BugFix 3480468
1661: DECODE(codes.tax_recovery_rule_id,
1662: NULL,

Line 1665: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1661: DECODE(codes.tax_recovery_rule_id,
1662: NULL,
1663: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1664: 'Y',
1665: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1666: NULL),
1667: NULL) DEFAULT_REC_RATE_CODE,
1668: NULL OFFSET_TAX,
1669: NULL OFFSET_STATUS_CODE ,

Line 1754: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1750: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1751: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1752: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1753: 'Y',
1754: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1755: NULL),
1756: NULL,
1757: NULL,
1758: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 1758: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

1754: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1755: NULL),
1756: NULL,
1757: NULL,
1758: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1759: --NULL DEFAULT_REC_TAX ,
1760: --BugFix 3480468
1761: DECODE(codes.tax_recovery_rule_id,
1762: NULL,

Line 1765: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

1761: DECODE(codes.tax_recovery_rule_id,
1762: NULL,
1763: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1764: 'Y',
1765: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1766: NULL),
1767: NULL) DEFAULT_REC_RATE_CODE,
1768: offset.tax OFFSET_TAX ,
1769: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 2085: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2081: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2082: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2083: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2084: 'Y',
2085: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2086: NULL),
2087: NULL,
2088: NULL,
2089: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 2089: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

2085: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2086: NULL),
2087: NULL,
2088: NULL,
2089: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2090: --NULL DEFAULT_REC_TAX ,
2091: --BugFix 3480468
2092: DECODE(codes.tax_recovery_rule_id,
2093: NULL,

Line 2096: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2092: DECODE(codes.tax_recovery_rule_id,
2093: NULL,
2094: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2095: 'Y',
2096: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2097: NULL),
2098: NULL) DEFAULT_REC_RATE_CODE,
2099: NULL OFFSET_TAX,
2100: NULL OFFSET_STATUS_CODE ,

Line 2184: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2180: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2181: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2182: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2183: 'Y',
2184: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2185: NULL),
2186: NULL,
2187: NULL,
2188: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 2188: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

2184: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2185: NULL),
2186: NULL,
2187: NULL,
2188: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2189: --NULL DEFAULT_REC_TAX ,
2190: --BugFix 3480468
2191: DECODE(codes.tax_recovery_rule_id,
2192: NULL,

Line 2195: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2191: DECODE(codes.tax_recovery_rule_id,
2192: NULL,
2193: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2194: 'Y',
2195: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2196: NULL),
2197: NULL) DEFAULT_REC_RATE_CODE,
2198: offset.tax OFFSET_TAX ,
2199: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 2510: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2506: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2507: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2508: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2509: 'Y',
2510: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2511: NULL),
2512: NULL,
2513: NULL,
2514: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 2514: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

2510: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2511: NULL),
2512: NULL,
2513: NULL,
2514: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2515: --NULL DEFAULT_REC_TAX ,
2516: --BugFix 3480468
2517: DECODE(codes.tax_recovery_rule_id,
2518: NULL,

Line 2521: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2517: DECODE(codes.tax_recovery_rule_id,
2518: NULL,
2519: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2520: 'Y',
2521: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2522: NULL),
2523: NULL) DEFAULT_REC_RATE_CODE,
2524: NULL OFFSET_TAX,
2525: NULL OFFSET_STATUS_CODE ,

Line 2610: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2606: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2607: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2608: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2609: 'Y',
2610: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2611: NULL),
2612: NULL,
2613: NULL,
2614: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 2614: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

2610: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2611: NULL),
2612: NULL,
2613: NULL,
2614: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2615: --NULL DEFAULT_REC_TAX ,
2616: --BugFix 3480468
2617: DECODE(codes.tax_recovery_rule_id,
2618: NULL,

Line 2621: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

2617: DECODE(codes.tax_recovery_rule_id,
2618: NULL,
2619: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2620: 'Y',
2621: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2622: NULL),
2623: NULL) DEFAULT_REC_RATE_CODE,
2624: offset.tax OFFSET_TAX ,
2625: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 3038: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3034: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3035: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3036: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3037: 'Y',
3038: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3039: NULL),
3040: NULL,
3041: NULL,
3042: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 3042: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

3038: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3039: NULL),
3040: NULL,
3041: NULL,
3042: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3043: --NULL DEFAULT_REC_TAX ,
3044: --BugFix 3480468
3045: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3046: 'Y',

Line 3047: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3043: --NULL DEFAULT_REC_TAX ,
3044: --BugFix 3480468
3045: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3046: 'Y',
3047: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3048: NULL) DEFAULT_REC_RATE_CODE,
3049: NULL OFFSET_TAX ,
3050: NULL OFFSET_STATUS_CODE ,
3051: NULL OFFSET_TAX_RATE_CODE ,

Line 3349: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3345: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3346: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3347: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3348: 'Y',
3349: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3350: NULL),
3351: NULL,
3352: NULL,
3353: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 3353: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

3349: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3350: NULL),
3351: NULL,
3352: NULL,
3353: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3354: --NULL DEFAULT_REC_TAX ,
3355: --BugFix 3480468
3356: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3357: 'Y',

Line 3358: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3354: --NULL DEFAULT_REC_TAX ,
3355: --BugFix 3480468
3356: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3357: 'Y',
3358: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3359: NULL) DEFAULT_REC_RATE_CODE,
3360: NULL OFFSET_TAX ,
3361: NULL OFFSET_STATUS_CODE ,
3362: NULL OFFSET_TAX_RATE_CODE ,

Line 3669: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3665: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3666: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3667: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3668: 'Y',
3669: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3670: NULL),
3671: NULL,
3672: NULL,
3673: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 3673: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

3669: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3670: NULL),
3671: NULL,
3672: NULL,
3673: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3674: --NULL DEFAULT_REC_TAX ,
3675: --BugFix 3480468
3676: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3677: 'Y',

Line 3678: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3674: --NULL DEFAULT_REC_TAX ,
3675: --BugFix 3480468
3676: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3677: 'Y',
3678: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3679: NULL) DEFAULT_REC_RATE_CODE,
3680: NULL OFFSET_TAX ,
3681: NULL OFFSET_STATUS_CODE ,
3682: NULL OFFSET_TAX_RATE_CODE ,

Line 3980: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3976: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3977: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3978: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3979: 'Y',
3980: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3981: NULL),
3982: NULL,
3983: NULL,
3984: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 3984: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

3980: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3981: NULL),
3982: NULL,
3983: NULL,
3984: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3985: --NULL DEFAULT_REC_TAX ,
3986: --BugFix 3480468
3987: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3988: 'Y',

Line 3989: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

3985: --NULL DEFAULT_REC_TAX ,
3986: --BugFix 3480468
3987: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3988: 'Y',
3989: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3990: NULL) DEFAULT_REC_RATE_CODE,
3991: NULL OFFSET_TAX ,
3992: NULL OFFSET_STATUS_CODE ,
3993: NULL OFFSET_TAX_RATE_CODE ,

Line 4387: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

4383: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
4384: NULL DEFAULT_FLG_EFFECTIVE_TO ,
4385: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4386: 'Y',
4387: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4388: NULL),
4389: NULL,
4390: NULL,
4391: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 4391: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

4387: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4388: NULL),
4389: NULL,
4390: NULL,
4391: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
4392: --NULL DEFAULT_REC_TAX ,
4393: --BugFix 3480468
4394: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4395: 'Y',

Line 4396: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

4392: --NULL DEFAULT_REC_TAX ,
4393: --BugFix 3480468
4394: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4395: 'Y',
4396: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4397: NULL) DEFAULT_REC_RATE_CODE,
4398: NULL OFFSET_TAX ,
4399: NULL OFFSET_STATUS_CODE ,
4400: NULL OFFSET_TAX_RATE_CODE ,

Line 4696: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

4692: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
4693: NULL DEFAULT_FLG_EFFECTIVE_TO ,
4694: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4695: 'Y',
4696: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4697: NULL),
4698: NULL,
4699: NULL,
4700: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 4700: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

4696: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4697: NULL),
4698: NULL,
4699: NULL,
4700: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
4701: --NULL DEFAULT_REC_TAX ,
4702: --BugFix 3480468
4703: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4704: 'Y',

Line 4705: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

4701: --NULL DEFAULT_REC_TAX ,
4702: --BugFix 3480468
4703: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4704: 'Y',
4705: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4706: NULL) DEFAULT_REC_RATE_CODE,
4707: NULL OFFSET_TAX ,
4708: NULL OFFSET_STATUS_CODE ,
4709: NULL OFFSET_TAX_RATE_CODE ,

Line 5012: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

5008: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5009: NULL DEFAULT_FLG_EFFECTIVE_TO ,
5010: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5011: 'Y',
5012: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5013: NULL),
5014: NULL,
5015: NULL,
5016: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 5016: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

5012: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5013: NULL),
5014: NULL,
5015: NULL,
5016: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
5017:
5018: --NULL DEFAULT_REC_TAX ,
5019: --BugFix 3480468
5020: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),

Line 5022: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

5018: --NULL DEFAULT_REC_TAX ,
5019: --BugFix 3480468
5020: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5021: 'Y',
5022: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5023: NULL) DEFAULT_REC_RATE_CODE,
5024: NULL OFFSET_TAX ,
5025: NULL OFFSET_STATUS_CODE ,
5026: NULL OFFSET_TAX_RATE_CODE ,

Line 5323: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

5319: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5320: NULL DEFAULT_FLG_EFFECTIVE_TO ,
5321: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5322: 'Y',
5323: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5324: NULL),
5325: NULL,
5326: NULL,
5327: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 5327: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

5323: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5324: NULL),
5325: NULL,
5326: NULL,
5327: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
5328:
5329: --NULL DEFAULT_REC_TAX ,
5330: --BugFix 3480468
5331: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),

Line 5333: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),

5329: --NULL DEFAULT_REC_TAX ,
5330: --BugFix 3480468
5331: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5332: 'Y',
5333: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5334: NULL) DEFAULT_REC_RATE_CODE,
5335: NULL OFFSET_TAX ,
5336: NULL OFFSET_STATUS_CODE ,
5337: NULL OFFSET_TAX_RATE_CODE ,

Line 5624: 'STANDARD' RECOVERY_TYPE_CODE, --important

5620: NULL QUANTITY_RATE ,
5621: NULL UOM_CODE,
5622: (SELECT tax_id FROM zx_taxes_b WHERE tax_regime_code = rates.tax_regime_code AND tax = rates.tax AND content_owner_id = rates.content_owner_id)
5623: TAX_JURISDICTION_CODE,--Bug 4943105
5624: 'STANDARD' RECOVERY_TYPE_CODE, --important
5625: 'Y' ACTIVE_FLAG,
5626: 'N' DEFAULT_RATE_FLAG ,
5627: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5628: NULL DEFAULT_FLG_EFFECTIVE_TO ,

Line 5877: 'STANDARD-'||rates.recovery_rate TAX_RATE_CODE, --Bug 4644762 --Bug4882676

5873: FROM
5874: (
5875: SELECT
5876: DISTINCT
5877: 'STANDARD-'||rates.recovery_rate TAX_RATE_CODE, --Bug 4644762 --Bug4882676
5878: zx_rates.CONTENT_OWNER_ID ,
5879: (select min(start_date) from ap_tax_codes_all
5880: where tax_recovery_rule_id = codes.tax_recovery_rule_id
5881: group by tax_recovery_rule_id) EFFECTIVE_FROM,

Line 5894: 'STANDARD' RECOVERY_TYPE_CODE, --important

5890: NULL UOM_CODE,
5891: (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5892: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )
5893: TAX_JURISDICTION_CODE,
5894: 'STANDARD' RECOVERY_TYPE_CODE, --important
5895: rates.enabled_flag ACTIVE_FLAG,
5896: 'N' DEFAULT_RATE_FLAG ,
5897: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5898: NULL DEFAULT_FLG_EFFECTIVE_TO ,

Line 5923: substrb(tax_rate_code,1,instrb(tax_rate_code,'-',1,2)-1)) = 'STANDARD-'|| rates.recovery_rate -- Bug 4644762

5919: AND zx_rates.record_type_code = 'MIGRATED'
5920: AND not exists (select 1 from zx_rates_b
5921: where decode(instrb(tax_rate_code,'-',1,2),
5922: 0,tax_rate_code,
5923: substrb(tax_rate_code,1,instrb(tax_rate_code,'-',1,2)-1)) = 'STANDARD-'|| rates.recovery_rate -- Bug 4644762
5924: and rate_type_code = 'RECOVERY'
5925: and content_owner_id = zx_rates.content_owner_id
5926: AND tax_jurisdiction_code = (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5927: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )

Line 6080: 'STANDARD' RECOVERY_TYPE_CODE,

6076: 0 PERCENTAGE_RATE,
6077: NULL QUANTITY_RATE ,
6078: NULL UOM_CODE,
6079: taxes.tax_id TAX_JURISDICTION_CODE, --Bug 5477985
6080: 'STANDARD' RECOVERY_TYPE_CODE,
6081: 'Y' ACTIVE_FLAG,
6082: 'N' DEFAULT_RATE_FLAG ,
6083: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
6084: NULL DEFAULT_FLG_EFFECTIVE_TO ,

Line 6972: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE

6968: 'N' ,--USE_LEGAL_MSG_FLAG
6969: 'N' ,--CALC_ONLY_FLAG
6970: --BugFix 3485851(3480468)
6971: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
6972: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
6973: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
6974: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
6975: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
6976: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

Line 7081: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

7077: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
7078: --BugFix 3480468
7079: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7080: 'Y',
7081: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7082: NULL) DEF_PRIMARY_REC_RATE_CODE,
7083: nvl(FSP.non_recoverable_tax_flag,
7084: 'N') ALLOW_RECOVERABILITY_FLAG,
7085: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 7085: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

7081: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7082: NULL) DEF_PRIMARY_REC_RATE_CODE,
7083: nvl(FSP.non_recoverable_tax_flag,
7084: 'N') ALLOW_RECOVERABILITY_FLAG,
7085: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7086: --Review1 changes
7087: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7088: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7089: --Review1 changes

Line 7088: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

7084: 'N') ALLOW_RECOVERABILITY_FLAG,
7085: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7086: --Review1 changes
7087: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7088: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7089: --Review1 changes
7090: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
7091: NULL REP_TAX_AUTHORITY_ID,
7092: NULL COLL_TAX_AUTHORITY_ID,

Line 7145: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

7141: 'N', 'NEAREST') ,
7142: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
7143: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7144: 'Y',
7145: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7146: NULL) ,
7147: nvl(FSP.non_recoverable_tax_flag,
7148: 'N') ,
7149: NULL ,

Line 7368: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE

7364: 'N' ,--USE_LEGAL_MSG_FLAG
7365: 'N' ,--CALC_ONLY_FLAG
7366: --BugFix 3485851(3480468)
7367: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
7368: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
7369: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
7370: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
7371: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
7372: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

Line 7477: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

7473: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
7474: --BugFix 3480468
7475: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7476: 'Y',
7477: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7478: NULL) DEF_PRIMARY_REC_RATE_CODE,
7479: nvl(FSP.non_recoverable_tax_flag,
7480: 'N') ALLOW_RECOVERABILITY_FLAG,
7481: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 7481: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

7477: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7478: NULL) DEF_PRIMARY_REC_RATE_CODE,
7479: nvl(FSP.non_recoverable_tax_flag,
7480: 'N') ALLOW_RECOVERABILITY_FLAG,
7481: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7482: --Review1 changes
7483: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7484: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7485: --Review1 changes

Line 7484: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

7480: 'N') ALLOW_RECOVERABILITY_FLAG,
7481: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7482: --Review1 changes
7483: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7484: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7485: --Review1 changes
7486: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
7487: NULL REP_TAX_AUTHORITY_ID,
7488: NULL COLL_TAX_AUTHORITY_ID,

Line 7542: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

7538: 'N', 'NEAREST') ,
7539: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
7540: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7541: 'Y',
7542: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7543: NULL) ,
7544: nvl(FSP.non_recoverable_tax_flag,
7545: 'N') ,
7546: NULL ,

Line 7773: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE

7769: 'N' ,--USE_LEGAL_MSG_FLAG
7770: 'N' ,--CALC_ONLY_FLAG
7771: --BugFix 3485851(3480468)
7772: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
7773: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
7774: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
7775: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
7776: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
7777: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

Line 7879: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

7875: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
7876: --BugFix 3480468
7877: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7878: 'Y',
7879: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7880: NULL) DEF_PRIMARY_REC_RATE_CODE,
7881: nvl(FSP.non_recoverable_tax_flag,
7882: 'N') ALLOW_RECOVERABILITY_FLAG,
7883: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 7883: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

7879: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7880: NULL) DEF_PRIMARY_REC_RATE_CODE,
7881: nvl(FSP.non_recoverable_tax_flag,
7882: 'N') ALLOW_RECOVERABILITY_FLAG,
7883: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7884: --Review1 changes
7885: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7886: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7887: --Review1 changes

Line 7886: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

7882: 'N') ALLOW_RECOVERABILITY_FLAG,
7883: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7884: --Review1 changes
7885: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7886: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7887: --Review1 changes
7888: RATES.DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE,
7889: NULL REP_TAX_AUTHORITY_ID,
7890: NULL COLL_TAX_AUTHORITY_ID,

Line 7948: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

7944: 'N', 'NEAREST') ,
7945: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
7946: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7947: 'Y',
7948: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7949: NULL) ,
7950: nvl(FSP.non_recoverable_tax_flag,
7951: 'N') ,
7952: NULL ,

Line 8198: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE

8194: 'N' ,--USE_LEGAL_MSG_FLAG
8195: 'N' ,--CALC_ONLY_FLAG
8196: --BugFix 3485851(3480468)
8197: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
8198: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
8199: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
8200: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
8201: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
8202: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

Line 8304: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

8300: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
8301: --BugFix 3480468
8302: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
8303: 'Y',
8304: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
8305: NULL) DEF_PRIMARY_REC_RATE_CODE,
8306: nvl(FSP.non_recoverable_tax_flag,
8307: 'N') ALLOW_RECOVERABILITY_FLAG,
8308: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 8308: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

8304: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
8305: NULL) DEF_PRIMARY_REC_RATE_CODE,
8306: nvl(FSP.non_recoverable_tax_flag,
8307: 'N') ALLOW_RECOVERABILITY_FLAG,
8308: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
8309: --Review1 changes
8310: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
8311: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
8312: --Review1 changes

Line 8311: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

8307: 'N') ALLOW_RECOVERABILITY_FLAG,
8308: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
8309: --Review1 changes
8310: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
8311: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
8312: --Review1 changes
8313: RATES.DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE,
8314: NULL REP_TAX_AUTHORITY_ID,
8315: NULL COLL_TAX_AUTHORITY_ID,

Line 8374: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),

8370: 'N', 'NEAREST') ,
8371: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
8372: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
8373: 'Y',
8374: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
8375: NULL) ,
8376: nvl(FSP.non_recoverable_tax_flag,
8377: 'N') ,
8378: NULL ,

Line 9488: 'STANDARD' ,--RECOVERY_TYPE_CODE

9484: TAX_REGIME_CODE ,
9485: 'DET_RECOVERY_RATE' ,--SERVICE_TYPE_CODE
9486: --200 ,--APPLICATION_ID --Review1 changes
9487: NULL ,--APPLICATION_ID --bug 7395339
9488: 'STANDARD' ,--RECOVERY_TYPE_CODE
9489: 1 ,--PRIORITY
9490: 'Y' ,--SYSTEM_DEFAULT_FLAG
9491: EFFECTIVE_FROM ,
9492: NULL ,--EFFECTIVE_TO

Line 9604: 'STANDARD' ,--RECOVERY_TYPE_CODE

9600: TAX_REGIME_CODE ,
9601: 'DET_RECOVERY_RATE' ,--SERVICE_TYPE_CODE
9602: --200 ,--APPLICATION_ID --Review1 changes
9603: NULL ,--APPLICATION_ID --bug 7395339
9604: 'STANDARD' ,--RECOVERY_TYPE_CODE
9605: 1 ,--PRIORITY
9606: 'Y' ,--SYSTEM_DEFAULT_FLAG
9607: EFFECTIVE_FROM ,
9608: NULL ,--EFFECTIVE_TO

Line 9813: 'STANDARD-' || AP_RATES.RECOVERY_RATE ALPHANUMERIC_RESULT,--ALPHANUMERIC_RESULT

9809: (SELECT DISTINCT
9810: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE
9811: AP_RATES.rule_id AP_RULE_ID,--AP_RULE_ID
9812: AP_RATES.rate_id AP_RATE_ID,--AP_RATE_ID
9813: 'STANDARD-' || AP_RATES.RECOVERY_RATE ALPHANUMERIC_RESULT,--ALPHANUMERIC_RESULT
9814: ptp.party_tax_profile_id CONTENT_OWNER_ID,--CONTENT_OWNER_ID
9815: GROUPS.CONDITION_GROUP_ID CONDITION_GROUP_ID,--CONDITION_GROUP_ID
9816: ZX_RULES.TAX_RULE_ID TAX_RULE_ID, --TAX_RULE_ID
9817: -- Added as a fix for Bug#7412888

Line 9864: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE

9860: )
9861: AND not exists (select 1 from zx_process_results
9862: where tax_rule_id = zx_rules.tax_rule_id
9863: and condition_group_code = groups.condition_group_code
9864: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
9865: )
9866:
9867: );
9868:

Line 9952: 'STANDARD-' || AP_RATES.RECOVERY_RATE ALPHANUMERIC_RESULT,--ALPHANUMERIC_RESULT

9948: (SELECT DISTINCT
9949: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE
9950: AP_RATES.rule_id AP_RULE_ID,--AP_RULE_ID
9951: AP_RATES.rate_id AP_RATE_ID,--AP_RATE_ID
9952: 'STANDARD-' || AP_RATES.RECOVERY_RATE ALPHANUMERIC_RESULT,--ALPHANUMERIC_RESULT
9953: ptp.party_tax_profile_id CONTENT_OWNER_ID,--CONTENT_OWNER_ID
9954: GROUPS.CONDITION_GROUP_ID CONDITION_GROUP_ID,--CONDITION_GROUP_ID
9955: ZX_RULES.TAX_RULE_ID TAX_RULE_ID, --TAX_RULE_ID
9956: -- Added as a fix for Bug#7412888

Line 10004: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE

10000: )
10001: AND not exists (select 1 from zx_process_results
10002: where tax_rule_id = zx_rules.tax_rule_id
10003: and condition_group_code = groups.condition_group_code
10004: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
10005: )
10006: );
10007:
10008: END IF;

Line 10688: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

10684: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
10685: NULL DEFAULT_FLG_EFFECTIVE_TO ,
10686: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
10687: 'Y',
10688: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
10689: NULL),
10690: NULL,
10691: NULL,
10692: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 10692: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

10688: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
10689: NULL),
10690: NULL,
10691: NULL,
10692: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
10693: --NULL DEFAULT_REC_TAX ,
10694: --BugFix 3480468
10695: DECODE(codes.tax_recovery_rule_id,
10696: NULL,

Line 10699: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

10695: DECODE(codes.tax_recovery_rule_id,
10696: NULL,
10697: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
10698: 'Y',
10699: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
10700: NULL),
10701: NULL) DEFAULT_REC_RATE_CODE,
10702: NULL OFFSET_TAX,
10703: NULL OFFSET_STATUS_CODE ,

Line 10787: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

10783: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
10784: NULL DEFAULT_FLG_EFFECTIVE_TO ,
10785: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
10786: 'Y',
10787: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
10788: NULL),
10789: NULL,
10790: NULL,
10791: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 10791: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

10787: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
10788: NULL),
10789: NULL,
10790: NULL,
10791: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
10792: --NULL DEFAULT_REC_TAX ,
10793: --BugFix 3480468
10794: DECODE(codes.tax_recovery_rule_id,
10795: NULL,

Line 10798: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

10794: DECODE(codes.tax_recovery_rule_id,
10795: NULL,
10796: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
10797: 'Y',
10798: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
10799: NULL),
10800: NULL) DEFAULT_REC_RATE_CODE,
10801: offset.tax OFFSET_TAX ,
10802: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 11111: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11107: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11108: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11109: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11110: 'Y',
11111: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11112: NULL),
11113: NULL,
11114: NULL,
11115: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 11115: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

11111: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11112: NULL),
11113: NULL,
11114: NULL,
11115: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11116: --NULL DEFAULT_REC_TAX ,
11117: --BugFix 3480468
11118: DECODE(codes.tax_recovery_rule_id,
11119: NULL,

Line 11122: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11118: DECODE(codes.tax_recovery_rule_id,
11119: NULL,
11120: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11121: 'Y',
11122: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11123: NULL),
11124: NULL) DEFAULT_REC_RATE_CODE,
11125: NULL OFFSET_TAX,
11126: NULL OFFSET_STATUS_CODE ,

Line 11211: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11207: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11208: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11209: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11210: 'Y',
11211: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11212: NULL),
11213: NULL,
11214: NULL,
11215: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 11215: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

11211: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11212: NULL),
11213: NULL,
11214: NULL,
11215: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11216: --NULL DEFAULT_REC_TAX ,
11217: --BugFix 3480468
11218: DECODE(codes.tax_recovery_rule_id,
11219: NULL,

Line 11222: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11218: DECODE(codes.tax_recovery_rule_id,
11219: NULL,
11220: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11221: 'Y',
11222: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11223: NULL),
11224: NULL) DEFAULT_REC_RATE_CODE,
11225: offset.tax OFFSET_TAX ,
11226: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 11548: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11544: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11545: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11546: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11547: 'Y',
11548: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11549: NULL),
11550: NULL,
11551: NULL,
11552: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 11552: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

11548: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11549: NULL),
11550: NULL,
11551: NULL,
11552: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11553: --NULL DEFAULT_REC_TAX ,
11554: --BugFix 3480468
11555: DECODE(codes.tax_recovery_rule_id,
11556: NULL,

Line 11559: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11555: DECODE(codes.tax_recovery_rule_id,
11556: NULL,
11557: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11558: 'Y',
11559: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11560: NULL),
11561: NULL) DEFAULT_REC_RATE_CODE,
11562: NULL OFFSET_TAX,
11563: NULL OFFSET_STATUS_CODE ,

Line 11647: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11643: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11644: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11645: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11646: 'Y',
11647: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11648: NULL),
11649: NULL,
11650: NULL,
11651: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 11651: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

11647: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11648: NULL),
11649: NULL,
11650: NULL,
11651: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11652: --NULL DEFAULT_REC_TAX ,
11653: --BugFix 3480468
11654: DECODE(codes.tax_recovery_rule_id,
11655: NULL,

Line 11658: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11654: DECODE(codes.tax_recovery_rule_id,
11655: NULL,
11656: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11657: 'Y',
11658: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11659: NULL),
11660: NULL) DEFAULT_REC_RATE_CODE,
11661: offset.tax OFFSET_TAX ,
11662: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 11973: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11969: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11970: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11971: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11972: 'Y',
11973: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11974: NULL),
11975: NULL,
11976: NULL,
11977: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 11977: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

11973: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11974: NULL),
11975: NULL,
11976: NULL,
11977: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11978: --NULL DEFAULT_REC_TAX ,
11979: --BugFix 3480468
11980: DECODE(codes.tax_recovery_rule_id,
11981: NULL,

Line 11984: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

11980: DECODE(codes.tax_recovery_rule_id,
11981: NULL,
11982: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11983: 'Y',
11984: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11985: NULL),
11986: NULL) DEFAULT_REC_RATE_CODE,
11987: NULL OFFSET_TAX,
11988: NULL OFFSET_STATUS_CODE ,

Line 12073: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12069: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12070: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12071: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12072: 'Y',
12073: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12074: NULL),
12075: NULL,
12076: NULL,
12077: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 12077: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

12073: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12074: NULL),
12075: NULL,
12076: NULL,
12077: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12078: --NULL DEFAULT_REC_TAX ,
12079: --BugFix 3480468
12080: DECODE(codes.tax_recovery_rule_id,
12081: NULL,

Line 12084: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12080: DECODE(codes.tax_recovery_rule_id,
12081: NULL,
12082: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12083: 'Y',
12084: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12085: NULL),
12086: NULL) DEFAULT_REC_RATE_CODE,
12087: offset.tax OFFSET_TAX ,
12088: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 12415: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12411: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12412: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12413: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12414: 'Y',
12415: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12416: NULL),
12417: NULL,
12418: NULL,
12419: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 12419: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

12415: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12416: NULL),
12417: NULL,
12418: NULL,
12419: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12420: --NULL DEFAULT_REC_TAX ,
12421: --BugFix 3480468
12422: DECODE(codes.tax_recovery_rule_id,
12423: NULL,

Line 12426: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12422: DECODE(codes.tax_recovery_rule_id,
12423: NULL,
12424: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12425: 'Y',
12426: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12427: NULL),
12428: NULL) DEFAULT_REC_RATE_CODE,
12429: NULL OFFSET_TAX,
12430: NULL OFFSET_STATUS_CODE ,

Line 12514: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12510: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12511: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12512: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12513: 'Y',
12514: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12515: NULL),
12516: NULL,
12517: NULL,
12518: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 12518: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

12514: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12515: NULL),
12516: NULL,
12517: NULL,
12518: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12519: --NULL DEFAULT_REC_TAX ,
12520: --BugFix 3480468
12521: DECODE(codes.tax_recovery_rule_id,
12522: NULL,

Line 12525: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12521: DECODE(codes.tax_recovery_rule_id,
12522: NULL,
12523: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12524: 'Y',
12525: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12526: NULL),
12527: NULL) DEFAULT_REC_RATE_CODE,
12528: offset.tax OFFSET_TAX ,
12529: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 12839: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12835: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12836: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12837: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12838: 'Y',
12839: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12840: NULL),
12841: NULL,
12842: NULL,
12843: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 12843: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

12839: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12840: NULL),
12841: NULL,
12842: NULL,
12843: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12844: --NULL DEFAULT_REC_TAX ,
12845: --BugFix 3480468
12846: DECODE(codes.tax_recovery_rule_id,
12847: NULL,

Line 12850: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12846: DECODE(codes.tax_recovery_rule_id,
12847: NULL,
12848: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12849: 'Y',
12850: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12851: NULL),
12852: NULL) DEFAULT_REC_RATE_CODE,
12853: NULL OFFSET_TAX,
12854: NULL OFFSET_STATUS_CODE ,

Line 12939: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12935: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12936: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12937: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12938: 'Y',
12939: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12940: NULL),
12941: NULL,
12942: NULL,
12943: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 12943: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

12939: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12940: NULL),
12941: NULL,
12942: NULL,
12943: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12944: --NULL DEFAULT_REC_TAX ,
12945: --BugFix 3480468
12946: DECODE(codes.tax_recovery_rule_id,
12947: NULL,

Line 12950: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

12946: DECODE(codes.tax_recovery_rule_id,
12947: NULL,
12948: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12949: 'Y',
12950: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12951: NULL),
12952: NULL) DEFAULT_REC_RATE_CODE,
12953: offset.tax OFFSET_TAX ,
12954: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 13278: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13274: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13275: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13276: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13277: 'Y',
13278: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13279: NULL),
13280: NULL,
13281: NULL,
13282: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 13282: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

13278: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13279: NULL),
13280: NULL,
13281: NULL,
13282: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13283: --NULL DEFAULT_REC_TAX ,
13284: --BugFix 3480468
13285: DECODE(codes.tax_recovery_rule_id,
13286: NULL,

Line 13289: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13285: DECODE(codes.tax_recovery_rule_id,
13286: NULL,
13287: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13288: 'Y',
13289: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13290: NULL),
13291: NULL) DEFAULT_REC_RATE_CODE,
13292: NULL OFFSET_TAX,
13293: NULL OFFSET_STATUS_CODE ,

Line 13377: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13373: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13374: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13375: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13376: 'Y',
13377: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13378: NULL),
13379: NULL,
13380: NULL,
13381: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 13381: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

13377: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13378: NULL),
13379: NULL,
13380: NULL,
13381: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13382: --NULL DEFAULT_REC_TAX ,
13383: --BugFix 3480468
13384: DECODE(codes.tax_recovery_rule_id,
13385: NULL,

Line 13388: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13384: DECODE(codes.tax_recovery_rule_id,
13385: NULL,
13386: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13387: 'Y',
13388: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13389: NULL),
13390: NULL) DEFAULT_REC_RATE_CODE,
13391: offset.tax OFFSET_TAX ,
13392: offset.tax_status_code OFFSET_STATUS_CODE ,

Line 13703: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13699: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13700: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13701: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13702: 'Y',
13703: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13704: NULL),
13705: NULL,
13706: NULL,
13707: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 13707: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

13703: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13704: NULL),
13705: NULL,
13706: NULL,
13707: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13708: --NULL DEFAULT_REC_TAX ,
13709: --BugFix 3480468
13710: DECODE(codes.tax_recovery_rule_id,
13711: NULL,

Line 13714: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13710: DECODE(codes.tax_recovery_rule_id,
13711: NULL,
13712: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13713: 'Y',
13714: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13715: NULL),
13716: NULL) DEFAULT_REC_RATE_CODE,
13717: NULL OFFSET_TAX,
13718: NULL OFFSET_STATUS_CODE ,

Line 13803: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13799: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13800: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13801: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13802: 'Y',
13803: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13804: NULL),
13805: NULL,
13806: NULL,
13807: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

Line 13807: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

13803: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13804: NULL),
13805: NULL,
13806: NULL,
13807: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13808: --NULL DEFAULT_REC_TAX ,
13809: --BugFix 3480468
13810: DECODE(codes.tax_recovery_rule_id,
13811: NULL,

Line 13814: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),

13810: DECODE(codes.tax_recovery_rule_id,
13811: NULL,
13812: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13813: 'Y',
13814: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13815: NULL),
13816: NULL) DEFAULT_REC_RATE_CODE,
13817: offset.tax OFFSET_TAX ,
13818: offset.tax_status_code OFFSET_STATUS_CODE ,