APPS.JG_RX_C_IR_PKG SQL Statements

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

Line: 182

	SELECT  start_date, end_date
        INTO    h_account_date_low, h_account_date_high
        FROM    gl_period_statuses
        WHERE   period_name = argument8
        AND   	set_of_books_id = h_set_of_book_id
        AND     application_id = 200
        AND 	NVL(adjustment_period_flag, 'N') = 'N';

Line: 192

	Select 	chart_of_accounts_id
	into	h_chart_of_acct_id
	from	GL_SETS_OF_BOOKS
	Where   SET_OF_BOOKS_ID =  h_set_of_book_id;