458: AND A.address_id = p_address_id;
459:
460: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, pn_inventory_item_id IN NUMBER, p_inter_flag IN VARCHAR2) IS
461: SELECT t.tax_category_id
462: FROM JAI_INV_ITM_TAXCTG_DTLS a, JAI_CMN_TAX_CTGS_ALL t
463: WHERE pd_transaction_date >= nvl(t.start_date, pd_transaction_date)
464: AND pd_transaction_date < trunc(nvl(t.end_date, pd_transaction_date ) +1)
465: AND nvl(t.INTER_STATE_FLAG, 'N') = p_inter_flag
466: AND t.tax_category_id = a.tax_category_id
592:
593: -- to get tax_category_id
594: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, pn_inventory_item_id IN NUMBER, p_inter_flag IN VARCHAR2) IS
595: SELECT t.tax_category_id
596: FROM JAI_INV_ITM_TAXCTG_DTLS a, JAI_CMN_TAX_CTGS_ALL t
597: WHERE pd_transaction_date >= nvl(t.start_date, pd_transaction_date)
598: AND pd_transaction_date < trunc(nvl(t.end_date, pd_transaction_date ) +1)
599: AND nvl(t.INTER_STATE_FLAG, 'N') = p_inter_flag
600: AND a.tax_category_id = t.tax_category_id