APPS.ZX_MIGRATE_TAX_DEF dependencies on STANDARD

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

1248: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1249: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1250: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1251: 'Y',
1252: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1253: NULL),
1254: NULL,
1255: NULL,
1256: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

1252: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1253: NULL),
1254: NULL,
1255: NULL,
1256: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1257: --NULL DEFAULT_REC_TAX ,
1258: --BugFix 3480468
1259: DECODE(codes.tax_recovery_rule_id,
1260: NULL,

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

1259: DECODE(codes.tax_recovery_rule_id,
1260: NULL,
1261: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1262: 'Y',
1263: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1264: NULL),
1265: NULL) DEFAULT_REC_RATE_CODE,
1266: NULL OFFSET_TAX,
1267: NULL OFFSET_STATUS_CODE ,

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

1343: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1344: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1345: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1346: 'Y',
1347: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1348: NULL),
1349: NULL,
1350: NULL,
1351: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

1347: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1348: NULL),
1349: NULL,
1350: NULL,
1351: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1352: --NULL DEFAULT_REC_TAX ,
1353: --BugFix 3480468
1354: DECODE(codes.tax_recovery_rule_id,
1355: NULL,

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

1354: DECODE(codes.tax_recovery_rule_id,
1355: NULL,
1356: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1357: 'Y',
1358: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1359: NULL),
1360: NULL) DEFAULT_REC_RATE_CODE,
1361: offset.tax OFFSET_TAX ,
1362: offset.tax_status_code OFFSET_STATUS_CODE ,

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

1665: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1666: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1667: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1668: 'Y',
1669: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1670: NULL),
1671: NULL,
1672: NULL,
1673: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

1669: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1670: NULL),
1671: NULL,
1672: NULL,
1673: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1674: --NULL DEFAULT_REC_TAX ,
1675: --BugFix 3480468
1676: DECODE(codes.tax_recovery_rule_id,
1677: NULL,

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

1676: DECODE(codes.tax_recovery_rule_id,
1677: NULL,
1678: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1679: 'Y',
1680: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1681: NULL),
1682: NULL) DEFAULT_REC_RATE_CODE,
1683: NULL OFFSET_TAX,
1684: NULL OFFSET_STATUS_CODE ,

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

1761: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
1762: NULL DEFAULT_FLG_EFFECTIVE_TO ,
1763: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1764: 'Y',
1765: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1766: NULL),
1767: NULL,
1768: NULL,
1769: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

1765: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1766: NULL),
1767: NULL,
1768: NULL,
1769: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
1770: --NULL DEFAULT_REC_TAX ,
1771: --BugFix 3480468
1772: DECODE(codes.tax_recovery_rule_id,
1773: NULL,

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

1772: DECODE(codes.tax_recovery_rule_id,
1773: NULL,
1774: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
1775: 'Y',
1776: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
1777: NULL),
1778: NULL) DEFAULT_REC_RATE_CODE,
1779: offset.tax OFFSET_TAX ,
1780: offset.tax_status_code OFFSET_STATUS_CODE ,

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

2092: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2093: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2094: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2095: 'Y',
2096: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2097: NULL),
2098: NULL,
2099: NULL,
2100: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

2096: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2097: NULL),
2098: NULL,
2099: NULL,
2100: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2101: --NULL DEFAULT_REC_TAX ,
2102: --BugFix 3480468
2103: DECODE(codes.tax_recovery_rule_id,
2104: NULL,

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

2103: DECODE(codes.tax_recovery_rule_id,
2104: NULL,
2105: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2106: 'Y',
2107: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2108: NULL),
2109: NULL) DEFAULT_REC_RATE_CODE,
2110: NULL OFFSET_TAX,
2111: NULL OFFSET_STATUS_CODE ,

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

2190: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2191: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2192: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2193: 'Y',
2194: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2195: NULL),
2196: NULL,
2197: NULL,
2198: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

2194: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2195: NULL),
2196: NULL,
2197: NULL,
2198: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2199: --NULL DEFAULT_REC_TAX ,
2200: --BugFix 3480468
2201: DECODE(codes.tax_recovery_rule_id,
2202: NULL,

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

2201: DECODE(codes.tax_recovery_rule_id,
2202: NULL,
2203: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2204: 'Y',
2205: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2206: NULL),
2207: NULL) DEFAULT_REC_RATE_CODE,
2208: offset.tax OFFSET_TAX ,
2209: offset.tax_status_code OFFSET_STATUS_CODE ,

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

2516: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2517: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2518: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2519: 'Y',
2520: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2521: NULL),
2522: NULL,
2523: NULL,
2524: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

2520: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2521: NULL),
2522: NULL,
2523: NULL,
2524: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2525: --NULL DEFAULT_REC_TAX ,
2526: --BugFix 3480468
2527: DECODE(codes.tax_recovery_rule_id,
2528: NULL,

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

2527: DECODE(codes.tax_recovery_rule_id,
2528: NULL,
2529: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2530: 'Y',
2531: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2532: NULL),
2533: NULL) DEFAULT_REC_RATE_CODE,
2534: NULL OFFSET_TAX,
2535: NULL OFFSET_STATUS_CODE ,

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

2615: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
2616: NULL DEFAULT_FLG_EFFECTIVE_TO ,
2617: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2618: 'Y',
2619: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2620: NULL),
2621: NULL,
2622: NULL,
2623: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

2619: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2620: NULL),
2621: NULL,
2622: NULL,
2623: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
2624: --NULL DEFAULT_REC_TAX ,
2625: --BugFix 3480468
2626: DECODE(codes.tax_recovery_rule_id,
2627: NULL,

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

2626: DECODE(codes.tax_recovery_rule_id,
2627: NULL,
2628: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
2629: 'Y',
2630: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
2631: NULL),
2632: NULL) DEFAULT_REC_RATE_CODE,
2633: offset.tax OFFSET_TAX ,
2634: offset.tax_status_code OFFSET_STATUS_CODE ,

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

3050: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3051: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3052: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3053: 'Y',
3054: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3055: NULL),
3056: NULL,
3057: NULL,
3058: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

3054: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3055: NULL),
3056: NULL,
3057: NULL,
3058: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3059: --NULL DEFAULT_REC_TAX ,
3060: --BugFix 3480468
3061: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3062: 'Y',

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

3059: --NULL DEFAULT_REC_TAX ,
3060: --BugFix 3480468
3061: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3062: 'Y',
3063: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3064: NULL) DEFAULT_REC_RATE_CODE,
3065: NULL OFFSET_TAX ,
3066: NULL OFFSET_STATUS_CODE ,
3067: NULL OFFSET_TAX_RATE_CODE ,

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

3363: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3364: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3365: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3366: 'Y',
3367: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3368: NULL),
3369: NULL,
3370: NULL,
3371: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

3367: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3368: NULL),
3369: NULL,
3370: NULL,
3371: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3372: --NULL DEFAULT_REC_TAX ,
3373: --BugFix 3480468
3374: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3375: 'Y',

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

3372: --NULL DEFAULT_REC_TAX ,
3373: --BugFix 3480468
3374: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3375: 'Y',
3376: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3377: NULL) DEFAULT_REC_RATE_CODE,
3378: NULL OFFSET_TAX ,
3379: NULL OFFSET_STATUS_CODE ,
3380: NULL OFFSET_TAX_RATE_CODE ,

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

3685: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3686: NULL DEFAULT_FLG_EFFECTIVE_TO ,
3687: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3688: 'Y',
3689: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3690: NULL),
3691: NULL,
3692: NULL,
3693: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

3689: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3690: NULL),
3691: NULL,
3692: NULL,
3693: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
3694: --NULL DEFAULT_REC_TAX ,
3695: --BugFix 3480468
3696: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3697: 'Y',

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

3694: --NULL DEFAULT_REC_TAX ,
3695: --BugFix 3480468
3696: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
3697: 'Y',
3698: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
3699: NULL) DEFAULT_REC_RATE_CODE,
3700: NULL OFFSET_TAX ,
3701: NULL OFFSET_STATUS_CODE ,
3702: NULL OFFSET_TAX_RATE_CODE ,

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

3998: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
3999: NULL DEFAULT_FLG_EFFECTIVE_TO ,
4000: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4001: 'Y',
4002: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4003: NULL),
4004: NULL,
4005: NULL,
4006: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

4002: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4003: NULL),
4004: NULL,
4005: NULL,
4006: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
4007: --NULL DEFAULT_REC_TAX ,
4008: --BugFix 3480468
4009: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4010: 'Y',

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

4007: --NULL DEFAULT_REC_TAX ,
4008: --BugFix 3480468
4009: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4010: 'Y',
4011: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4012: NULL) DEFAULT_REC_RATE_CODE,
4013: NULL OFFSET_TAX ,
4014: NULL OFFSET_STATUS_CODE ,
4015: NULL OFFSET_TAX_RATE_CODE ,

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

4407: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
4408: NULL DEFAULT_FLG_EFFECTIVE_TO ,
4409: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4410: 'Y',
4411: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4412: NULL),
4413: NULL,
4414: NULL,
4415: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

4411: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4412: NULL),
4413: NULL,
4414: NULL,
4415: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
4416: --NULL DEFAULT_REC_TAX ,
4417: --BugFix 3480468
4418: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4419: 'Y',

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

4416: --NULL DEFAULT_REC_TAX ,
4417: --BugFix 3480468
4418: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4419: 'Y',
4420: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4421: NULL) DEFAULT_REC_RATE_CODE,
4422: NULL OFFSET_TAX ,
4423: NULL OFFSET_STATUS_CODE ,
4424: NULL OFFSET_TAX_RATE_CODE ,

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

4718: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
4719: NULL DEFAULT_FLG_EFFECTIVE_TO ,
4720: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4721: 'Y',
4722: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4723: NULL),
4724: NULL,
4725: NULL,
4726: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

4722: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4723: NULL),
4724: NULL,
4725: NULL,
4726: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
4727: --NULL DEFAULT_REC_TAX ,
4728: --BugFix 3480468
4729: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4730: 'Y',

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

4727: --NULL DEFAULT_REC_TAX ,
4728: --BugFix 3480468
4729: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
4730: 'Y',
4731: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
4732: NULL) DEFAULT_REC_RATE_CODE,
4733: NULL OFFSET_TAX ,
4734: NULL OFFSET_STATUS_CODE ,
4735: NULL OFFSET_TAX_RATE_CODE ,

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

5036: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5037: NULL DEFAULT_FLG_EFFECTIVE_TO ,
5038: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5039: 'Y',
5040: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5041: NULL),
5042: NULL,
5043: NULL,
5044: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

5040: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5041: NULL),
5042: NULL,
5043: NULL,
5044: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
5045:
5046: --NULL DEFAULT_REC_TAX ,
5047: --BugFix 3480468
5048: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),

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

5046: --NULL DEFAULT_REC_TAX ,
5047: --BugFix 3480468
5048: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5049: 'Y',
5050: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5051: NULL) DEFAULT_REC_RATE_CODE,
5052: NULL OFFSET_TAX ,
5053: NULL OFFSET_STATUS_CODE ,
5054: NULL OFFSET_TAX_RATE_CODE ,

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

5349: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5350: NULL DEFAULT_FLG_EFFECTIVE_TO ,
5351: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5352: 'Y',
5353: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5354: NULL),
5355: NULL,
5356: NULL,
5357: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

5353: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5354: NULL),
5355: NULL,
5356: NULL,
5357: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
5358:
5359: --NULL DEFAULT_REC_TAX ,
5360: --BugFix 3480468
5361: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),

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

5359: --NULL DEFAULT_REC_TAX ,
5360: --BugFix 3480468
5361: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
5362: 'Y',
5363: 'STANDARD-'||nvl(offset.tax_recovery_rate,0),
5364: NULL) DEFAULT_REC_RATE_CODE,
5365: NULL OFFSET_TAX ,
5366: NULL OFFSET_STATUS_CODE ,
5367: NULL OFFSET_TAX_RATE_CODE ,

Line 5654: 'STANDARD' RECOVERY_TYPE_CODE, --important

5650: NULL QUANTITY_RATE ,
5651: NULL UOM_CODE,
5652: (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)
5653: TAX_JURISDICTION_CODE,--Bug 4943105
5654: 'STANDARD' RECOVERY_TYPE_CODE, --important
5655: 'Y' ACTIVE_FLAG,
5656: 'N' DEFAULT_RATE_FLAG ,
5657: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5658: NULL DEFAULT_FLG_EFFECTIVE_TO ,

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

