110: where employee_id = v_employee_id;
111:
112: cursor item_names(id number, org number) is
113: select concatenated_segments
114: from mtl_system_items_kfv
115: where INVENTORY_ITEM_ID = id
116: and ORGANIZATION_ID = org;
117:
118: cursor getCurrency is
797: v_oo_id number) is
798: select hecv.default_code_combination_id employee_default_account_id,
799: msi.expense_account
800: from hr_employees_current_v hecv,
801: mtl_system_items msi,
802: icx_shopping_carts isc,
803: icx_shopping_cart_lines iscl
804: where msi.INVENTORY_ITEM_ID (+) = iscl.ITEM_ID
805: and nvl(msi.ORGANIZATION_ID,