APPS.JAI_JRG_23AC1_TRIGGER_PKG SQL Statements

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

Line: 21

  SELECT
         vendor_changed_flag    ,
         vendor_id              ,
         vendor_site_id
  FROM
         JAI_RCV_CENVAT_CLAIMS
  WHERE
         transaction_id  in
                            (
                                SELECT
                                                transaction_id
                                FROM
                                                rcv_transactions
                                WHERE
                                                transaction_type        = cp_transaction_type /* 'RECEIVE'  --Ramananda for removal of SQL LITERALs */
                                START WITH
                                                transaction_id          =  pr_new.receipt_ref
                                CONNECT BY PRIOR
                                                parent_transaction_id   = transaction_id
                            );

Line: 53

  SELECT nvl(allow_negative_rg_flag,'N')
  FROM jai_cmn_inventory_orgs
  WHERE organization_id = cp_organization_id
  AND location_id = cp_location_id;