DBA Data[Home] [Help]

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_SCO_RULES_B_V

Line 709: FROM ZX_SCO_RULES_B_V r

705: DET_FACTOR_TEMPL_CODE,
706: DETERMINING_FACTOR_CQ_CODE,
707: GEOGRAPHY_TYPE,
708: GEOGRAPHY_ID
709: FROM ZX_SCO_RULES_B_V r
710: WHERE SERVICE_TYPE_CODE = c_service_type_code
711: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
712: AND TAX_REGIME_CODE = c_tax_regime_code
713: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 754: FROM ZX_SCO_RULES_B_V r

750: DET_FACTOR_TEMPL_CODE ,
751: DETERMINING_FACTOR_CQ_CODE,
752: GEOGRAPHY_TYPE,
753: GEOGRAPHY_ID
754: FROM ZX_SCO_RULES_B_V r
755: WHERE SERVICE_TYPE_CODE = c_service_type_code
756: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
757: AND TAX_REGIME_CODE = c_tax_regime_code
758: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 802: FROM ZX_SCO_RULES_B_V r

798: DET_FACTOR_TEMPL_CODE,
799: DETERMINING_FACTOR_CQ_CODE,
800: GEOGRAPHY_TYPE,
801: GEOGRAPHY_ID
802: FROM ZX_SCO_RULES_B_V r
803: WHERE SERVICE_TYPE_CODE = c_service_type_code
804: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
805: AND TAX_REGIME_CODE = c_tax_regime_code
806: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1455: FROM ZX_SCO_RULES_B_V r

1451: c_tax_event_class_code ZX_RULES_B.TAX_EVENT_CLASS_CODE%TYPE)
1452: IS
1453: SELECT TAX_RULE_ID,
1454: DET_FACTOR_TEMPL_CODE
1455: FROM ZX_SCO_RULES_B_V r
1456: WHERE SERVICE_TYPE_CODE = c_service_type_code
1457: AND TAX = c_tax
1458: AND TAX_REGIME_CODE = c_tax_regime_code
1459: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1488: FROM ZX_SCO_RULES_B_V

1484: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1485: IS
1486: SELECT TAX_RULE_ID,
1487: det_factor_templ_code
1488: FROM ZX_SCO_RULES_B_V
1489: WHERE SERVICE_TYPE_CODE = c_service_type_code
1490: AND TAX = c_tax
1491: AND TAX_REGIME_CODE = c_tax_regime_code
1492: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1689: FROM ZX_SCO_RULES_B_V r

1685: DET_FACTOR_TEMPL_CODE,
1686: DETERMINING_FACTOR_CQ_CODE,
1687: GEOGRAPHY_TYPE,
1688: GEOGRAPHY_ID
1689: FROM ZX_SCO_RULES_B_V r
1690: WHERE SERVICE_TYPE_CODE = c_service_type_code
1691: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
1692: AND TAX_REGIME_CODE = c_tax_regime_code
1693: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1721: FROM ZX_SCO_RULES_B_V r

1717: DET_FACTOR_TEMPL_CODE,
1718: DETERMINING_FACTOR_CQ_CODE,
1719: GEOGRAPHY_TYPE,
1720: GEOGRAPHY_ID
1721: FROM ZX_SCO_RULES_B_V r
1722: WHERE SERVICE_TYPE_CODE = c_service_type_code
1723: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
1724: AND TAX_REGIME_CODE = c_tax_regime_code
1725: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1755: FROM ZX_SCO_RULES_B_V r

1751: DET_FACTOR_TEMPL_CODE,
1752: DETERMINING_FACTOR_CQ_CODE,
1753: GEOGRAPHY_TYPE,
1754: GEOGRAPHY_ID
1755: FROM ZX_SCO_RULES_B_V r
1756: WHERE SERVICE_TYPE_CODE = c_service_type_code
1757: AND TAX = c_tax
1758: AND TAX_REGIME_CODE = c_tax_regime_code
1759: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 2237: FROM ZX_SCO_RULES_B_V r

2233: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
2234: DETERMINING_FACTOR_CQ_CODE,
2235: GEOGRAPHY_TYPE,
2236: GEOGRAPHY_ID
2237: FROM ZX_SCO_RULES_B_V r
2238: WHERE SERVICE_TYPE_CODE = c_service_type_code
2239: AND TAX IS NULL
2240: AND TAX_REGIME_CODE = c_tax_regime_code
2241: AND c_tax_determine_date >= EFFECTIVE_FROM