APPS.EDW_TIME_PKG SQL Statements

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

Line: 19

select	ins.instance_code,
        sob.accounted_period_type,
        sob.period_set_name
from 	edw_local_instance ins,
        gl_sets_of_books sob
where 	set_of_books_id = p_set_of_books_id;

Line: 86

select	ins.instance_code,
  	sob.period_set_name
from 	edw_local_instance ins,
	gl_sets_of_books sob
where 	set_of_books_id = p_set_of_books_id;

Line: 146

select  ins.instance_code,
	maps.period_set_name,
	maps.period_name
from	edw_local_instance ins,
	gl_sets_of_books sob,
	gl_date_period_map maps
where	maps.period_set_name = sob.period_set_name
and	maps.period_type = sob.accounted_period_type
and	maps.accounting_date = trunc(cal_date)
and	sob.set_of_books_id = p_set_of_books_id;

Line: 210

   select ins.instance_code,
          gl.period_set_name,
          imp.pa_period_type
   from   edw_local_instance ins,
          pa_implementations_all imp,
          gl_sets_of_books gl
   where  imp.org_id = p_org_id
   and    gl.set_of_books_id = imp.set_of_books_id;

Line: 221

   select ins.instance_code,
          gl.period_set_name,
          imp.pa_period_type
   from   edw_local_instance ins,
          pa_implementations_all imp,
          gl_sets_of_books gl
   where  imp.org_id is NULL
   and    gl.set_of_books_id = imp.set_of_books_id;