APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 813: , jai_regime_tax_types_v tax_types

809: IS
810: SELECT 1
811: FROM JAI_OM_WSH_LINE_TAXES jsptl,
812: JAI_CMN_TAXES_ALL jtc
813: , jai_regime_tax_types_v tax_types
814: WHERE jsptl.delivery_detail_id = cp_del_det_id
815: AND jtc.tax_id = jsptl.tax_id
816: AND jtc.tax_type = tax_types.tax_type
817: AND tax_types.regime_code = jai_constants.vat_regime;

Line 873: FROM JAI_REGIME_TAX_TYPES_V JRTTV

869: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
870: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
871: IS
872: SELECT COUNT(1)
873: FROM JAI_REGIME_TAX_TYPES_V JRTTV
874: , JAI_OM_WSH_LINE_TAXES JSPT
875: , JAI_CMN_TAXES_ALL JTC
876: WHERE JTC.TAX_ID = JSPT.TAX_ID
877: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE

Line 3033: FROM JAI_REGIME_TAX_TYPES_V JRTTV

3029: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
3030: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
3031: IS
3032: SELECT COUNT(1)
3033: FROM JAI_REGIME_TAX_TYPES_V JRTTV
3034: , JAI_OM_WSH_LINE_TAXES JSPT
3035: , JAI_CMN_TAXES_ALL JTC
3036: WHERE JTC.TAX_ID = JSPT.TAX_ID
3037: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE

Line 3188: jai_regime_tax_types_v jrttv

3184: FROM
3185: JAI_OM_WSH_LINES_ALL jspl ,
3186: JAI_OM_WSH_LINE_TAXES jsptl,
3187: JAI_CMN_TAXES_ALL jtc ,
3188: jai_regime_tax_types_v jrttv
3189: WHERE
3190: jspl.delivery_detail_id = jsptl.delivery_detail_id
3191: AND jspl.delivery_id = v_delivery_id
3192: AND jspl.delivery_detail_id = v_delivery_detail_id