APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_RATES_B_TMP

Line 117: update zx_rates_b_tmp rates

113:
114: /* Bug 4710118 : To Ensure that atleast one rate code gets created with default_rate_flag = 'Y' for a particular
115: Combination of regime , tax , status and Content Owner */
116:
117: update zx_rates_b_tmp rates
118: set rates.default_rate_flag = 'Y' ,
119: rates.default_flg_effective_from = rates.effective_from, --Bug 5104891
120: rates.default_flg_effective_to = rates.effective_to -- Bug 6680676
121: where rates.tax_rate_code in ( select rates1.tax_rate_code from zx_rates_b rates1

Line 2795: INTO zx_rates_b_tmp

2791: -- zx_rates_tl is created by procedure populate_mls_tables
2792: IF L_MULTI_ORG_FLAG = 'Y'
2793: THEN
2794: INSERT ALL
2795: INTO zx_rates_b_tmp
2796: (
2797: TAX_RATE_ID ,
2798: TAX_RATE_CODE ,
2799: CONTENT_OWNER_ID ,

Line 3130: INTO zx_rates_b_tmp

3126: AND rates.tax_rate_code = codes.tax_code
3127: );
3128: ELSE
3129: INSERT ALL
3130: INTO zx_rates_b_tmp
3131: (
3132: TAX_RATE_ID ,
3133: TAX_RATE_CODE ,
3134: CONTENT_OWNER_ID ,

Line 4094: INTO zx_rates_b_tmp

4090: THEN
4091:
4092:
4093: INSERT ALL
4094: INTO zx_rates_b_tmp
4095: (
4096: TAX_RATE_ID ,
4097: TAX_RATE_CODE ,
4098: CONTENT_OWNER_ID ,

Line 4426: INTO zx_rates_b_tmp

4422: ELSE
4423:
4424:
4425: INSERT ALL
4426: INTO zx_rates_b_tmp
4427: (
4428: TAX_RATE_ID ,
4429: TAX_RATE_CODE ,
4430: CONTENT_OWNER_ID ,

Line 4926: INTO zx_rates_b_tmp

4922: IF L_MULTI_ORG_FLAG = 'Y'
4923: THEN
4924:
4925: INSERT ALL
4926: INTO zx_rates_b_tmp
4927: (
4928: TAX_RATE_ID ,
4929: TAX_RATE_CODE ,
4930: CONTENT_OWNER_ID ,

Line 5281: INTO zx_rates_b_tmp

5277: );
5278: ELSE
5279:
5280: INSERT ALL
5281: INTO zx_rates_b_tmp
5282: (
5283: TAX_RATE_ID ,
5284: TAX_RATE_CODE ,
5285: CONTENT_OWNER_ID ,

Line 5643: INTO zx_rates_b_tmp

5639:
5640: /* Bug 4708982
5641: IF L_LTE_USED = 'Y' THEN
5642: INSERT ALL
5643: INTO zx_rates_b_tmp
5644: (
5645: TAX_RATE_ID ,
5646: TAX_RATE_CODE ,
5647: CONTENT_OWNER_ID ,

Line 9984: INTO zx_rates_b_tmp

9980: AND active_flag = p_active_flag
9981: AND TRUNC(effective_from) = p_effective_from
9982: )
9983: ) THEN
9984: INTO zx_rates_b_tmp
9985: (
9986: TAX_RATE_ID ,
9987: TAX_RATE_CODE ,
9988: CONTENT_OWNER_ID ,