DBA Data[Home] [Help]

APPS.JE_JENOGEIM_XMLP_PKG SQL Statements

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

Line: 39

      SELECT
        PRECISION
      INTO PRECISION
      FROM
        FND_CURRENCIES
      WHERE CURRENCY_CODE = FUNCTCURR;
Line: 67

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_APPLICATION_VL AP
      WHERE AP.APPLICATION_ID = CP.APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_NAME = 'JENOGEIM'
        AND AP.APPLICATION_SHORT_NAME = 'JE';
Line: 89

      SELECT
        FND_DATE.DATE_TO_CHARDATE(SYSDATE)
      INTO V_DATE
      FROM
        DUAL;
Line: 108

  FUNCTION SELECT_ALL_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ALL;
Line: 111

  END SELECT_ALL_P;