APPS.JL_JLCOARCR_XMLP_PKG SQL Statements

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

Line: 37

      SELECT
        LE.NAME,
        LE.REGISTRATION_NUMBER,
        LE.ADDRESS_LINE_1,
        LE.ADDRESS_LINE_2,
        LE.ADDRESS_LINE_3
      INTO COMPANY_NAME,NIT_NUMBER,VADDRESS1,VADDRESS2,VADDRESS3
      FROM
        HR_LOCATIONS HR,
        XLE_FIRSTPARTY_INFORMATION_V LE
      WHERE HR.LOCATION_ID = LE.LOCATION_ID
        AND LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;

Line: 58

      SELECT
        GEO.GEOGRAPHY_NAME
      INTO VTOWN_CITY
      FROM
        HZ_GEOGRAPHIES GEO,
        HR_LOCATIONS HL,
        XLE_FIRSTPARTY_INFORMATION_V LE
      WHERE GEO.GEOGRAPHY_NAME = HL.TOWN_OR_CITY
        AND GEO.GEOGRAPHY_TYPE = 'CITY'
        AND GEO.COUNTRY_CODE = HL.COUNTRY
        AND GEO.GEOGRAPHY_ELEMENT2_CODE = HL.REGION_2
        AND LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
        AND HL.LOCATION_ID = LE.LOCATION_ID;

Line: 76

      SELECT
        GEO.GEOGRAPHY_NAME
      INTO VREGION
      FROM
        HZ_GEOGRAPHIES GEO,
        HR_LOCATIONS HRL,
        XLE_FIRSTPARTY_INFORMATION_V LE
      WHERE LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
        AND LE.LOCATION_ID = HRL.LOCATION_ID
        AND GEO.GEOGRAPHY_CODE = HRL.REGION_2
        AND GEO.GEOGRAPHY_TYPE = 'PROVINCE'
        AND GEO.COUNTRY_CODE = HRL.COUNTRY;

Line: 93

      SELECT
        FT.TERRITORY_SHORT_NAME
      INTO VCOUNTRY
      FROM
        FND_TERRITORIES_VL FT,
        HR_LOCATIONS HL
      WHERE FT.TERRITORY_CODE = HL.COUNTRY
        AND HL.LOCATION_ID = VLOCATION_ID;

Line: 323

      SELECT
        INITCAP(LOWER('e' || ' ' || L_WORD_AMOUNT2 || ' ' || DECODE(L_DECIMAL_PART
                            ,1
                            ,P_SUB_UNIT_SINGULAR
                            ,P_SUB_UNIT_PLURAL)))
      INTO L_WORD_AMOUNT2
      FROM
        DUAL;

Line: 333

      SELECT
        INITCAP(LOWER(L_WORD_AMOUNT || ' ' || DECODE(TRUNC(P_AMOUNT)
                            ,1
                            ,P_UNIT_SINGULAR
                            ,P_UNIT_PLURAL)))
      INTO L_CURRENCY_WORD
      FROM
        DUAL;

Line: 342

      SELECT
        INITCAP(LOWER(L_WORD_AMOUNT || ' ' || DECODE(TRUNC(P_AMOUNT)
                            ,1
                            ,P_UNIT_SINGULAR
                            ,P_UNIT_PLURAL) || ' ' || L_WORD_AMOUNT2))
      INTO L_CURRENCY_WORD
      FROM
        DUAL;

Line: 356

    SELECT
      PRECISION
    INTO L_PRECISION
    FROM
      FND_CURRENCIES_VL
    WHERE CURRENCY_CODE = CUR_CODE;

Line: 376

        SELECT
          MEANING
        INTO INV_NUM
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'PAYMENT_TYPE'
          AND LOOKUP_CODE = 'ACC';

Line: 384

        SELECT
          MEANING
        INTO INV_NUM
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'PAYMENT_TYPE'
          AND LOOKUP_CODE = 'UNAPP';