APPS.JAI_PO_CST_TRIGGER_PKG SQL Statements

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

Line: 26

  SELECT to_number(o3.org_information3) set_of_books_id
  FROM   hr_organization_information o3
  WHERE  organization_id = cpn_operating_unit_id
  AND    o3.org_information_context = cpv_information_context;

Line: 34

  SELECT accrual_amount
  FROM   jai_rcv_rep_accrual_t
  WHERE  transaction_id = cpn_transaction_id;

Line: 42

  SELECT quantity
  FROM   rcv_transactions
  WHERE  transaction_id = cpn_transaction_id;