APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 169: jai_regime_tax_types_v tax_types

165: IS
166: SELECT 1
167: FROM JAI_OM_OE_SO_TAXES jstl ,
168: JAI_CMN_TAXES_ALL jtc ,
169: jai_regime_tax_types_v tax_types
170: WHERE jstl.line_id = cp_line_id
171: AND jstl.header_id = cp_header_id
172: AND jtc.tax_id = jstl.tax_id
173: AND jtc.tax_type = tax_types.tax_type

Line 1206: FROM jai_regime_tax_types_v

1202: WHERE delivery_detail_id = p_delivery_detail_id;
1203:
1204: CURSOR c_check_vat_type_tax_exists(cp_tax_type VARCHAR2) IS
1205: SELECT 1
1206: FROM jai_regime_tax_types_v
1207: WHERE regime_code = jai_constants.vat_regime
1208: AND tax_type = cp_tax_type;
1209:
1210: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,

Line 1962: FROM jai_regime_tax_types_v

1958: WHERE delivery_detail_id = p_delivery_detail_id;
1959:
1960: CURSOR c_check_vat_type_tax_exists(cp_tax_type VARCHAR2) IS
1961: SELECT 1
1962: FROM jai_regime_tax_types_v
1963: WHERE regime_code = jai_constants.vat_regime
1964: AND tax_type = cp_tax_type;
1965:
1966: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,