[Home] [Help]
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
2703: -- zx_rates_tl is created by procedure populate_mls_tables
2704: IF L_MULTI_ORG_FLAG = 'Y'
2705: THEN
2706: INSERT ALL
2707: INTO zx_rates_b_tmp
2708: (
2709: TAX_RATE_ID ,
2710: TAX_RATE_CODE ,
2711: CONTENT_OWNER_ID ,
3038: AND rates.tax_rate_code = codes.tax_code
3039: );
3040: ELSE
3041: INSERT ALL
3042: INTO zx_rates_b_tmp
3043: (
3044: TAX_RATE_ID ,
3045: TAX_RATE_CODE ,
3046: CONTENT_OWNER_ID ,
4113: THEN
4114:
4115:
4116: INSERT ALL
4117: INTO zx_rates_b_tmp
4118: (
4119: TAX_RATE_ID ,
4120: TAX_RATE_CODE ,
4121: CONTENT_OWNER_ID ,
4445: ELSE
4446:
4447:
4448: INSERT ALL
4449: INTO zx_rates_b_tmp
4450: (
4451: TAX_RATE_ID ,
4452: TAX_RATE_CODE ,
4453: CONTENT_OWNER_ID ,
4926: IF L_MULTI_ORG_FLAG = 'Y'
4927: THEN
4928:
4929: INSERT ALL
4930: INTO zx_rates_b_tmp
4931: (
4932: TAX_RATE_ID ,
4933: TAX_RATE_CODE ,
4934: CONTENT_OWNER_ID ,
5273: );
5274: ELSE
5275:
5276: INSERT ALL
5277: INTO zx_rates_b_tmp
5278: (
5279: TAX_RATE_ID ,
5280: TAX_RATE_CODE ,
5281: CONTENT_OWNER_ID ,
5627:
5628: /* Bug 4708982
5629: IF L_LTE_USED = 'Y' THEN
5630: INSERT ALL
5631: INTO zx_rates_b_tmp
5632: (
5633: TAX_RATE_ID ,
5634: TAX_RATE_CODE ,
5635: CONTENT_OWNER_ID ,
9927: AND active_flag = p_active_flag
9928: AND TRUNC(effective_from) = p_effective_from
9929: )
9930: ) THEN
9931: INTO zx_rates_b_tmp
9932: (
9933: TAX_RATE_ID ,
9934: TAX_RATE_CODE ,
9935: CONTENT_OWNER_ID ,