APPS.JG_XLA_GL_TRANSFER_PKG SQL Statements

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

Line: 59

			  p_selection_type                   NUMBER DEFAULT 1,
			  p_batch_name                       VARCHAR2,
			  p_start_date                       DATE,
			  p_end_date                         DATE,
			  p_gl_transfer_mode                 VARCHAR2,
			  p_process_days                     NUMBER   DEFAULT 'N',
			  p_debug_flag                       VARCHAR2 ) IS

   l_product_code 	   VARCHAR2(10);

Line: 102

 	        SELECT  DISTINCT 'Procedure Installed'
	        INTO    l_is_there
	        FROM    all_source
	        WHERE   name = 'JL_XLA_GL_TRANSFER_PKG'
	        AND     type = 'PACKAGE BODY';