APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 487: from jai_regime_tax_types_v

483: FROM JAI_RCV_LINE_TAXES a,
484: JAI_CMN_TAXES_ALL b
485: WHERE a.transaction_id = cp_transaction_id
486: AND a.tax_type IN ( select tax_type
487: from jai_regime_tax_types_v
488: where regime_code = jai_constants.vat_regime
489: )
490: AND a.tax_id = b.tax_id
491: AND a.modvat_flag = 'Y'

Line 763: from jai_regime_tax_types_v

759: WHERE shipment_line_id = cp_shipment_line_id
760: AND jtc.tax_id = rtl.tax_id
761: AND rtl.modvat_flag = 'Y'
762: AND jtc.tax_type IN (select tax_type
763: from jai_regime_tax_types_v
764: where regime_code = jai_constants.vat_regime);
765:
766: CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
767: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

Line 809: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b

805:
806: CURSOR c_vat_exists(cp_shipment_line_id NUMBER )
807: IS
808: SELECT 1
809: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
810: WHERE shipment_line_id = cp_shipment_line_id AND
811: b.regime_code= jai_constants.vat_regime
812: and b.tax_type = a.tax_type ;
813:

Line 1213: from jai_regime_tax_types_v

1209: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1210: FROM JAI_RCV_LINE_TAXES
1211: WHERE transaction_id = cp_transaction_id
1212: AND tax_type in (select tax_type
1213: from jai_regime_tax_types_v
1214: where regime_code = jai_constants.vat_regime)
1215: AND NVL(modvat_flag,'N') = 'Y';*/
1216:
1217: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,

Line 2402: from jai_regime_tax_types_v

2398: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2399: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2400: WHERE jtl.transaction_id = cp_transaction_id
2401: AND jtl.tax_type in (select tax_type
2402: from jai_regime_tax_types_v
2403: where regime_code = jai_constants.vat_regime)
2404: AND NVL(jtl.modvat_flag,'N') = 'Y'
2405: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2406: GROUP BY jtl.tax_type;

Line 2416: from jai_regime_tax_types_v

2412: FROM JAI_RCV_LINE_TAXES a,
2413: JAI_CMN_TAXES_ALL b
2414: WHERE a.transaction_id = cp_transaction_id
2415: AND a.tax_type in (select tax_type
2416: from jai_regime_tax_types_v
2417: where regime_code = jai_constants.vat_regime)
2418: AND a.tax_id = b.tax_id
2419: AND NVL(a.modvat_flag,'N') = 'Y';
2420:

Line 2821: FROM jai_regime_tax_types_v

2817: AND jrtl.transaction_id = r_receive_transaction.transaction_id
2818: AND jrtl.shipment_line_id = r_shipment_lines.shipment_line_id
2819: AND jrtl.modvat_flag = 'Y'
2820: AND jrtl.tax_type IN (SELECT tax_type
2821: FROM jai_regime_tax_types_v
2822: WHERE regime_code = jai_constants.vat_regime))
2823: AND LINE_TYPE_LOOKUP_CODE = 'MISCELLANEOUS' ; /*Added line_type_lookup_code condition for bug # 11659328 */
2824:
2825: END IF; /*Bug 11880460 modified the above select statement in sync with the code in 12.1 by abezgam*/

Line 2837: from jai_regime_tax_types_v

2833: last_update_login = fnd_global.login_id
2834: WHERE shipment_header_id = r_shipment_lines.shipment_header_id
2835: AND shipment_line_id = r_shipment_lines.shipment_line_id
2836: AND tax_type IN (select tax_type
2837: from jai_regime_tax_types_v
2838: where regime_code = jai_constants.vat_regime)
2839: AND modvat_flag = 'Y';
2840:
2841: --To update the Status, so that It should not be considered for claiming

Line 3527: from jai_regime_tax_types_v

3523: FROM JAI_RCV_LINE_TAXES a,
3524: JAI_CMN_TAXES_ALL b
3525: WHERE a.transaction_id = cp_transaction_id
3526: AND a.tax_type in (select tax_type
3527: from jai_regime_tax_types_v
3528: where regime_code = jai_constants.vat_regime)
3529: AND NVL(a.modvat_flag,'N') = 'Y'
3530: AND a.tax_id = b.tax_id
3531: GROUP BY a.tax_type;