5904: FROM
5905: (
5906: SELECT
5907: DISTINCT
5908: 'STANDARD-'||rates.recovery_rate TAX_RATE_CODE, --Bug 4644762 --Bug4882676
5909: zx_rates.CONTENT_OWNER_ID ,
5910: (select min(start_date) from ap_tax_codes_all
5911: where tax_recovery_rule_id = codes.tax_recovery_rule_id
5912: group by tax_recovery_rule_id) EFFECTIVE_FROM,

Line 5925: 'STANDARD' RECOVERY_TYPE_CODE, --important

5921: NULL UOM_CODE,
5922: (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5923: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )
5924: TAX_JURISDICTION_CODE,
5925: 'STANDARD' RECOVERY_TYPE_CODE, --important
5926: rates.enabled_flag ACTIVE_FLAG,
5927: 'N' DEFAULT_RATE_FLAG ,
5928: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
5929: NULL DEFAULT_FLG_EFFECTIVE_TO ,

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

5950: AND zx_rates.record_type_code = 'MIGRATED'
5951: AND not exists (select 1 from zx_rates_b
5952: where decode(instrb(tax_rate_code,'-',1,2),
5953: 0,tax_rate_code,
5954: substrb(tax_rate_code,1,instrb(tax_rate_code,'-',1,2)-1)) = 'STANDARD-'|| rates.recovery_rate -- Bug 4644762
5955: and rate_type_code = 'RECOVERY'
5956: and content_owner_id = zx_rates.content_owner_id
5957: AND tax_jurisdiction_code = (select tax_id from zx_taxes_b where tax = zx_rates.tax and tax_regime_code
5958: = zx_rates.tax_regime_code and content_owner_id = zx_rates.content_owner_id )

Line 6111: 'STANDARD' RECOVERY_TYPE_CODE,

6107: 0 PERCENTAGE_RATE,
6108: NULL QUANTITY_RATE ,
6109: NULL UOM_CODE,
6110: taxes.tax_id TAX_JURISDICTION_CODE, --Bug 5477985
6111: 'STANDARD' RECOVERY_TYPE_CODE,
6112: 'Y' ACTIVE_FLAG,
6113: 'N' DEFAULT_RATE_FLAG ,
6114: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
6115: NULL DEFAULT_FLG_EFFECTIVE_TO ,

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

6996: 'N' ,--USE_LEGAL_MSG_FLAG
6997: 'N' ,--CALC_ONLY_FLAG
6998: --BugFix 3485851(3480468)
6999: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
7000: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
7001: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
7002: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
7003: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
7004: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

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

7103: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
7104: --BugFix 3480468
7105: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7106: 'Y',
7107: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7108: NULL) DEF_PRIMARY_REC_RATE_CODE,
7109: nvl(FSP.non_recoverable_tax_flag,
7110: 'N') ALLOW_RECOVERABILITY_FLAG,
7111: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 7111: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

7107: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7108: NULL) DEF_PRIMARY_REC_RATE_CODE,
7109: nvl(FSP.non_recoverable_tax_flag,
7110: 'N') ALLOW_RECOVERABILITY_FLAG,
7111: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7112: --Review1 changes
7113: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7114: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7115: --Review1 changes

Line 7114: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

7110: 'N') ALLOW_RECOVERABILITY_FLAG,
7111: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7112: --Review1 changes
7113: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7114: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7115: --Review1 changes
7116: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
7117: NULL REP_TAX_AUTHORITY_ID,
7118: NULL COLL_TAX_AUTHORITY_ID,

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

7167: 'N', 'NEAREST') ,
7168: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
7169: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7170: 'Y',
7171: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7172: NULL) ,
7173: nvl(FSP.non_recoverable_tax_flag,
7174: 'N') ,
7175: NULL ,

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

7388: 'N' ,--USE_LEGAL_MSG_FLAG
7389: 'N' ,--CALC_ONLY_FLAG
7390: --BugFix 3485851(3480468)
7391: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
7392: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
7393: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
7394: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
7395: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
7396: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

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

7495: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
7496: --BugFix 3480468
7497: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7498: 'Y',
7499: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7500: NULL) DEF_PRIMARY_REC_RATE_CODE,
7501: nvl(FSP.non_recoverable_tax_flag,
7502: 'N') ALLOW_RECOVERABILITY_FLAG,
7503: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 7503: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

7499: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7500: NULL) DEF_PRIMARY_REC_RATE_CODE,
7501: nvl(FSP.non_recoverable_tax_flag,
7502: 'N') ALLOW_RECOVERABILITY_FLAG,
7503: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7504: --Review1 changes
7505: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7506: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7507: --Review1 changes

Line 7506: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

7502: 'N') ALLOW_RECOVERABILITY_FLAG,
7503: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7504: --Review1 changes
7505: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7506: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7507: --Review1 changes
7508: NULL DEF_REC_SETTLEMENT_OPTION_CODE,
7509: NULL REP_TAX_AUTHORITY_ID,
7510: NULL COLL_TAX_AUTHORITY_ID,

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

7560: 'N', 'NEAREST') ,
7561: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
7562: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7563: 'Y',
7564: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7565: NULL) ,
7566: nvl(FSP.non_recoverable_tax_flag,
7567: 'N') ,
7568: NULL ,

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

7791: 'N' ,--USE_LEGAL_MSG_FLAG
7792: 'N' ,--CALC_ONLY_FLAG
7793: --BugFix 3485851(3480468)
7794: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
7795: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
7796: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
7797: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
7798: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
7799: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

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

