APPS.JG_PO_EXTENSION_PKG SQL Statements

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

Line: 269

      SELECT DISTINCT 'Package Installed'
                 INTO l_jl_installed
                 FROM user_objects
                WHERE object_name = 'JG_GLOBE_UTIL_PKG'
                  AND object_type = 'PACKAGE BODY';

Line: 287

         SELECT l.transaction_reason_code
           INTO x_txn_reason_code
           FROM po_headers_all h, po_lines_all l
          WHERE h.po_header_id = l.po_header_id
            AND h.po_header_id = x_source_doc_header_id
            -- header id of BPA sourced
            AND l.line_num = x_source_doc_line_num   -- line id of BPA sourced
            AND h.type_lookup_code = 'BLANKET';

Line: 299

               'select  JG_GLOBE_UTIL_PKG.process_icx_line_globe_event '
            || ' (:p_org_id, :p_item_id, :p_dest_organization_id '
            || ') from dual ';