APPS.JG_GLOBE_UTIL_PKG SQL Statements

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

Line: 30

         SELECT jl_globe_util_pkg.populate_icx_trx_reason_code
                                                          (p_org_id,
                                                           p_item_id,
                                                           p_deliver_to_org_id
                                                          )
           INTO l_txn_reason_code
           FROM DUAL;

Line: 67

      SELECT org_id
        INTO l_org_id
        FROM po_lines_all
       WHERE po_line_id = p_level_id;

Line: 82

            SELECT transaction_reason_code
              INTO l_transaction_reason_code
              FROM po_lines_all
             WHERE po_line_id = p_level_id;