DBA Data[Home] [Help]

APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on JAI_RGM_ITM_TMPL_ATTRS

Line 723: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r

719:
720: --get tax_classification, if cgst not found, get from SGST
721: CURSOR tax_classification_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER) IS
722: SELECT a.attribute_value
723: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
724: WHERE a.attribute_code = jai_constants.tax_classification
725: AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
726: AND r.inventory_item_id = v_inventory_item_id
727: AND r.organization_id = v_org_id

Line 731: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r

727: AND r.organization_id = v_org_id
728: AND r.regime_code = jai_constants.cgst_regime;
729: CURSOR sgst_tax_classification_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER) IS
730: SELECT a.attribute_value
731: FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
732: WHERE a.attribute_code = jai_constants.tax_classification
733: AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
734: AND r.inventory_item_id = v_inventory_item_id
735: AND r.organization_id = v_org_id