APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 420: from jai_regime_tax_types_v

416: FROM JAI_RCV_LINE_TAXES a,
417: JAI_CMN_TAXES_ALL b
418: WHERE a.transaction_id = cp_transaction_id
419: AND a.tax_type IN ( select tax_type
420: from jai_regime_tax_types_v
421: where regime_code = jai_constants.vat_regime
422: )
423: AND a.tax_id = b.tax_id
424: AND a.modvat_flag = 'Y'

Line 693: from jai_regime_tax_types_v

689: WHERE shipment_line_id = cp_shipment_line_id
690: AND jtc.tax_id = rtl.tax_id
691: AND rtl.modvat_flag = 'Y'
692: AND jtc.tax_type IN (select tax_type
693: from jai_regime_tax_types_v
694: where regime_code = jai_constants.vat_regime);
695:
696: CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
697: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

Line 739: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b

735:
736: CURSOR c_vat_exists(cp_shipment_line_id NUMBER )
737: IS
738: SELECT 1
739: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
740: WHERE shipment_line_id = cp_shipment_line_id AND
741: b.regime_code= jai_constants.vat_regime
742: and b.tax_type = a.tax_type ;
743:

Line 1142: from jai_regime_tax_types_v

1138: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1139: FROM JAI_RCV_LINE_TAXES
1140: WHERE transaction_id = cp_transaction_id
1141: AND tax_type in (select tax_type
1142: from jai_regime_tax_types_v
1143: where regime_code = jai_constants.vat_regime)
1144: AND NVL(modvat_flag,'N') = 'Y';*/
1145:
1146: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

Line 2322: from jai_regime_tax_types_v

2318: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2319: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2320: WHERE jtl.transaction_id = cp_transaction_id
2321: AND jtl.tax_type in (select tax_type
2322: from jai_regime_tax_types_v
2323: where regime_code = jai_constants.vat_regime)
2324: AND NVL(jtl.modvat_flag,'N') = 'Y'
2325: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2326: GROUP BY jtl.tax_type;

Line 2336: from jai_regime_tax_types_v

2332: FROM JAI_RCV_LINE_TAXES a,
2333: JAI_CMN_TAXES_ALL b
2334: WHERE a.transaction_id = cp_transaction_id
2335: AND a.tax_type in (select tax_type
2336: from jai_regime_tax_types_v
2337: where regime_code = jai_constants.vat_regime)
2338: AND a.tax_id = b.tax_id
2339: AND NVL(a.modvat_flag,'N') = 'Y';
2340:

Line 2647: from jai_regime_tax_types_v

2643: last_update_login = fnd_global.login_id
2644: WHERE shipment_header_id = r_shipment_lines.shipment_header_id
2645: AND shipment_line_id = r_shipment_lines.shipment_line_id
2646: AND tax_type IN (select tax_type
2647: from jai_regime_tax_types_v
2648: where regime_code = jai_constants.vat_regime)
2649: AND modvat_flag = 'Y';
2650:
2651: --To update the Status, so that It should not be considered for claiming

Line 3280: from jai_regime_tax_types_v

3276: FROM JAI_RCV_LINE_TAXES a,
3277: JAI_CMN_TAXES_ALL b
3278: WHERE a.transaction_id = cp_transaction_id
3279: AND a.tax_type in (select tax_type
3280: from jai_regime_tax_types_v
3281: where regime_code = jai_constants.vat_regime)
3282: AND NVL(a.modvat_flag,'N') = 'Y'
3283: AND a.tax_id = b.tax_id
3284: GROUP BY a.tax_type;