APPS.ARP_VIEW_CONSTANTS SQL Statements

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

Line: 116

         select decode(max(period_name),
                       '', 0,
                           1)
         into   num_return_value
         from   gl_period_statuses
         where  application_id         = p_application_id
         and    set_of_books_id        = p_set_of_books_id
         and    adjustment_period_flag = 'N'
         and    l_gl_date between start_date and end_date
         and    closing_status in ('O', 'F', 'N');

Line: 127

         select decode(max(period_name),
                       '', 0,
                           1)
         into   num_return_value
         from   gl_period_statuses
         where  application_id         = p_application_id
         and    set_of_books_id        = p_set_of_books_id
         and    adjustment_period_flag = 'N'
         and    l_gl_date between start_date and end_date
         and    closing_status in ('O', 'F');

Line: 311

   select max(d.end_date)
   into   candidate_gl_date
   from   gl_period_statuses d,
          gl_period_statuses s
   where  d.application_id         = s.application_id
   and    d.set_of_books_id        = s.set_of_books_id
   and    d.adjustment_period_flag = 'N'
   and    d.end_date < sysdate
   and    d.closing_status         = 'O'
   and    s.application_id         = h_application_id
   and    s.set_of_books_id        = h_set_of_books_id
   and    s.adjustment_period_flag = 'N'
   and    s.closing_status         = 'F'
   and    sysdate between s.start_date and s.end_date;

Line: 380

      select min(start_date)
      into   candidate_gl_date
      from   gl_period_statuses
      where  application_id         = h_application_id
      and    set_of_books_id        = h_set_of_books_id
      and    adjustment_period_flag = 'N'
      and    closing_status         = 'O'
      and    start_date >= l_trx_date;

Line: 410

      select min(start_date)
      into   candidate_gl_date
      from   gl_period_statuses
      where  application_id         = h_application_id
      and    set_of_books_id        = h_set_of_books_id
      and    adjustment_period_flag = 'N'
      and    closing_status         = 'F'
      and    start_date >= l_trx_date;

Line: 441

      select max(start_date)
      into   candidate_gl_date
      from   gl_period_statuses
      where  application_id         = h_application_id
      and    set_of_books_id        = h_set_of_books_id
      and    adjustment_period_flag = 'N'
      and    closing_status         = 'O'
      and    start_date >= sysdate;

Line: 471

      select max(start_date), max(end_date)
      into   candidate_start_gl_date,
             candidate_end_gl_date
      from   gl_period_statuses
      where  application_id         = h_application_id
      and    set_of_books_id        = h_set_of_books_id
      and    adjustment_period_flag = 'N'
      and    closing_status         = 'O';

Line: 506

      select min(start_date)
      into   candidate_gl_date
      from   gl_period_statuses
      where  application_id         = h_application_id
      and    set_of_books_id        = h_set_of_books_id
      and    adjustment_period_flag = 'N'
      and    closing_status         = 'F'
      and    start_date >= sysdate;

Line: 537

      select max(start_date), max(end_date)
      into   candidate_start_gl_date,
             candidate_end_gl_date
      from   gl_period_statuses
      where  application_id         = h_application_id
      and    set_of_books_id        = h_set_of_books_id
      and    adjustment_period_flag = 'N'
      and    closing_status         = 'F';

Line: 597

  select set_of_books_id
  into   l_set_of_books_id
  from   ar_system_parameters ;

Line: 654

PROCEDURE set_ps_selected_in_batch (p_ps_autorct_batch IN varchar2) IS
BEGIN
pg_ps_autorct_batch := p_ps_autorct_batch;

Line: 659

FUNCTION get_ps_selected_in_batch RETURN varchar2 IS
BEGIN
return pg_ps_autorct_batch;