APPS.JE_JEITXLRG_XMLP_PKG SQL Statements

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

Line: 32

      SELECT
        NVL(A.LEGAL_ENTITY_ID
           ,B.LEGAL_ENTITY_ID)
      INTO P_LEGAL_ENTITY_ID
      FROM
        JG_ZZ_VAT_REP_ENTITIES A,
        JG_ZZ_VAT_REP_ENTITIES B
      WHERE A.MAPPING_VAT_REP_ENTITY_ID = B.VAT_REPORTING_ENTITY_ID (+)
        AND A.VAT_REPORTING_ENTITY_ID = P_REP_IDENTIFIER;

Line: 41

      SELECT
        count(*)
      INTO L_LE_ID_COUNT
      FROM
        JE_IT_EXEMPT_LETTERS
      WHERE SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID')
        AND LEGAL_ENTITY_ID IS NULL;

Line: 59

      SELECT
        TO_DATE(START_DATE
               ,'DD-MM-RRRR'),
        PERIOD_YEAR
      INTO P_FIRST_DAY,CP_YEAR
      FROM
        GL_PERIODS
      WHERE PERIOD_SET_NAME = P_PERIOD_SET_NAME
        AND PERIOD_NAME = P_PERIOD_FROM;

Line: 68

      SELECT
        TO_DATE(END_DATE
               ,'DD-MM-RRRR')
      INTO P_LAST_DAY
      FROM
        GL_PERIODS
      WHERE PERIOD_SET_NAME = P_PERIOD_SET_NAME
        AND PERIOD_NAME = P_PERIOD_TO;

Line: 76

      SELECT
        NAME
      INTO P_NAME
      FROM
        GL_LEDGERS_PUBLIC_V
      WHERE LEDGER_ID = P_LEDGER_ID;

Line: 84

        SELECT
          sysdate
        INTO P_EFFECTIVE_DATE
        FROM
          DUAL;

Line: 89

        SELECT
          ETBP.PARTY_ID
        INTO X_ME_PARTY_ID
        FROM
          XLE_ETB_PROFILES ETBP
        WHERE ETBP.MAIN_ESTABLISHMENT_FLAG = 'Y'
          AND ETBP.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 109

        SELECT
          REGISTRATION_NUMBER
        INTO C_TAXPAYER_ID
        FROM
          XLE_REGISTRATIONS_V
        WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
          AND LEGISLATIVE_CATEGORY = 'INCOME_TAX';

Line: 116

        SELECT
          REGISTRATION_NUMBER
        INTO C_COMMERCIAL_NUM
        FROM
          XLE_REGISTRATIONS_V
        WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
          AND LEGISLATIVE_CATEGORY = 'COMMERCIAL_LAW';

Line: 123

        SELECT
          SUBSTR(XFIV.ADDRESS_LINE_1
                ,1
                ,40) ADDRESS_LINE1,
          NVL(SUBSTR(XFIV.ADDRESS_LINE_2
                    ,1
                    ,40)
             ,' ') ADDRESS_LINE2,
          NVL(SUBSTR(XFIV.ADDRESS_LINE_3
                    ,1
                    ,40)
             ,' ') ADDRESS_LINE3,
          XFIV.POSTAL_CODE || ' ' || XFIV.TOWN_OR_CITY CODE_CITY,
          XFIV.COUNTRY COUNTRY
        INTO P_ADDRESS1,P_ADDRESS2,P_ADDRESS3,P_CODE_CITY,P_COUNTRY
        FROM
          XLE_FIRSTPARTY_INFORMATION_V XFIV
        WHERE XFIV.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 145

          SELECT
            GEOGRAPHY_NAME
          INTO CP_COUNTRY_NAME
          FROM
            HZ_GEOGRAPHIES
          WHERE GEOGRAPHY_CODE = P_COUNTRY
            AND GEOGRAPHY_TYPE = 'COUNTRY';