DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 4915: FROM JAI_CMN_TAX_CTG_LINES CATL

4911: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
4912: )
4913: IS
4914: SELECT COUNT(1)
4915: FROM JAI_CMN_TAX_CTG_LINES CATL
4916: ,JAI_CMN_TAXES_ALL CODES
4917: ,JAI_REGIME_TAX_TYPES_V JRTTV
4918: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
4919: AND CATL.TAX_ID = CODES.TAX_ID

Line 5924: FROM JAI_CMN_TAX_CTG_LINES A

5920: WHERE customer_trx_id = v_header_id;
5921:
5922: Cursor tax_id_cur(p_tax_category_id IN Number) IS
5923: SELECT line_no
5924: FROM JAI_CMN_TAX_CTG_LINES A
5925: WHERE A.tax_category_id = p_tax_category_id
5926: ORDER BY line_no;
5927:
5928: /* to get address_id */