7897: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
7898: --BugFix 3480468
7899: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7900: 'Y',
7901: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7902: NULL) DEF_PRIMARY_REC_RATE_CODE,
7903: nvl(FSP.non_recoverable_tax_flag,
7904: 'N') ALLOW_RECOVERABILITY_FLAG,
7905: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 7905: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

7901: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7902: NULL) DEF_PRIMARY_REC_RATE_CODE,
7903: nvl(FSP.non_recoverable_tax_flag,
7904: 'N') ALLOW_RECOVERABILITY_FLAG,
7905: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7906: --Review1 changes
7907: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7908: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7909: --Review1 changes

Line 7908: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

7904: 'N') ALLOW_RECOVERABILITY_FLAG,
7905: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
7906: --Review1 changes
7907: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
7908: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
7909: --Review1 changes
7910: RATES.DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE,
7911: NULL REP_TAX_AUTHORITY_ID,
7912: NULL COLL_TAX_AUTHORITY_ID,

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

7966: 'N', 'NEAREST') ,
7967: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
7968: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
7969: 'Y',
7970: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
7971: NULL) ,
7972: nvl(FSP.non_recoverable_tax_flag,
7973: 'N') ,
7974: NULL ,

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

8216: 'N' ,--USE_LEGAL_MSG_FLAG
8217: 'N' ,--CALC_ONLY_FLAG
8218: --BugFix 3485851(3480468)
8219: DECODE(ALLOW_RECOVERABILITY_FLAG,'Y',
8220: 'STANDARD',NULL) ,--PRIMARY_RECOVERY_TYPE_CODE
8221: 'N' ,--PRIMARY_REC_TYPE_RULE_FLAG
8222: NULL ,--SECONDARY_RECOVERY_TYPE_CODE
8223: 'N' ,--SECONDARY_REC_TYPE_RULE_FLAG
8224: 'N' ,--PRIMARY_REC_RATE_DET_RULE_FLAG

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

8322: ASP.AMOUNT_INCLUDES_TAX_FLAG DEF_INCLUSIVE_TAX_FLAG,
8323: --BugFix 3480468
8324: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
8325: 'Y',
8326: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
8327: NULL) DEF_PRIMARY_REC_RATE_CODE,
8328: nvl(FSP.non_recoverable_tax_flag,
8329: 'N') ALLOW_RECOVERABILITY_FLAG,
8330: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

Line 8330: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,

8326: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
8327: NULL) DEF_PRIMARY_REC_RATE_CODE,
8328: nvl(FSP.non_recoverable_tax_flag,
8329: 'N') ALLOW_RECOVERABILITY_FLAG,
8330: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
8331: --Review1 changes
8332: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
8333: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
8334: --Review1 changes

Line 8333: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,

8329: 'N') ALLOW_RECOVERABILITY_FLAG,
8330: 'STANDARD_TC' DEF_TAX_CALC_FORMULA,
8331: --Review1 changes
8332: ASP.amount_includes_tax_override TAX_INCLUSIVE_OVERRIDE_FLAG,
8333: 'STANDARD_TB' DEF_TAXABLE_BASIS_FORMULA,
8334: --Review1 changes
8335: RATES.DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE,
8336: NULL REP_TAX_AUTHORITY_ID,
8337: NULL COLL_TAX_AUTHORITY_ID,

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

8392: 'N', 'NEAREST') ,
8393: ASP.AMOUNT_INCLUDES_TAX_FLAG ,
8394: DECODE(NVL(FSP.non_recoverable_tax_flag, 'N'),
8395: 'Y',
8396: 'STANDARD-'||nvl(FSP.default_recovery_rate,0),
8397: NULL) ,
8398: nvl(FSP.non_recoverable_tax_flag,
8399: 'N') ,
8400: NULL ,

Line 9786: 'STANDARD' ,--RECOVERY_TYPE_CODE

9782: TAX_REGIME_CODE ,
9783: 'DET_RECOVERY_RATE' ,--SERVICE_TYPE_CODE
9784: --200 ,--APPLICATION_ID --Review1 changes
9785: NULL ,--APPLICATION_ID --bug 7395339
9786: 'STANDARD' ,--RECOVERY_TYPE_CODE
9787: 1 ,--PRIORITY
9788: 'Y' ,--SYSTEM_DEFAULT_FLAG
9789: EFFECTIVE_FROM ,
9790: NULL ,--EFFECTIVE_TO

Line 9897: 'STANDARD' ,--RECOVERY_TYPE_CODE

