APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 921: jai_regime_tax_types_v jrttv

917: FROM
918: JAI_AR_TRX_TAX_LINES jcttl,
919: JAI_AR_TRX_LINES jctl,
920: JAI_CMN_TAXES_ALL jtc ,
921: jai_regime_tax_types_v jrttv
922: WHERE
923: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
924: jctl.customer_trx_id = pr_new.customer_trx_id AND
925: jcttl.tax_id = jtc.tax_id AND

Line 957: jai_regime_tax_types_v

953: IS
954: SELECT
955: regime_id
956: FROM
957: jai_regime_tax_types_v
958: WHERE
959: regime_code = jai_constants.vat_regime
960: AND rownum = 1 ;
961:

Line 1042: jai_regime_tax_types_v jrttv

1038: FROM
1039: JAI_AR_TRX_TAX_LINES jcttl,
1040: JAI_AR_TRX_LINES jctl,
1041: JAI_CMN_TAXES_ALL jtc ,
1042: jai_regime_tax_types_v jrttv
1043: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1044: AND jctl.customer_trx_id = pr_new.customer_trx_id
1045: AND jcttl.tax_id = jtc.tax_id
1046: AND jtc.tax_type = jrttv.tax_type

Line 2230: jai_regime_tax_types_v jrttv

2226: FROM
2227: JAI_AR_TRX_TAX_LINES jcttl,
2228: JAI_AR_TRX_LINES jctl,
2229: JAI_CMN_TAXES_ALL jtc ,
2230: jai_regime_tax_types_v jrttv
2231: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2232: AND jctl.customer_trx_id = pr_new.customer_trx_id
2233: AND jcttl.tax_id = jtc.tax_id
2234: AND jtc.tax_type = jrttv.tax_type

Line 2277: FROM jai_regime_tax_types_v

2273: */
2274: CURSOR c_get_regime_id
2275: IS
2276: SELECT regime_id
2277: FROM jai_regime_tax_types_v
2278: WHERE regime_code = jai_constants.vat_regime
2279: AND rownum = 1 ;
2280:
2281:

Line 2321: FROM jai_regime_tax_types_v jrttv1

2317: JAI_AR_TRX_TAX_LINES jcttl ,
2318: JAI_CMN_TAXES_ALL jtc ,
2319: (
2320: SELECT jrttv1.tax_type tax_type
2321: FROM jai_regime_tax_types_v jrttv1
2322: WHERE jrttv1.regime_code = jai_constants.vat_regime
2323: UNION
2324: SELECT 'VAT REVERSAL' tax_type
2325: FROM DUAL