APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_RATES_B_TMP

Line 1826: UPDATE zx_rates_b_tmp

1822: END LOOP;
1823:
1824: -- Start : Added for Bug#7298430
1825: FORALL i IN INDICES OF l_rates_rec.tax_rate_id
1826: UPDATE zx_rates_b_tmp
1827: SET effective_from = l_rates_rec.effective_from(i),
1828: effective_to = l_rates_rec.effective_to(i),
1829: default_flg_effective_from = l_rates_rec.effective_from(i),
1830: default_flg_effective_to = l_rates_rec.effective_to(i)

Line 4699: MERGE INTO ZX_RATES_B_TMP zrbt

4695:
4696:
4697: WHILE (l_any_rows_to_process)
4698: LOOP**/
4699: MERGE INTO ZX_RATES_B_TMP zrbt
4700: USING (SELECT tax_regime_code,
4701: tax,
4702: content_owner_id,
4703: tax_status_code,

Line 4874: MERGE INTO ZX_RATES_B_TMP zrbt

4870: -- added this to ensure that when we have two rate records with same effectivity, then
4871: -- active_flag is not updated as it needs to be included in the ON clause
4872: -- also need to update percentage_rate for this case.
4873:
4874: MERGE INTO ZX_RATES_B_TMP zrbt
4875: USING (SELECT tax_regime_code,
4876: tax,
4877: content_owner_id,
4878: tax_status_code,

Line 5048: INSERT ALL INTO ZX_RATES_B_TMP

5044: l_rows_processed := SQL%ROWCOUNT;
5045:
5046: -- Create rates with NULL Jurisdiction codes
5047: -- Used for Partner tax calculation.
5048: INSERT ALL INTO ZX_RATES_B_TMP
5049: (
5050: TAX_RATE_ID,
5051: OBJECT_VERSION_NUMBER,
5052: TAX_RATE_CODE,