DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 2076: from jai_regime_tax_types_v jrttv

2072: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
2073: )
2074: is
2075: select count(1)
2076: from jai_regime_tax_types_v jrttv
2077: , JAI_AR_TRX_TAX_LINES jrctt
2078: , JAI_CMN_TAXES_ALL jtc
2079: where jtc.tax_id = jrctt.tax_id
2080: and jtc.tax_type = jrttv.tax_type

Line 4807: from jai_regime_tax_types_v jrttv

4803: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
4804: )
4805: is
4806: select count(1)
4807: from jai_regime_tax_types_v jrttv
4808: , JAI_AR_TRX_TAX_LINES jrctt
4809: , JAI_CMN_TAXES_ALL jtc
4810: where jtc.tax_id = jrctt.tax_id
4811: and jtc.tax_type = jrttv.tax_type

Line 6289: ,JAI_REGIME_TAX_TYPES_V JRTTV

6285: IS
6286: SELECT COUNT(1)
6287: FROM JAI_CMN_TAX_CTG_LINES CATL
6288: ,JAI_CMN_TAXES_ALL CODES
6289: ,JAI_REGIME_TAX_TYPES_V JRTTV
6290: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
6291: AND CATL.TAX_ID = CODES.TAX_ID
6292: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
6293: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;