9893: TAX_REGIME_CODE ,
9894: 'DET_RECOVERY_RATE' ,--SERVICE_TYPE_CODE
9895: --200 ,--APPLICATION_ID --Review1 changes
9896: NULL ,--APPLICATION_ID --bug 7395339
9897: 'STANDARD' ,--RECOVERY_TYPE_CODE
9898: 1 ,--PRIORITY
9899: 'Y' ,--SYSTEM_DEFAULT_FLAG
9900: EFFECTIVE_FROM ,
9901: NULL ,--EFFECTIVE_TO

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

10106: (SELECT DISTINCT
10107: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE
10108: AP_RATES.rule_id AP_RULE_ID,--AP_RULE_ID
10109: AP_RATES.rate_id AP_RATE_ID,--AP_RATE_ID
10110: 'STANDARD-' || AP_RATES.RECOVERY_RATE ALPHANUMERIC_RESULT,--ALPHANUMERIC_RESULT
10111: ptp.party_tax_profile_id CONTENT_OWNER_ID,--CONTENT_OWNER_ID
10112: GROUPS.CONDITION_GROUP_ID CONDITION_GROUP_ID,--CONDITION_GROUP_ID
10113: ZX_RULES.TAX_RULE_ID TAX_RULE_ID, --TAX_RULE_ID
10114: -- Added as a fix for Bug#7412888

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

10174: )
10175: AND not exists (select 1 from zx_process_results
10176: where tax_rule_id = zx_rules.tax_rule_id
10177: and condition_group_code = groups.condition_group_code
10178: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
10179: )
10180:
10181: );
10182:

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

10262: (SELECT DISTINCT
10263: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE
10264: AP_RATES.rule_id AP_RULE_ID,--AP_RULE_ID
10265: AP_RATES.rate_id AP_RATE_ID,--AP_RATE_ID
10266: 'STANDARD-' || AP_RATES.RECOVERY_RATE ALPHANUMERIC_RESULT,--ALPHANUMERIC_RESULT
10267: ptp.party_tax_profile_id CONTENT_OWNER_ID,--CONTENT_OWNER_ID
10268: GROUPS.CONDITION_GROUP_ID CONDITION_GROUP_ID,--CONDITION_GROUP_ID
10269: ZX_RULES.TAX_RULE_ID TAX_RULE_ID, --TAX_RULE_ID
10270: -- Added as a fix for Bug#7412888

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

10331: )
10332: AND not exists (select 1 from zx_process_results
10333: where tax_rule_id = zx_rules.tax_rule_id
10334: and condition_group_code = groups.condition_group_code
10335: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
10336: )
10337: );
10338:
10339: END IF;

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

11017: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11018: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11019: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11020: 'Y',
11021: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11022: NULL),
11023: NULL,
11024: NULL,
11025: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

11021: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11022: NULL),
11023: NULL,
11024: NULL,
11025: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11026: --NULL DEFAULT_REC_TAX ,
11027: --BugFix 3480468
11028: DECODE(codes.tax_recovery_rule_id,
11029: NULL,

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

11028: DECODE(codes.tax_recovery_rule_id,
11029: NULL,
11030: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11031: 'Y',
11032: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11033: NULL),
11034: NULL) DEFAULT_REC_RATE_CODE,
11035: NULL OFFSET_TAX,
11036: NULL OFFSET_STATUS_CODE ,

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

11115: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11116: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11117: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11118: 'Y',
11119: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11120: NULL),
11121: NULL,
11122: NULL,
11123: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

11119: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11120: NULL),
11121: NULL,
11122: NULL,
11123: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11124: --NULL DEFAULT_REC_TAX ,
11125: --BugFix 3480468
11126: DECODE(codes.tax_recovery_rule_id,
11127: NULL,

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

11126: DECODE(codes.tax_recovery_rule_id,
11127: NULL,
11128: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11129: 'Y',
11130: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11131: NULL),
11132: NULL) DEFAULT_REC_RATE_CODE,
11133: offset.tax OFFSET_TAX ,
11134: offset.tax_status_code OFFSET_STATUS_CODE ,

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

11439: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11440: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11441: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11442: 'Y',
11443: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11444: NULL),
11445: NULL,
11446: NULL,
11447: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

11443: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11444: NULL),
11445: NULL,
11446: NULL,
11447: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11448: --NULL DEFAULT_REC_TAX ,
11449: --BugFix 3480468
11450: DECODE(codes.tax_recovery_rule_id,
11451: NULL,

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

11450: DECODE(codes.tax_recovery_rule_id,
11451: NULL,
11452: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11453: 'Y',
11454: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11455: NULL),
11456: NULL) DEFAULT_REC_RATE_CODE,
11457: NULL OFFSET_TAX,
11458: NULL OFFSET_STATUS_CODE ,

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

