APPS.JAI_GST_TAX_DEFAULTATION_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

      SELECT master_organization_id FROM oe_system_parameters;

Line: 42

      SELECT jrp.state_code state_code
        FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
       WHERE jrp.ORGANIZATION_ID = pn_organization_id
         AND jrp.ORGANIZATION_TYPE = 'IO' --inventory organization
         AND jrd.regime_id = jrp.regime_id
         AND jrd.regime_code = jai_constants.cgst_regime
         AND jrp.location_id = pn_location_id;

Line: 51

      SELECT jrp.state_code state_code
        FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
       WHERE jrp.ORGANIZATION_ID = pn_organization_id
         AND jrp.ORGANIZATION_TYPE = 'IO' --inventory organization
         AND jrd.regime_id = jrp.regime_id
         AND jrd.regime_code = jai_constants.sgst_regime
         AND jrp.location_id = pn_location_id;

Line: 118

      SELECT jrp.state_code state_code
        FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
       WHERE jrp.ORGANIZATION_ID = pn_org_id
         AND jrp.ORGANIZATION_TYPE = 'OU' --operating unit
         AND jrd.regime_id = jrp.regime_id
         AND jrd.regime_code = jai_constants.cgst_regime
         AND jrp.state_code IS NOT NULL;

Line: 127

      SELECT jrp.state_code state_code
        FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
       WHERE jrp.ORGANIZATION_ID = pn_org_id
         AND jrp.ORGANIZATION_TYPE = 'OU' --operating unit
         AND jrd.regime_id = jrp.regime_id
         AND jrd.regime_code = jai_constants.sgst_regime
         AND jrp.state_code IS NOT NULL;

Line: 194

      SELECT cust_acct_site_id address_id
        FROM hz_cust_site_uses_all A
       WHERE A.site_use_id = pn_ship_to_site_use_id;

Line: 200

      SELECT STATE_CODE
        FROM JAI_CMN_CUS_ADDRESSES a
       WHERE A.customer_id = pn_customer_id
         AND A.address_id = p_address_id;

Line: 284

      SELECT STATE_CODE
        FROM JAI_CMN_VENDOR_SITES A
       WHERE a.vendor_id = pn_vendor_id
         AND a.vendor_site_id = pn_vendor_site_id;

Line: 361

      SELECT STATE_CODE
        FROM JAI_CMN_VENDOR_SITES A
       WHERE a.vendor_id = pn_vendor_id
         AND a.vendor_site_id = pn_vendor_site_id;

Line: 449

      SELECT cust_acct_site_id address_id
        FROM hz_cust_site_uses_all A
       WHERE A.site_use_id = pn_ship_to_site_use_id;

Line: 455

      SELECT tax_category_list
        FROM JAI_CMN_CUS_ADDRESSES a
       WHERE A.customer_id = pn_customer_id
         AND A.address_id = p_address_id;

Line: 461

      SELECT t.tax_category_id
        FROM JAI_INV_ITM_TAXCTG_DTLS a, JAI_CMN_TAX_CTGS_ALL t
       WHERE pd_transaction_date >= nvl(t.start_date, pd_transaction_date)
         AND pd_transaction_date < trunc(nvl(t.end_date, pd_transaction_date ) +1)
         AND nvl(t.INTER_STATE_FLAG, 'N') = p_inter_flag
         AND t.tax_category_id = a.tax_category_id
         AND a.tax_category_list = p_tax_category_list
         AND a.inventory_item_id = pn_inventory_item_id;

Line: 588

      SELECT tax_category_list
        FROM JAI_CMN_VENDOR_SITES A
       WHERE a.vendor_id = pn_vendor_id
         AND a.vendor_site_id = pn_vendor_site_id;

Line: 595

      SELECT t.tax_category_id
        FROM JAI_INV_ITM_TAXCTG_DTLS a, JAI_CMN_TAX_CTGS_ALL t
       WHERE pd_transaction_date >= nvl(t.start_date, pd_transaction_date)
         AND pd_transaction_date < trunc(nvl(t.end_date, pd_transaction_date ) +1)
         AND nvl(t.INTER_STATE_FLAG, 'N') = p_inter_flag
         AND a.tax_category_id = t.tax_category_id
         AND a.tax_category_list = p_tax_category_list
         AND a.inventory_item_id = pn_inventory_item_id;

Line: 710

      SELECT org_id operating_unit, master_organization_id
        FROM oe_system_parameters;

Line: 714

      SELECT operating_unit
        FROM org_organization_definitions
       WHERE organization_id = NVL(c_org_id, 0);

Line: 722

      SELECT a.attribute_value
        FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
       WHERE a.attribute_code = jai_constants.tax_classification
         AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
         AND r.inventory_item_id = v_inventory_item_id
         AND r.organization_id = v_org_id
         AND r.regime_code = jai_constants.cgst_regime;

Line: 730

      SELECT a.attribute_value
        FROM JAI_RGM_ITM_TMPL_ATTRS a, JAI_RGM_ITM_REGNS r
       WHERE a.attribute_code = jai_constants.tax_classification
         AND r.RGM_ITEM_REGNS_ID = a.RGM_ITEM_REGNS_ID
         AND r.inventory_item_id = v_inventory_item_id
         AND r.organization_id = v_org_id
         AND r.regime_code = jai_constants.sgst_regime;

Line: 790

          SELECT b.tax_category_id
            INTO pn_tax_category_id
            FROM JAI_CMN_TAX_CTGS_ALL b
           WHERE pd_transaction_date >= nvl(b.start_date, pd_transaction_date)
             AND pd_transaction_date < trunc(nvl(b.end_date, pd_transaction_date ) +1)
             AND nvl(b.inter_state_flag, 'N') = v_inter_flag
             AND b.tax_classification = v_tax_classification
             AND b.org_id = v_operating_unit;