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;

Line: 84

 /* IF condition added for bug 7567537 - amount should be updated only for
  * transactions from PO source*/
 IF pr_new.invoice_distribution_id IS NULL AND pr_new.write_off_id IS NULL
 THEN
  OPEN  cur_get_accrual_amount (cpn_transaction_id => ln_transaction_id);