APPS.JE_JEITAPEX_XMLP_PKG SQL Statements

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

Line: 21

      SELECT
        count(*)
      INTO L_LE_ID_COUNT
      FROM
        JE_IT_EXEMPT_LETTERS
      WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
        AND LEGAL_ENTITY_ID IS NULL;

Line: 30

      SELECT
        NVL(A.LEGAL_ENTITY_ID
           ,B.LEGAL_ENTITY_ID)
      INTO P_LEGAL_ENTITY_ID_V
      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: 45

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

Line: 53

      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: 61

      SELECT
        LEDGER.NAME,
        LEDGER.CURRENCY_CODE
      INTO C_OUR_SOB_NAME,C_FUNCTIONAL_CURRENCY
      FROM
        GL_LEDGERS_PUBLIC_V LEDGER
      WHERE LEDGER.LEDGER_ID = P_SET_OF_BKS_ID;

Line: 77

        SELECT
          sysdate
        INTO P_EFFECTIVE_DATE
        FROM
          DUAL;

Line: 82

        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_V;

Line: 102

        SELECT
          XFIV.NAME,
          XFIV.ADDRESS_LINE_1,
          SUBSTR(SUBSTR(XFIV.POSTAL_CODE
                       ,1
                       ,5) || '       ' || XFIV.TOWN_OR_CITY || ' ' || XFIV.REGION_1
                ,1
                ,40),
          SUBSTR(XFIV.POSTAL_CODE
                ,1
                ,5) || '       ' || XFIV.TOWN_OR_CITY,
          SUBSTR(HRL.DESCRIPTION
                ,1
                ,43),
          XFIV.COUNTRY
        INTO C_LE_NAME,C_OUR_STREET,C_OUR_ZIPCITY,C_OUR_ZIP_CITY,C_LOCATION,P_COUNTRY
        FROM
          XLE_FIRSTPARTY_INFORMATION_V XFIV,
          HR_LOCATIONS HRL
        WHERE XFIV.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID_V
          AND XFIV.LOCATION_ID = HRL.LOCATION_ID;

Line: 124

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

Line: 131

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

Line: 138

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

Line: 169

      UPDATE
        JE_IT_EXEMPT_LETTERS
      SET
        PRINT_FLAG = 'N'
      WHERE ROWID = PRINT_ROWID;

Line: 185

      UPDATE
        JE_IT_EXEMPT_LETTERS
      SET
        ISSUE_FLAG = 'N'
        ,ISSUE_DATE = SYSDATE
      WHERE ROWID = ISSUE_ROWID;

Line: 218

      SELECT
        PLACE_OF_BIRTH || ' ' || DATE_OF_BIRTH,
        GENDER
      INTO C_PLACE,C_SEX
      FROM
        HZ_PERSON_PROFILES HPP
      WHERE EXISTS (
        SELECT
          null
        FROM
          HZ_PARTIES HP
        WHERE HP.PARTY_ID = HPP.PARTY_ID
          AND HP.PARTY_NAME = HPP.PERSON_NAME
          AND HP.PARTY_ID = PARTYID );