11538: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11539: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11540: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11541: 'Y',
11542: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11543: NULL),
11544: NULL,
11545: NULL,
11546: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

11542: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11543: NULL),
11544: NULL,
11545: NULL,
11546: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11547: --NULL DEFAULT_REC_TAX ,
11548: --BugFix 3480468
11549: DECODE(codes.tax_recovery_rule_id,
11550: NULL,

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

11549: DECODE(codes.tax_recovery_rule_id,
11550: NULL,
11551: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11552: 'Y',
11553: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11554: NULL),
11555: NULL) DEFAULT_REC_RATE_CODE,
11556: offset.tax OFFSET_TAX ,
11557: offset.tax_status_code OFFSET_STATUS_CODE ,

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

11875: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11876: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11877: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11878: 'Y',
11879: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11880: NULL),
11881: NULL,
11882: NULL,
11883: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

11879: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11880: NULL),
11881: NULL,
11882: NULL,
11883: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11884: --NULL DEFAULT_REC_TAX ,
11885: --BugFix 3480468
11886: DECODE(codes.tax_recovery_rule_id,
11887: NULL,

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

11886: DECODE(codes.tax_recovery_rule_id,
11887: NULL,
11888: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11889: 'Y',
11890: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11891: NULL),
11892: NULL) DEFAULT_REC_RATE_CODE,
11893: NULL OFFSET_TAX,
11894: NULL OFFSET_STATUS_CODE ,

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

11973: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
11974: NULL DEFAULT_FLG_EFFECTIVE_TO ,
11975: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11976: 'Y',
11977: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11978: NULL),
11979: NULL,
11980: NULL,
11981: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

11977: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11978: NULL),
11979: NULL,
11980: NULL,
11981: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
11982: --NULL DEFAULT_REC_TAX ,
11983: --BugFix 3480468
11984: DECODE(codes.tax_recovery_rule_id,
11985: NULL,

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

11984: DECODE(codes.tax_recovery_rule_id,
11985: NULL,
11986: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
11987: 'Y',
11988: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
11989: NULL),
11990: NULL) DEFAULT_REC_RATE_CODE,
11991: offset.tax OFFSET_TAX ,
11992: offset.tax_status_code OFFSET_STATUS_CODE ,

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

12299: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12300: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12301: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12302: 'Y',
12303: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12304: NULL),
12305: NULL,
12306: NULL,
12307: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

12303: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12304: NULL),
12305: NULL,
12306: NULL,
12307: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12308: --NULL DEFAULT_REC_TAX ,
12309: --BugFix 3480468
12310: DECODE(codes.tax_recovery_rule_id,
12311: NULL,

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

12310: DECODE(codes.tax_recovery_rule_id,
12311: NULL,
12312: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12313: 'Y',
12314: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12315: NULL),
12316: NULL) DEFAULT_REC_RATE_CODE,
12317: NULL OFFSET_TAX,
12318: NULL OFFSET_STATUS_CODE ,

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

12398: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12399: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12400: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12401: 'Y',
12402: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12403: NULL),
12404: NULL,
12405: NULL,
12406: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

12402: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12403: NULL),
12404: NULL,
12405: NULL,
12406: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12407: --NULL DEFAULT_REC_TAX ,
12408: --BugFix 3480468
12409: DECODE(codes.tax_recovery_rule_id,
12410: NULL,

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

12409: DECODE(codes.tax_recovery_rule_id,
12410: NULL,
12411: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12412: 'Y',
12413: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12414: NULL),
12415: NULL) DEFAULT_REC_RATE_CODE,
12416: offset.tax OFFSET_TAX ,
12417: offset.tax_status_code OFFSET_STATUS_CODE ,

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

12740: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
12741: NULL DEFAULT_FLG_EFFECTIVE_TO ,
12742: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12743: 'Y',
12744: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12745: NULL),
12746: NULL,
12747: NULL,
12748: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

12744: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12745: NULL),
12746: NULL,
12747: NULL,
12748: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
12749: --NULL DEFAULT_REC_TAX ,
12750: --BugFix 3480468
12751: DECODE(codes.tax_recovery_rule_id,
12752: NULL,

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

12751: DECODE(codes.tax_recovery_rule_id,
12752: NULL,
12753: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12754: 'Y',
12755: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12756: NULL),
12757: NULL) DEFAULT_REC_RATE_CODE,
12758: NULL OFFSET_TAX,
12759: NULL OFFSET_STATUS_CODE ,

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

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

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

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

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

