DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 6287: FROM JAI_CMN_TAX_CTG_LINES CATL

6283: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
6284: )
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

Line 7382: FROM JAI_CMN_TAX_CTG_LINES A

7378: WHERE customer_trx_id = v_header_id;
7379:
7380: Cursor tax_id_cur(p_tax_category_id IN Number) IS
7381: SELECT line_no
7382: FROM JAI_CMN_TAX_CTG_LINES A
7383: WHERE A.tax_category_id = p_tax_category_id
7384: ORDER BY line_no;
7385:
7386: /* to get address_id */