APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

Line 462: FROM JAI_INV_ITM_TAXCTG_DTLS a, JAI_CMN_TAX_CTGS_ALL t

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

Line 596: FROM JAI_INV_ITM_TAXCTG_DTLS a, JAI_CMN_TAX_CTGS_ALL t

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

Line 792: FROM JAI_CMN_TAX_CTGS_ALL b

788: IF v_tax_classification IS NOT NULL THEN
789: BEGIN
790: SELECT b.tax_category_id
791: INTO pn_tax_category_id
792: FROM JAI_CMN_TAX_CTGS_ALL b
793: WHERE pd_transaction_date >= nvl(b.start_date, pd_transaction_date)
794: AND pd_transaction_date < trunc(nvl(b.end_date, pd_transaction_date ) +1)
795: AND nvl(b.inter_state_flag, 'N') = v_inter_flag
796: AND b.tax_classification = v_tax_classification