APPS.AP_REPORTS_UTILITY_PKG SQL Statements

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

Line: 10

  select set_of_books_id, invoice_date
  into   l_sob_id, l_inv_date
  from   ap_invoices_all
  where  invoice_id = l_invoice_id;

Line: 15

  select period_name
  into   l_period_name
  from   gl_period_statuses
  where  application_id = 200
  and    set_of_books_id = l_sob_id
  and    l_inv_Date between start_date and end_date;

Line: 33

  select APS.set_of_books_id, AC.check_date
  into   l_sob_id, l_check_date
  from   ap_checks_all AC, ap_system_parameters_all APS
  where  check_id = l_check_id
  and    AC.org_id = APS.org_id;

Line: 39

  select period_name
  into   l_period_name
  from   gl_period_statuses
  where  application_id = 200
  and    set_of_books_id = l_sob_id
  and    l_check_date between start_date and end_date;