APPS.PA_PAXRWSBR_XMLP_PKG SQL Statements

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

Line: 42

    select substr(name, 1, 60)
    into   hold_org_name
    from   hr_organization_units
    where  organization_id = PA_PAXRWSBR_XMLP_PKG.organization_id;

Line: 63

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl,pa_implementations pi
  WHERE   gl.set_of_books_id = pi.set_of_books_id;