APPS.JAI_AP_HA_TRIGGER_PKG SQL Statements

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

Line: 15

    select source
    from   ap_invoices_all
    where invoice_id = p_invoice_id;

Line: 106

    SELECT vendor_id,
           vendor_site_id,
           invoice_currency_code,
           exchange_rate,
           set_of_books_id,
           source,
           cancelled_date,
           gl_date,
           org_id,
     			 --Bug#5131075(4685754). Added the below 3 by Lakshmi Gopalsami
				 	 invoice_amount,
				 	 payment_status_flag,
				 	 invoice_type_lookup_code

    FROM   ap_invoices_all
    WHERE  invoice_id = p_invoice_id;

Line: 172

 /* if pv_action = jai_constants.inserting or pv_action = jai_constants.updating then
  ln_org_id := pr_new.org_id;

Line: 190

	IF pv_action = jai_constants.inserting OR pv_action = jai_constants.deleting THEN
		RETURN;