APPS.JL_JLCLGCAL_XMLP_PKG SQL Statements

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

Line: 45

      SELECT
        NVL(USER_JE_SOURCE_NAME
           ,'**********')
      INTO TRANS_SOURCE
      FROM
        GL_JE_SOURCES_TL
      WHERE JE_SOURCE_NAME = SOURCE_ID
        AND LANGUAGE = 'US';

Line: 59

      SELECT
        DESCRIPTION
      INTO TRANS_MEANING
      FROM
        GL_LOOKUPS
      WHERE LOOKUP_TYPE = 'SUBLDGR_DRILLDOWN_TRANS_TYPE'
        AND LOOKUP_CODE = TRANS_TYPE;

Line: 82

      SELECT
        EFFECTIVE_PERIOD_NUM
      INTO EFF_PERIOD_NUM
      FROM
        GL_PERIOD_STATUSES
      WHERE APPLICATION_ID = 101
        AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
        AND UPPER(PERIOD_NAME) = UPPER(P_START_PERIOD);

Line: 102

      SELECT
        EFFECTIVE_PERIOD_NUM
      INTO EFF_PERIOD_NUM
      FROM
        GL_PERIOD_STATUSES
      WHERE APPLICATION_ID = 101
        AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
        AND UPPER(PERIOD_NAME) = UPPER(P_END_PERIOD);

Line: 139

      SELECT
        SEGMENT1_LOW || L_DELIMITER || SEGMENT2_LOW || L_DELIMITER || SEGMENT3_LOW || L_DELIMITER ||
	SEGMENT4_LOW || L_DELIMITER || SEGMENT5_LOW || L_DELIMITER || SEGMENT6_LOW || L_DELIMITER ||
	SEGMENT7_LOW || L_DELIMITER || SEGMENT8_LOW || L_DELIMITER || SEGMENT9_LOW || L_DELIMITER ||
	SEGMENT10_LOW || L_DELIMITER || SEGMENT11_LOW || L_DELIMITER || SEGMENT12_LOW || L_DELIMITER ||
	SEGMENT13_LOW || L_DELIMITER || SEGMENT14_LOW || L_DELIMITER || SEGMENT15_LOW || L_DELIMITER ||
	SEGMENT16_LOW || L_DELIMITER || SEGMENT17_LOW || L_DELIMITER || SEGMENT18_LOW || L_DELIMITER ||
	SEGMENT19_LOW || L_DELIMITER || SEGMENT20_LOW || L_DELIMITER || SEGMENT21_LOW || L_DELIMITER ||
	SEGMENT22_LOW || L_DELIMITER || SEGMENT23_LOW || L_DELIMITER || SEGMENT24_LOW || L_DELIMITER ||
	SEGMENT25_LOW || L_DELIMITER || SEGMENT26_LOW || L_DELIMITER || SEGMENT27_LOW || L_DELIMITER ||
	SEGMENT28_LOW || L_DELIMITER || SEGMENT29_LOW || L_DELIMITER || SEGMENT30_LOW ACCOUNT_LOW,
        SEGMENT1_HIGH || L_DELIMITER || SEGMENT2_HIGH || L_DELIMITER || SEGMENT3_HIGH || L_DELIMITER ||
	SEGMENT4_HIGH || L_DELIMITER || SEGMENT5_HIGH || L_DELIMITER || SEGMENT6_HIGH || L_DELIMITER ||
	SEGMENT7_HIGH || L_DELIMITER || SEGMENT8_HIGH || L_DELIMITER || SEGMENT9_HIGH || L_DELIMITER ||
	SEGMENT10_HIGH || L_DELIMITER || SEGMENT11_HIGH || L_DELIMITER || SEGMENT12_HIGH || L_DELIMITER ||
	SEGMENT13_HIGH || L_DELIMITER || SEGMENT14_HIGH || L_DELIMITER || SEGMENT15_HIGH || L_DELIMITER ||
	SEGMENT16_HIGH || L_DELIMITER || SEGMENT17_HIGH || L_DELIMITER || SEGMENT18_HIGH || L_DELIMITER ||
	SEGMENT19_HIGH || L_DELIMITER || SEGMENT20_HIGH || L_DELIMITER || SEGMENT21_HIGH || L_DELIMITER ||
	SEGMENT22_HIGH || L_DELIMITER || SEGMENT23_HIGH || L_DELIMITER || SEGMENT24_HIGH || L_DELIMITER ||
	SEGMENT25_HIGH || L_DELIMITER || SEGMENT26_HIGH || L_DELIMITER || SEGMENT27_HIGH || L_DELIMITER ||
	SEGMENT28_HIGH || L_DELIMITER || SEGMENT29_HIGH || L_DELIMITER || SEGMENT30_HIGH ACCOUNT_HIGH
      FROM
        JL_ZZ_GL_AXI_MODEL_RANGES AMR
      WHERE AMR.MODEL_ID = P_MODEL_ID;

Line: 311

   SELECT name comp_name,
          registration_number,
          activity_code,
          ltrim(address_line_1 ||' '|| address_line_2),
          ltrim(address_line_3 ||' '|| town_or_city)
   INTO   CP_COMP_NAME,
          CP_COMP_TAXPAYER_ID,
          CP_COMP_ESTAB_TYPE,
          CP_COMP_ADDRESS1,
          CP_COMP_ADDRESS2
   FROM   XLE_FIRSTPARTY_INFORMATION_V
   WHERE  Legal_entity_id = P_COMPANY_ID
     AND  LEGISLATIVE_CAT_CODE = 'INCOME_TAX';

Line: 333

   SELECT concatenated_segment_delimiter
   INTO   delimiter
   FROM   fnd_id_flex_structures
   WHERE  application_id = 101
   AND    id_flex_code = 'GL#'
   AND    id_flex_num  = P_CHART_OF_ACCTS_ID
   AND    ROWNUM < 2;

Line: 357

   SELECT name
   INTO   CP_MODEL_NAME
   FROM   jl_zz_gl_axi_models
   WHERE  model_id = P_MODEL_ID
   AND    set_of_books_id = P_SET_OF_BOOKS_ID;

Line: 391

              	MODE="SELECT" DISPLAY="ALL"'); */

Line: 417

/* Generate the selected ORDER BY */
/*--**
if (:P_ORDER_TYPE = 'A') then
  :ORDER_BY := :ORDERBY_ACCT || ', ' ||
	       :ORDERBY_ACCT2 || ', ' ||
               :ORDERBY_BAL || ', ' ||
	       :ORDERBY_BAL2 || ', ' ||
               :ORDERBY_ALL || ', ' ||
               'src.user_je_source_name, ' ||
               'cat.user_je_category_name, ' ||
               'jeb.name, jeh.name, jel.je_line_num';