DBA Data[Home] [Help]

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_SCO_RULES_B_V

Line 668: FROM ZX_SCO_RULES_B_V r

664: DET_FACTOR_TEMPL_CODE,
665: DETERMINING_FACTOR_CQ_CODE,
666: GEOGRAPHY_TYPE,
667: GEOGRAPHY_ID
668: FROM ZX_SCO_RULES_B_V r
669: WHERE SERVICE_TYPE_CODE = c_service_type_code
670: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
671: AND TAX_REGIME_CODE = c_tax_regime_code
672: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 705: FROM ZX_SCO_RULES_B_V r

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

Line 747: FROM ZX_SCO_RULES_B_V r

743: DET_FACTOR_TEMPL_CODE,
744: DETERMINING_FACTOR_CQ_CODE,
745: GEOGRAPHY_TYPE,
746: GEOGRAPHY_ID
747: FROM ZX_SCO_RULES_B_V r
748: WHERE SERVICE_TYPE_CODE = c_service_type_code
749: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
750: AND TAX_REGIME_CODE = c_tax_regime_code
751: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1213: FROM ZX_SCO_RULES_B_V r

1209: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1210: IS
1211: SELECT TAX_RULE_ID,
1212: DET_FACTOR_TEMPL_CODE
1213: FROM ZX_SCO_RULES_B_V r
1214: WHERE SERVICE_TYPE_CODE = c_service_type_code
1215: AND TAX = c_tax
1216: AND TAX_REGIME_CODE = c_tax_regime_code
1217: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1242: FROM ZX_SCO_RULES_B_V

1238: c_reference_application_id ZX_RULES_B.APPLICATION_ID%TYPE)
1239: IS
1240: SELECT TAX_RULE_ID,
1241: det_factor_templ_code
1242: FROM ZX_SCO_RULES_B_V
1243: WHERE SERVICE_TYPE_CODE = c_service_type_code
1244: AND TAX = c_tax
1245: AND TAX_REGIME_CODE = c_tax_regime_code
1246: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1441: FROM ZX_SCO_RULES_B_V r

1437: DET_FACTOR_TEMPL_CODE,
1438: DETERMINING_FACTOR_CQ_CODE,
1439: GEOGRAPHY_TYPE,
1440: GEOGRAPHY_ID
1441: FROM ZX_SCO_RULES_B_V r
1442: WHERE SERVICE_TYPE_CODE = c_service_type_code
1443: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
1444: AND TAX_REGIME_CODE = c_tax_regime_code
1445: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1471: FROM ZX_SCO_RULES_B_V r

1467: DET_FACTOR_TEMPL_CODE,
1468: DETERMINING_FACTOR_CQ_CODE,
1469: GEOGRAPHY_TYPE,
1470: GEOGRAPHY_ID
1471: FROM ZX_SCO_RULES_B_V r
1472: WHERE SERVICE_TYPE_CODE = c_service_type_code
1473: AND TAX = c_tax -- In phase 1, tax and regime should not be NULL
1474: AND TAX_REGIME_CODE = c_tax_regime_code
1475: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1503: FROM ZX_SCO_RULES_B_V r

1499: DET_FACTOR_TEMPL_CODE,
1500: DETERMINING_FACTOR_CQ_CODE,
1501: GEOGRAPHY_TYPE,
1502: GEOGRAPHY_ID
1503: FROM ZX_SCO_RULES_B_V r
1504: WHERE SERVICE_TYPE_CODE = c_service_type_code
1505: AND TAX = c_tax
1506: AND TAX_REGIME_CODE = c_tax_regime_code
1507: AND c_tax_determine_date >= EFFECTIVE_FROM

Line 1904: FROM ZX_SCO_RULES_B_V r

1900: SELECT TAX_RULE_ID, TAX, TAX_REGIME_CODE, DET_FACTOR_TEMPL_CODE,
1901: DETERMINING_FACTOR_CQ_CODE,
1902: GEOGRAPHY_TYPE,
1903: GEOGRAPHY_ID
1904: FROM ZX_SCO_RULES_B_V r
1905: WHERE SERVICE_TYPE_CODE = c_service_type_code
1906: AND TAX IS NULL
1907: AND TAX_REGIME_CODE = c_tax_regime_code
1908: AND c_tax_determine_date >= EFFECTIVE_FROM