12849: DECODE(codes.tax_recovery_rule_id,
12850: NULL,
12851: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
12852: 'Y',
12853: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
12854: NULL),
12855: NULL) DEFAULT_REC_RATE_CODE,
12856: offset.tax OFFSET_TAX ,
12857: offset.tax_status_code OFFSET_STATUS_CODE ,

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

13163: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13164: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13165: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13166: 'Y',
13167: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13168: NULL),
13169: NULL,
13170: NULL,
13171: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

13167: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13168: NULL),
13169: NULL,
13170: NULL,
13171: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13172: --NULL DEFAULT_REC_TAX ,
13173: --BugFix 3480468
13174: DECODE(codes.tax_recovery_rule_id,
13175: NULL,

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

13174: DECODE(codes.tax_recovery_rule_id,
13175: NULL,
13176: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13177: 'Y',
13178: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13179: NULL),
13180: NULL) DEFAULT_REC_RATE_CODE,
13181: NULL OFFSET_TAX,
13182: NULL OFFSET_STATUS_CODE ,

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

13262: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13263: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13264: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13265: 'Y',
13266: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13267: NULL),
13268: NULL,
13269: NULL,
13270: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

13266: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13267: NULL),
13268: NULL,
13269: NULL,
13270: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13271: --NULL DEFAULT_REC_TAX ,
13272: --BugFix 3480468
13273: DECODE(codes.tax_recovery_rule_id,
13274: NULL,

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

13273: DECODE(codes.tax_recovery_rule_id,
13274: NULL,
13275: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13276: 'Y',
13277: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13278: NULL),
13279: NULL) DEFAULT_REC_RATE_CODE,
13280: offset.tax OFFSET_TAX ,
13281: offset.tax_status_code OFFSET_STATUS_CODE ,

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

13601: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
13602: NULL DEFAULT_FLG_EFFECTIVE_TO ,
13603: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13604: 'Y',
13605: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13606: NULL),
13607: NULL,
13608: NULL,
13609: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

13605: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13606: NULL),
13607: NULL,
13608: NULL,
13609: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
13610: --NULL DEFAULT_REC_TAX ,
13611: --BugFix 3480468
13612: DECODE(codes.tax_recovery_rule_id,
13613: NULL,

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

13612: DECODE(codes.tax_recovery_rule_id,
13613: NULL,
13614: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
13615: 'Y',
13616: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
13617: NULL),
13618: NULL) DEFAULT_REC_RATE_CODE,
13619: NULL OFFSET_TAX,
13620: NULL 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: offset.tax OFFSET_TAX ,
13718: offset.tax_status_code OFFSET_STATUS_CODE ,

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

14025: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
14026: NULL DEFAULT_FLG_EFFECTIVE_TO ,
14027: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
14028: 'Y',
14029: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
14030: NULL),
14031: NULL,
14032: NULL,
14033: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

14029: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
14030: NULL),
14031: NULL,
14032: NULL,
14033: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
14034: --NULL DEFAULT_REC_TAX ,
14035: --BugFix 3480468
14036: DECODE(codes.tax_recovery_rule_id,
14037: NULL,

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

14036: DECODE(codes.tax_recovery_rule_id,
14037: NULL,
14038: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
14039: 'Y',
14040: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
14041: NULL),
14042: NULL) DEFAULT_REC_RATE_CODE,
14043: NULL OFFSET_TAX,
14044: NULL OFFSET_STATUS_CODE ,

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

14124: NULL DEFAULT_FLG_EFFECTIVE_FROM ,
14125: NULL DEFAULT_FLG_EFFECTIVE_TO ,
14126: decode(DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
14127: 'Y',
14128: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
14129: NULL),
14130: NULL,
14131: NULL,
14132: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105

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

14128: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
14129: NULL),
14130: NULL,
14131: NULL,
14132: 'STANDARD') DEFAULT_REC_TYPE_CODE, --Bug 4943105
14133: --NULL DEFAULT_REC_TAX ,
14134: --BugFix 3480468
14135: DECODE(codes.tax_recovery_rule_id,
14136: NULL,

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

14135: DECODE(codes.tax_recovery_rule_id,
14136: NULL,
14137: DECODE(NVL(fsp.non_recoverable_tax_flag, 'N'),
14138: 'Y',
14139: 'STANDARD-'||nvl(codes.tax_recovery_rate,0),
14140: NULL),
14141: NULL) DEFAULT_REC_RATE_CODE,
14142: offset.tax OFFSET_TAX ,
14143: offset.tax_status_code OFFSET_STATUS_CODE ,