APPS.WIP_STD_WF SQL Statements

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

Line: 14

      select user_name
      from   fnd_user fu
      where  fu.employee_id = p_employee_id
      and    sysdate BETWEEN fu.start_date
 		         and nvl(fu.end_date, sysdate)
*/
BEGIN

   wf_directory.GetUserName(p_orig_system    => 'PER',
                            p_orig_system_id => p_employee_id,
                            p_name           => l_employee_login,
                            p_display_name   => l_employee_name);

Line: 52

      select user_name
      from   fnd_user fu
      where  fu.supplier_id = p_supplier_id
      and    sysdate BETWEEN fu.start_date
    		         and nvl(fu.end_date, sysdate)
      order by user_name;

Line: 83

   select shipping_manager_id
   into   l_shipper_id
   from   wip_parameters wp
   where  wp.organization_id = p_organization_id;

Line: 103

   select production_scheduler_id
   into   l_prod_sched_id
   from   wip_parameters wp
   where  wp.organization_id = p_organization_id;

Line: 127

   select buyer_id
   into   l_default_buyer_id
   from   mtl_system_items msi
   where  msi.inventory_item_id = p_item_id
   and    msi.organization_id = p_organization_id;

Line: 149

      select  pr.agent_id
      into    l_buyer_id
      from    po_releases_all  pr
      where   pr.po_header_id = p_po_header_id
      and     pr.release_num  = p_release_num ;

Line: 155

      select  ph.agent_id
      into    l_buyer_id
      from    po_headers_all ph
      where   ph.po_header_id = p_po_header_id;

Line: 175

    select vendor_contact_id
    into   l_supplier_contact_id
    from   po_headers_all ph
    where  ph.po_header_id = p_po_header_id;

Line: 210

   select  rowidtochar(ROWID)
   into    c_rowid
   from    AK_FLOW_REGION_RELATIONS
   where   FROM_REGION_CODE = 'ICX_PO_OSP'
   and     FROM_REGION_APPL_ID = 178
   and     FROM_PAGE_CODE = 'ICX_RQS_HISTORY_1'
   and     FROM_PAGE_APPL_ID = 178
   and     TO_PAGE_CODE = 'ICX_RQS_HISTORY_DTL_D'
   and     TO_PAGE_APPL_ID = 178
   and     FLOW_CODE = 'ICX_INQUIRIES'
   and     FLOW_APPLICATION_ID = 178;