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 1299: jai_regime_tax_types_v jrttv

1295: FROM
1296: JAI_AR_TRX_TAX_LINES jcttl,
1297: JAI_AR_TRX_LINES jctl,
1298: JAI_CMN_TAXES_ALL jtc ,
1299: jai_regime_tax_types_v jrttv
1300: WHERE
1301: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1302: jctl.customer_trx_id = pr_new.customer_trx_id AND
1303: jcttl.tax_id = jtc.tax_id AND

Line 1335: jai_regime_tax_types_v

1331: IS
1332: SELECT
1333: regime_id
1334: FROM
1335: jai_regime_tax_types_v
1336: WHERE
1337: regime_code = jai_constants.vat_regime
1338: AND rownum = 1 ;
1339:

Line 2536: jai_regime_tax_types_v

2532: IS
2533: SELECT
2534: regime_id
2535: FROM
2536: jai_regime_tax_types_v
2537: WHERE
2538: regime_code = jai_constants.vat_regime
2539: AND rownum = 1 ;
2540:

Line 2883: ,JAI_REGIME_TAX_TYPES_V JRTTV

2879: IS
2880: SELECT COUNT(1)
2881: FROM JAI_CMN_TAX_CTG_LINES CATL
2882: ,JAI_CMN_TAXES_ALL CODES
2883: ,JAI_REGIME_TAX_TYPES_V JRTTV
2884: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
2885: AND CATL.TAX_ID = CODES.TAX_ID
2886: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
2887: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;