DBA Data[Home] [Help]

APPS.JERX_C_TO SQL Statements

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

Line: 141

  SELECT parent_request_id
  INTO l_stage_request_id
  FROM fnd_concurrent_requests
  WHERE request_id = l_conc_request_id;
Line: 146

  SELECT parent_request_id
  INTO   l_set_request_id
  FROM fnd_concurrent_requests
  WHERE request_id = l_stage_request_id;
Line: 157

  select  	to_char(gps.start_date,'DD/MM/YYYY')||' 00:00:00',
                to_char(gps2.end_date,'DD/MM/YYYY')||' 23:59:59',
		sob.currency_code

  into		l_period_start_date,
		l_period_end_date,
		l_sob_currency_code

  from          gl_period_statuses gps,
                gl_period_statuses gps2,
               --- gl_sets_of_books sob,
                gl_ledgers_public_v sob,
		fnd_application fa
  where         fa.application_short_name = argument1
  and		fa.application_id = gps.application_id
  and		fa.application_id = gps2.application_id
  and		gps.set_of_books_id = to_number(argument2)
  --and           gps.ledger_id = to_number(argument2)
  and           gps.set_of_books_id = sob.ledger_id
  --and           gps.ledger_id = sob.ledger_id
  and           gps.period_name = argument3
  and           gps.adjustment_period_flag <> 'Y'
  and		gps2.set_of_books_id = to_number(argument2)
  and           gps2.set_of_books_id = sob.ledger_id
  and		gps2.ledger_id = to_number(argument2)
  and           gps2.ledger_id = sob.ledger_id
  and           gps2.period_name = argument4
  and           gps2.adjustment_period_flag <> 'Y';