DBA Data[Home] [Help]

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1252: jai_regime_tax_types_v

1248: IS
1249: SELECT
1250: 1
1251: FROM
1252: jai_regime_tax_types_v
1253: WHERE
1254: regime_code = jai_constants.vat_regime
1255: AND tax_type = cp_tax_type;
1256:

Line 2169: jai_regime_tax_types_v

2165: IS
2166: SELECT
2167: 1
2168: FROM
2169: jai_regime_tax_types_v
2170: WHERE
2171: regime_code = jai_constants.vat_regime
2172: AND tax_type = cp_tax_type;
2173:

Line 4367: , jai_regime_tax_types_v tax_types

4363: IS
4364: SELECT 1
4365: FROM JAI_OM_WSH_LINE_TAXES jsptl
4366: , JAI_CMN_TAXES_ALL jtc
4367: , jai_regime_tax_types_v tax_types
4368: WHERE jsptl.order_line_id = cp_order_line_id
4369: AND jtc.tax_id = jsptl.tax_id
4370: AND jtc.tax_type = tax_types.tax_type
4371: AND tax_types.regime_code = jai_constants.vat_regime;

Line 4417: , jai_regime_tax_types_v tax_types

4413: IS
4414: SELECT 1
4415: FROM JAI_OM_WSH_LINE_TAXES jsptl
4416: , JAI_CMN_TAXES_ALL jtc
4417: , jai_regime_tax_types_v tax_types
4418: WHERE jsptl.order_line_id = cp_order_line_id
4419: AND jtc.tax_id = jsptl.tax_id
4420: AND jtc.tax_type = tax_types.tax_type
4421: AND tax_types.regime_code = cp_regime_code;*/