APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 628: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b

624: -- added, Ramananda for bug # 4519719
625: CURSOR c_vat_exists(cp_shipment_line_id NUMBER )
626: IS
627: SELECT 1
628: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
629: WHERE shipment_line_id = cp_shipment_line_id AND
630: b.regime_code= jai_constants.vat_regime
631: and b.tax_type = a.tax_type ;
632:

Line 4120: ( select tax_type from jai_regime_tax_types_v /*modified this to use View as part of OPM changes */

4116: FROM JAI_RCV_LINE_TAXES
4117: WHERE shipment_line_id = cp_shipment_line_id
4118: AND modvat_flag = jai_constants.yes
4119: AND tax_type IN
4120: ( select tax_type from jai_regime_tax_types_v /*modified this to use View as part of OPM changes */
4121: where regime_code = cp_regime_code
4122: );
4123:
4124: CURSOR c_acct_count(cp_parent_transaction_id JAI_RCV_TRANSACTIONS.transaction_id%type,