APPS.JA_JAINCVAT_XMLP_PKG SQL Statements

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

Line: 18

    SELECT
      ORGANIZATION_NAME
    INTO V_ORGANIZATION_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS
    WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 32

    SELECT
      LOCATION_CODE
    INTO V_LOCATION_NAME
    FROM
      HR_LOCATIONS
    WHERE LOCATION_ID = P_LOCATION_ID;

Line: 45

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 86

      SELECT
        ROUNDING_ID
      FROM
        JAI_CMN_RG_23AC_II_TRXS
      WHERE REGISTER_ID = REGISTER_ID;

Line: 92

      SELECT
        ROUNDED_EXCISE_EDU_CESS + ROUNDED_CVD_EDU_CESS,
        ( EXCISE_EDU_CESS + CVD_EDU_CESS - ROUNDED_EXCISE_EDU_CESS - ROUNDED_CVD_EDU_CESS ) BAL
      FROM
        JAI_CMN_RG_ROUND_HDRS
      WHERE EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
        AND ROUNDING_ID = LN_ROUNDING_ID;

Line: 100

      SELECT
        NVL(SUM(CREDIT)
           ,0)
      FROM
        JAI_CMN_RG_OTHERS
      WHERE SOURCE_REGISTER_ID = REGISTER_ID
        AND SOURCE_TYPE = 1
        AND TAX_TYPE in ( LV_TAX_TYPE_EXC_EDU_CESS , LV_TAX_TYPE_CVD_EDU_CESS );

Line: 141

      SELECT
        ROUNDING_ID
      FROM
        JAI_CMN_RG_23AC_II_TRXS
      WHERE REGISTER_ID = REGISTER_ID;

Line: 147

      SELECT
        ROUNDED_BASIC_ED + ROUNDED_ADDITIONAL_ED + ROUNDED_OTHER_ED,
        NVL(ROUNDED_ADDITIONAL_CVD
           ,0),
        ( BASIC_ED + ADDITIONAL_ED + OTHER_ED ) - ( ROUNDED_BASIC_ED + ROUNDED_ADDITIONAL_ED + ROUNDED_OTHER_ED )
      FROM
        JAI_CMN_RG_ROUND_HDRS
      WHERE EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
        AND ROUNDING_ID = LN_ROUNDING_ID;

Line: 190

      SELECT
        ROUNDING_ID
      FROM
        JAI_CMN_RG_23AC_II_TRXS
      WHERE REGISTER_ID = REGISTER_ID;

Line: 196

      SELECT
        ROUNDED_SH_EXCISE_EDU_CESS + ROUNDED_SH_CVD_EDU_CESS,
        ( SH_EXCISE_EDU_CESS + SH_CVD_EDU_CESS - ROUNDED_SH_EXCISE_EDU_CESS - ROUNDED_SH_CVD_EDU_CESS ) BAL
      FROM
        JAI_CMN_RG_ROUND_HDRS
      WHERE EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
        AND ROUNDING_ID = LN_ROUNDING_ID;

Line: 204

      SELECT
        NVL(SUM(CREDIT)
           ,0)
      FROM
        JAI_CMN_RG_OTHERS
      WHERE SOURCE_REGISTER_ID = REGISTER_ID
        AND SOURCE_TYPE = 1
        AND TAX_TYPE in ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );

Line: 243

      SELECT
        SUM(NVL(CREDIT
               ,0))
      FROM
        JAI_CMN_RG_OTHERS
      WHERE SOURCE_TYPE = 4
        AND SOURCE_REGISTER_ID = TRANSACTION_ID
        AND TAX_TYPE IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' );

Line: 252

      SELECT
        SUM(NVL(CREDIT
               ,0))
      FROM
        JAI_CMN_RG_OTHERS
      WHERE SOURCE_TYPE = 4
        AND SOURCE_REGISTER_ID = TRANSACTION_ID
        AND TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );