APPS.IGI_POST SQL Statements

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

Line: 8

  	SELECT JE_BATCH_ID,
               BUDGETARY_CONTROL_STATUS,
               STATUS
  	FROM   GL_JE_BATCHES
  	WHERE  POSTING_RUN_ID = P_RUN_ID;

Line: 15

  	SELECT	  JE_HEADER_ID
               -- , SET_OF_BOOKS_ID  -- bug 6315298
		, LEDGER_ID  -- bug 6315298
		, BUDGET_VERSION_ID
		, CURRENCY_CODE
		, PERIOD_NAME
		, STATUS
		, JE_SOURCE
		, JE_CATEGORY
	FROM	  GL_JE_HEADERS
	WHERE	  JE_BATCH_ID = P_JE_BATCH_ID;

Line: 48

	    UPDATE  GL_JE_LINES
	    SET     REFERENCE_1  = 'IGIGBUDMB'
		  , REFERENCE_2  = JE_HEADER_ID+JE_LINE_NUM
		  , REFERENCE_6  = 'N'
	    WHERE  JE_HEADER_ID = cont2.je_header_id;