APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_SCO_RATES_B_V

Line 2455: FROM ZX_SCO_RATES_B_V rt

2451: AND ( p_tax_determine_date >= effective_from AND
2452: (p_tax_determine_date <= effective_to OR effective_to IS NULL))
2453: AND zxt.offset_tax_flag = 'N'
2454: AND EXISTS (SELECT /*+ no_unnest */ 1
2455: FROM ZX_SCO_RATES_B_V rt
2456: WHERE rt.tax_regime_code = p_tax_regime_code
2457: AND rt.tax = zxt.tax
2458: AND (rt.tax_class = c_tax_class OR rt.tax_class IS NULL)
2459: AND rownum = 1)

Line 2540: FROM ZX_SCO_RATES_B_V

2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2538: c_tax_class zx_rates_b.tax_class%TYPE) IS
2539: SELECT 1
2540: FROM ZX_SCO_RATES_B_V
2541: WHERE effective_from <= p_tax_determine_date
2542: AND (effective_to >= p_tax_determine_date OR effective_to IS NULL )
2543: AND tax_rate_code = c_tax_rate_code
2544: AND tax_status_code = c_tax_status_code

Line 7623: FROM zx_sco_rates_b_v

7619: SELECT tax_regime_code,
7620: tax,
7621: tax_status_code,
7622: tax_jurisdiction_code
7623: FROM zx_sco_rates_b_v
7624: WHERE tax_rate_code = c_tax_rate_code
7625: AND effective_from <= p_tax_determine_date
7626: AND (effective_to >= p_tax_determine_date OR effective_to IS NULL)
7627: AND tax_class = 'INPUT'

Line 7637: FROM zx_sco_rates_b_v

7633: SELECT tax_regime_code,
7634: tax,
7635: tax_status_code,
7636: tax_jurisdiction_code
7637: FROM zx_sco_rates_b_v
7638: WHERE tax_rate_code = c_tax_rate_code
7639: AND effective_from <= p_tax_determine_date
7640: AND (effective_to >= p_tax_determine_date OR effective_to IS NULL)
7641: AND tax_class IS NULL

Line 7651: FROM zx_sco_rates_b_v

7647: SELECT tax_regime_code,
7648: tax,
7649: tax_status_code,
7650: tax_jurisdiction_code
7651: FROM zx_sco_rates_b_v
7652: WHERE tax_rate_code = c_tax_rate_code
7653: AND effective_from <= p_tax_determine_date
7654: AND (effective_to >= p_tax_determine_date OR effective_to IS NULL)
7655: AND active_flag = 'Y'

Line 8618: --ZX_SCO_RATES_B_V rt

8614: tax.compounding_precedence
8615: FROM ZX_PROCESS_RESULTS pr,
8616: ZX_SCO_RULES_B_V rl,
8617: ZX_SCO_TAXES_B_V tax
8618: --ZX_SCO_RATES_B_V rt
8619: WHERE (pr.CONDITION_GROUP_CODE in (c_condition_group_code
8620: , decode(c_tax_class,'OUTPUT',substrb(c_tax_rate_code,1,45)||'-'||'XOP'
8621: ,'INPUT' ,substrb(c_tax_rate_code,1,45)||'-'||'XIP'
8622: ,c_condition_group_code

Line 8639: FROM ZX_SCO_RATES_B_V rt

8635: AND tax.live_for_processing_flag = 'Y'
8636: AND tax.live_for_applicability_flag = 'Y'
8637: AND EXISTS
8638: (SELECT /*+ no_unnest */ 1
8639: FROM ZX_SCO_RATES_B_V rt
8640: WHERE rt.tax_regime_code = rl.tax_regime_code -- bug 6680676
8641: AND rt.tax = rl.tax
8642: AND rt.tax_status_code = pr.status_result
8643: AND rt.tax_rate_code = pr.rate_result

Line 8659: FROM ZX_SCO_RATES_B_V rt,

8655: NULL exception_set_id,
8656: NULL result_id,
8657: 2 query_num,
8658: tax.compounding_precedence
8659: FROM ZX_SCO_RATES_B_V rt,
8660: ZX_SCO_TAXES_B_V tax
8661: WHERE rt.tax_rate_code = c_tax_rate_code
8662: AND rt.rate_type_code <> 'RECOVERY'
8663: AND rt.effective_from <= c_tax_determine_date

Line 8691: FROM ZX_SCO_RATES_B_V

8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8688: c_tax_class zx_rates_b.tax_class%TYPE,
8689: c_tax_determine_date DATE) IS
8690: SELECT 1
8691: FROM ZX_SCO_RATES_B_V
8692: WHERE tax_regime_code = c_tax_regime_code
8693: AND tax = c_tax
8694: AND tax_status_code = c_tax_status_code
8695: AND tax_rate_code = c_tax_rate_code

Line 9108: FROM ZX_SCO_RATES_B_V rt

9104: 2
9105: INTO l_status_result_tbl(j),
9106: l_rate_result_tbl(j),
9107: l_query_num_tbl(j)
9108: FROM ZX_SCO_RATES_B_V rt
9109: WHERE rt.tax_rate_code = l_action_rec_tbl(i).action_value
9110: AND tax_regime_code = l_tax_regime_code_tbl(j)
9111: AND tax = l_tax_tbl(j)
9112: AND rt.effective_from <= p_tax_determine_date