APPS.PA_PAXAGAST_XMLP_PKG SQL Statements

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

Line: 53

    select p.party_name into cust_name from
    hz_parties p, hz_cust_accounts c
    where p.party_id = c.party_id
      and c.cust_account_id = CUST;

Line: 79

  SELECT  rtrim(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;