DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 444: jai_regime_tax_types_v tax_types

440: IS
441: SELECT 1
442: FROM JAI_OM_OE_SO_TAXES jstl ,
443: JAI_CMN_TAXES_ALL jtc ,
444: jai_regime_tax_types_v tax_types
445: WHERE jstl.line_id = cp_line_id
446: AND jstl.header_id = cp_header_id
447: AND jtc.tax_id = jstl.tax_id
448: AND jtc.tax_type = tax_types.tax_type

Line 1776: , jai_regime_tax_types_v tax_types

1772: IS
1773: SELECT 1
1774: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1775: JAI_CMN_TAXES_ALL jtc
1776: , jai_regime_tax_types_v tax_types
1777: WHERE jsptl.delivery_detail_id = cp_del_det_id
1778: AND jtc.tax_id = jsptl.tax_id
1779: AND jtc.tax_type = tax_types.tax_type
1780: AND tax_types.regime_code = jai_constants.vat_regime;

Line 1847: FROM JAI_REGIME_TAX_TYPES_V JRTTV

1843: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE
1844: )
1845: IS
1846: SELECT COUNT(1)
1847: FROM JAI_REGIME_TAX_TYPES_V JRTTV
1848: , JAI_OM_WSH_LINE_TAXES JSPT
1849: , JAI_CMN_TAXES_ALL JTC
1850: WHERE JTC.TAX_ID = JSPT.TAX_ID
1851: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE