APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1021: JAI_REGIME_TAX_TYPES_V JRTTV

1017: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
1018: SELECT COUNT(1)
1019: FROM JAI_CMN_TAX_CTG_LINES CATL,
1020: JAI_CMN_TAXES_ALL CODES,
1021: JAI_REGIME_TAX_TYPES_V JRTTV
1022: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
1023: AND CATL.TAX_ID = CODES.TAX_ID
1024: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
1025: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;

Line 1596: jai_regime_tax_types_v jrttv

1592: SELECT regime_id, regime_code
1593: FROM JAI_AR_TRX_TAX_LINES jcttl,
1594: JAI_AR_TRX_LINES jctl,
1595: JAI_CMN_TAXES_ALL jtc,
1596: jai_regime_tax_types_v jrttv
1597: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1598: AND jctl.customer_trx_id = pr_new.customer_trx_id
1599: AND jcttl.tax_id = jtc.tax_id
1600: AND jtc.tax_type = jrttv.tax_type

Line 1632: FROM jai_regime_tax_types_v

1628: ln_vat_reversal_exists NUMBER;
1629:
1630: CURSOR c_get_regime_id IS
1631: SELECT regime_id
1632: FROM jai_regime_tax_types_v
1633: WHERE regime_code = jai_constants.vat_regime
1634: AND rownum = 1;
1635: cursor c_get_rec(cn_customer_trx_id number) is
1636: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;

Line 2133: jai_regime_tax_types_v jrttv

2129: SELECT regime_id, regime_code
2130: FROM JAI_AR_TRX_TAX_LINES jcttl,
2131: JAI_AR_TRX_LINES jctl,
2132: JAI_CMN_TAXES_ALL jtc,
2133: jai_regime_tax_types_v jrttv
2134: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2135: AND jctl.customer_trx_id = pr_new.customer_trx_id
2136: AND jcttl.tax_id = jtc.tax_id
2137: AND jtc.tax_type = jrttv.tax_type

Line 2154: FROM jai_regime_tax_types_v

2150: AND jtc.tax_type = cp_tax_type;
2151:
2152: CURSOR c_get_regime_id IS
2153: SELECT regime_id
2154: FROM jai_regime_tax_types_v
2155: WHERE regime_code = jai_constants.vat_regime
2156: AND rownum = 1;
2157:
2158: ln_vat_reversal_exists NUMBER;