APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 689: jai_regime_tax_types_v jrttv

685: FROM
686: JAI_AR_TRX_TAX_LINES jcttl,
687: JAI_AR_TRX_LINES jctl,
688: JAI_CMN_TAXES_ALL jtc ,
689: jai_regime_tax_types_v jrttv
690: WHERE
691: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
692: jctl.customer_trx_id = pr_new.customer_trx_id AND
693: jcttl.tax_id = jtc.tax_id AND

Line 749: jai_regime_tax_types_v

745: IS
746: SELECT
747: regime_id
748: FROM
749: jai_regime_tax_types_v
750: WHERE
751: regime_code = jai_constants.vat_regime
752: AND rownum = 1 ;
753: /******************************************************************************************************************

Line 1328: jai_regime_tax_types_v jrttv

1324: FROM
1325: JAI_AR_TRX_TAX_LINES jcttl,
1326: JAI_AR_TRX_LINES jctl,
1327: JAI_CMN_TAXES_ALL jtc ,
1328: jai_regime_tax_types_v jrttv
1329: WHERE
1330: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1331: jctl.customer_trx_id = pr_new.customer_trx_id AND
1332: jcttl.tax_id = jtc.tax_id AND

Line 1364: jai_regime_tax_types_v

1360: IS
1361: SELECT
1362: regime_id
1363: FROM
1364: jai_regime_tax_types_v
1365: WHERE
1366: regime_code = jai_constants.vat_regime
1367: AND rownum = 1 ;
1368:

Line 1457: jai_regime_tax_types_v jrttv

1453: FROM
1454: JAI_AR_TRX_TAX_LINES jcttl,
1455: JAI_AR_TRX_LINES jctl,
1456: JAI_CMN_TAXES_ALL jtc ,
1457: jai_regime_tax_types_v jrttv
1458: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1459: AND jctl.customer_trx_id = pr_new.customer_trx_id
1460: AND jcttl.tax_id = jtc.tax_id
1461: AND jtc.tax_type = jrttv.tax_type

Line 1526: jai_regime_tax_types_v jrttv

1522: FROM
1523: JAI_AR_TRX_TAX_LINES jcttl,
1524: JAI_AR_TRX_LINES jctl,
1525: JAI_CMN_TAXES_ALL jtc ,
1526: jai_regime_tax_types_v jrttv
1527: WHERE
1528: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1529: jctl.customer_trx_id = pr_new.customer_trx_id AND
1530: jcttl.tax_id = jtc.tax_id AND

Line 2901: FROM jai_regime_tax_types_v jrttv

2897: /*Bug 8625057 - Start*/
2898: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
2899: IS
2900: SELECT regime_id, regime_code
2901: FROM jai_regime_tax_types_v jrttv
2902: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
2903:
2904: ln_regime_code VARCHAR2(30);
2905: ln_regime_id NUMBER;

Line 2966: jai_regime_tax_types_v

2962: IS
2963: SELECT
2964: regime_id
2965: FROM
2966: jai_regime_tax_types_v
2967: WHERE
2968: regime_code = jai_constants.vat_regime
2969: AND rownum = 1 ;
2970:

Line 3412: ,JAI_REGIME_TAX_TYPES_V JRTTV

3408: IS
3409: SELECT COUNT(1)
3410: FROM JAI_CMN_TAX_CTG_LINES CATL
3411: ,JAI_CMN_TAXES_ALL CODES
3412: ,JAI_REGIME_TAX_TYPES_V JRTTV
3413: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
3414: AND CATL.TAX_ID = CODES.TAX_ID
3415: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
3416: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;

Line 4079: jai_regime_tax_types_v jrttv

4075: FROM
4076: JAI_AR_TRX_TAX_LINES jcttl,
4077: JAI_AR_TRX_LINES jctl,
4078: JAI_CMN_TAXES_ALL jtc ,
4079: jai_regime_tax_types_v jrttv
4080: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
4081: AND jctl.customer_trx_id = pr_new.customer_trx_id
4082: AND jcttl.tax_id = jtc.tax_id
4083: AND jtc.tax_type = jrttv.tax_type

Line 4126: FROM jai_regime_tax_types_v

4122: */
4123: CURSOR c_get_regime_id
4124: IS
4125: SELECT regime_id
4126: FROM jai_regime_tax_types_v
4127: WHERE regime_code = jai_constants.vat_regime
4128: AND rownum = 1 ;
4129:
4130: --Added by Bo Li for Bug9759668 on 2010-6-2 Begin

Line 4175: FROM jai_regime_tax_types_v jrttv1

4171: JAI_AR_TRX_TAX_LINES jcttl ,
4172: JAI_CMN_TAXES_ALL jtc ,
4173: (
4174: SELECT jrttv1.tax_type tax_type
4175: FROM jai_regime_tax_types_v jrttv1
4176: WHERE jrttv1.regime_code = jai_constants.vat_regime
4177: UNION
4178: SELECT 'VAT REVERSAL' tax_type
4179: FROM DUAL