APPS.JAI_AP_PSA_TRIGGER_PKG SQL Statements

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

Line: 15

    select  source,
            invoice_type_lookup_code
    from    ap_invoices_all
    where   invoice_id = p_invoice_id;

Line: 21

    select parent_inv_payment_priority
    from   jai_ap_tds_thhold_trxs
    where  invoice_to_vendor_id = p_invoice_id;

Line: 61

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

Line: 81

  if pv_action = jai_constants.inserting then

    open  c_ap_invoices_all(pr_new.invoice_id);

Line: 102

  end if; /*  if pv_action = jai_constants.inserting than  */