APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AP_TDS_YEARS

Line 221: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;

217: lv_called_from varchar2(30);
218:
219: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30
220: ---------------------------------------------------------------
221: lv_inclu_tax_flag jai_ap_tds_years.inclusive_tax_flag%TYPE;
222: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
223:
224: CURSOR cur_separate_flag(pn_org_id IN NUMBER) IS
225: SELECT

Line 228: jai_ap_tds_years ja

224: CURSOR cur_separate_flag(pn_org_id IN NUMBER) IS
225: SELECT
226: nvl(ja.inclusive_tax_flag, 'N') inclusive_tax_flag
227: FROM
228: jai_ap_tds_years ja
229: WHERE ja.legal_entity_id = pn_org_id
230: AND sysdate between ja.start_date and ja.end_date;
231:
232: CURSOR cur_cust_trx_type(pn_customer_trx_id IN NUMBER) IS