APPS.JA_JAINJVR_XMLP_PKG SQL Statements

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

Line: 14

      SELECT
        NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = SOB_ID;

Line: 30

      SELECT
        DISTINCT
        APPLICATION_COLUMN_NAME
      FROM
        FND_SEGMENT_ATTRIBUTE_VALUES
      WHERE APPLICATION_ID = 101
        AND ID_FLEX_CODE = 'GL#'
        AND ID_FLEX_NUM = P_CHART_OF_ACCTS_ID
        AND SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
        AND ATTRIBUTE_VALUE = 'Y';

Line: 41

      SELECT
        A.FLEX_VALUE_SET_ID
      FROM
        FND_ID_FLEX_SEGMENTS A
      WHERE A.APPLICATION_COLUMN_NAME = V_COLUMN_NAME
        AND A.APPLICATION_ID = 101
        AND A.ID_FLEX_CODE = 'GL#'
        AND A.ID_FLEX_NUM = P_CHART_OF_ACCTS_ID;

Line: 54

      SELECT
        SUBSTR(DESCRIPTION
              ,1
              ,50)
      FROM
        FND_FLEX_VALUES_VL
      WHERE FLEX_VALUE_SET_ID = V_FLEX_ID
        AND FLEX_VALUE = V_COLUMN_VALUE;

Line: 75

      'select ' || V_COLUMN_NAME || ' from gl_code_combinations
      		where chart_of_accounts_id = :P_CHART_OF_ACCTS_ID AND code_combination_id = :code_combination_id'
	        INTO p_column_value
		USING P_CHART_OF_ACCTS_ID,CODE_COMBINATION_ID  ;

Line: 89

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 129

      P_SELECTED_JV_NO := 'AND  gjh.doc_sequence_value = :p_jv_no ' || ' ' || NL;

Line: 148

	  SELECT count(*) INTO v_count
	FROM        gl_je_headers gjh,
		    gl_je_lines   gjl,
		    gl_code_combinations gcc,
		    gl_sets_of_books gsob
	WHERE gjh.je_header_id = gjl.je_header_id
	AND      gcc.code_combination_id = gjl.code_combination_id
	AND      gsob.set_of_books_id = gjh.ledger_id
	AND     gjh.je_source = NVL(p_source, gjh.je_source)
	AND     (gjh.doc_sequence_value = NVL(p_jv_no, gjh.doc_sequence_value) OR
	gjh.doc_sequence_value IS NULL)
	AND     gjh.ledger_id = p_sob_id
	AND     TRUNC(gjh.default_effective_date) BETWEEN
		  NVL(TRUNC(p_from_date),TRUNC(gjh.default_effective_date))
	      AND NVL(TRUNC(p_to_date),TRUNC(gjh.default_effective_date));